proc-sql Examples and Free Source Code

How to count distribution in numbers and percent of binary column in table?...

sql sas proc-sql enterprise-guide 4gl

How to choose more important value from one column for value in corresponding column in SAS Enterpri...

sql sas proc-sql enterprise-guide 4gl

How to create binary column base on values in other column and drop duplicates in SAS Enterprise Gui...

sas proc-sql enterprise-guide

SAS - Determine if group of columns contains any value of a set...

filter sas proc-sql datastep

How to run a different query if table is empty one month earlier...

sql sas proc-sql

How to aggregate character data by assigning weights to them in SAS Enterprise Guide or SAS PROC SQL...

sql sas proc-sql enterprise-guide 4gl

How to make multiple conditional statements in SAS...

sql sas proc-sql

How to aggregate table to take minimum VALUE for each combination of 2 other columns in SAS Enterpri...

sql sas proc-sql enterprise-guide 4gl

How to check max difference in dates between events and create new column in SAS Enterprise Guide?...

date sas proc-sql enterprise-guide 4gl

Making simple calculations across rows and columns in SAS...

sql sas proc-sql

How to count how many time some value appeard with defined ID in PROC SQL in SAS Enterprise Guide?...

sql sas proc-sql enterprise-guide 4gl

How to create flag 0/1 inform whether was changed or not during 4 months between two columns in PROC...

sql time sas proc-sql enterprise-guide

How to create 0/1 flag witch infrom whether values were changed between 2 column in some dates in PR...

sql date sas proc-sql enterprise-guide

How to create flag inform whether was some change in two columns on ID in PROC SQL in SAS Enterprise...

sql time sas proc-sql enterprise-guide

How to add/subtract weeks to the third day of the week?...

sql snowflake-cloud-data-platform proc-sql

Convert character date to SAS date...

date sas format proc-sql datastep

Splitting a cell up using delimiters, but the delimiter is before the desired split location...

sas proc-sql

How to create column with date type date9. using case when in SAS Enterprise Guide 8.2?...

date sas format proc-sql enterprise-guide

macro for proc sql select into, good for i=1 but not i=2...

sas sas-macro proc-sql

SAS proc transpose duplicate values issue...

sas proc-sql

Changing a datetime by -1 if included in a list until it is not included in the list anymore...

sql sas proc-sql enterprise-guide

Create PROC SQL column in macro...

sas sas-macro proc-sql

Deleting rows based on multiple columns conditions...

sas proc-sql

Getting Current date in SAS in YYMMDD10. Format in Date Datatype...

date sas varchar proc-sql

Subtracting dates in Proc SQL/SAS...

sql date sas db2 proc-sql

Creating dummy date records between two date ranges...

sas proc-sql

Outputting specific results from data check using PROC SQL...

sas proc-sql

PROC SQL: Warning variable already exists on multiple dataset join...

sas proc-sql

Creating an indicator based on the same ID in different years in PROC SQL/SQL...

sql proc-sql

Return Last Day of Month using Proc SQL in SAS...

sas proc-sql