Lab Sql

EDIT: Here is a more complete set of code that shows exactly what's going on per the answer be… Read more Writing Efficient Queries In Sas Using Proc Sql With Teradata

I'm trying to transpose a variable in Hive such as: Id1 Id2 Event 1 1 7 2 2 3 2 … Read more Transpose Dataset In Hive

I have some fairly simple SQL that should provide 1 row per quarter per asset1. Instead, I get mul… Read more Sas Proc Sql Returning Duplicate Values Of Group By/order By Variables

So I have a table that has different days and didfferent hours in each day, and the client ID can a… Read more Create Variable That Counts Progressively How Many Times An Id Is Repeated In A Day

question was resolved Proc SQL not returning any columns. Innerjoin thanks to TOM. I appreciated th… Read more Sas Proc Sql Innerjoin Returning No Columns

This is my first post, so please let me know if I'm not clear enough. Here's what I'm t… Read more Sas Do Loop + Lag Function?

As suggested in the title, I'd like to drop all empty columns\variables(where all records are e… Read more How To Detect All Empty Columns In A Dataset And Delete\drop Them?

I am new to SAS and I am trying to remove groups if they fulfil two conditions. I currently have th… Read more Sas/proc Sql - Remove All Observations In By Group As Long As There Are Duplications (not Just Remove The Duplications)

I need to perform a LEFT JOIN to bring in a variable from table B to A by joining on the date with … Read more Join Tables Based On Lagged Date

I am using intnx function. date1=intnx('qtr','01APR2021'd,0,'b'); I am thi… Read more How To Calculate The Number Of Days Of First Week Of The Month In Sas.if We Consider Saturday As First Week Day

I'm trying to use the following SQL query (in SAS) to find any records from pool1 that do not e… Read more Sql - Not Exists Query With Millions Of Records

Firstly I have the following table: data dataset; input id $ value; datalines; A 1 … Read more Sas Proc Sql Inside %macro

I would like to know how to combine different SQL queries into one table. The format should be … Read more Combine Different Sql Into One Table Using Sas

I am trying to find out tax values for a particular good in a particular city in a particular state… Read more Proc Sql Vs Data Step For Looking Up Values Form A Reference Table That Includes Exceptions

hi guys i need to merge two tables in Sas but with a condition like in a sql merge statement: MERGE… Read more Similar Statement To Merge Sql In Sas

Firstly I have the following table: data dataset; input id $ value; datalines; A 1 … Read more SAS Proc Sql Inside %macro

I'm trying to transpose a variable in Hive such as: Id1 Id2 Event 1 1 7 2 2 3 2 … Read more Transpose Dataset In Hive