Search code examples
Subtracting dates in Proc SQL/SAS...


sqldatesasdb2proc-sql

Read More
Creating dummy date records between two date ranges...


sasproc-sql

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


sasproc-sql

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


sasproc-sql

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


sqlproc-sql

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


sasproc-sql

Read More
How to use a SAS Macro inside data step...


sassas-macroproc-sqldatastep

Read More
Skip/Ignore a condition in CASE statement in SQL...


sqlsasdb2caseproc-sql

Read More
SAS Server behaving strangely...


sqlsasproc-sql

Read More
How to merge three tables by different conditions?...


joinmergesastime-seriesproc-sql

Read More
How to multiply and merge two tables in SAS using a bridge table?...


joinmergesaslookupproc-sql

Read More
How to write proc sql without windowfunction over partition by sum?...


sqlsasprocproc-sql

Read More
How to use SAS - PROC SQL, IF THEN statement and a Do loop in 1 script?...


if-statementsassas-macroproc-sqldo-loops

Read More
PROC Transpose by YearMonth and ID for duplicate values...


sasproc-sql

Read More
Where not equals not filtering anything out...


saswhere-clauseproc-sql

Read More
Excluding all records of the same ID if any record with that ID meets two conditions...


sasproc-sql

Read More
Selecting the maximum date before a certain year...


sqlsasproc-sql

Read More
Proc SQL not joining properly...


sqlproc-sql

Read More
Convert time (date type) to numeric in proc SQL (SAS)...


sasproc-sql

Read More
Translating a SQL update to SAS DI...


sasproc-sqlsas-dis

Read More
How to add leading zeros to macro variable?...


loopssassas-macroproc-sql

Read More
SAS code - sum of last N rows for every row...


sasproc-sqldo-loopsdatastep

Read More
Recreate Tableau function FIXED in SAS proc SQL...


sasproc-sql

Read More
Get most recent record from Right table with sub query...


sqloracle-databasesasproc-sql

Read More
Read in the following table format: no tablehead, [date] colum1=xy colum2=abs colum4=iy...


oracle-databasesasproc-sqldatastep

Read More
SAS PROC SQL where between 4 mondays ago and last monday...


sql-serverdatesasbetweenproc-sql

Read More
SQL CASE exist then value...


sqlsascaseexistsproc-sql

Read More
Select the onset date of a disease based on the number of visits...


sqlsasproc-sql

Read More
SAS filter dates one column if between (min, max) dates of another column...


sasproc-sql

Read More
How to concatenate some elements in sql...


sqldatabasesasconcatenationproc-sql

Read More
BackNext