Search code examples
SAS Replace Row if value is greater than what exists and add any new rows...


saswhere-clauseunionproc-sqlnot-exists

Read More
Fixing "The query requires remerging summary statistics back with the original data" in SA...


sqlms-accesssasproc-sql

Read More
loop macro for dates to run a SAS query...


sasteradatasas-macroproc-sqldo-loops

Read More
Find differences across two datasets...


sqlteradataproc-sql

Read More
How to group records so the groups contains only specific variables? (proc sql)...


sqlcountsashavingproc-sql

Read More
How to select duplicates rows with duplicates in each column in SAS Enterprise Guide?...


sasproc-sqlenterprise-guide4gl

Read More
How to select only these rows where values in all column all the same in SAS Enterprise Guide?...


duplicatessasproc-sqlenterprise-guide4gl

Read More
SAS: Translate code from proc SQL, regarding counter of distinct pair of variables from a dataset...


sasproc-sql

Read More
Use macro variable in macro function to filter data...


sassas-macroproc-sql

Read More
How to remove characters after defined character in PROC SQL in SAS Enterprise Guide?...


sasproc-sqlenterprise-guide4gl

Read More
Flag accounts on the basis of Previous entry...


sasdata-analysissas-macroproc-sqlenterprise-guide

Read More
Need help finding overlapping dates between two tables and creating a Y/N flag in SAS...


sasproc-sql

Read More
How to calculate mean values per values in other column in one PROC SQL query in SAS Enterprise Guid...


sasaverageproc-sqlenterprise-guide4gl

Read More
SAS Apparent symbolic reference when there is a n ampersand in data...


sasproc-sql

Read More
Flag accounts on the basis of reapplication logic ( case of multiple entries by one person)...


sasdata-analysissas-macroproc-sqlenterprise-guide

Read More
How to create column with name of column with the highest value per each ID in SAS Enterprise Guide ...


sasaggregationproc-sqlenterprise-guide4gl

Read More
How to create new columns with names of columns with values in descending order in SAS Enterprise Gu...


sasaggregationproc-sqlenterprise-guide4gl

Read More
How to aggregate number of occure each value per column in table in SAS Enterprise Guide?...


sasaggregateproc-sqlenterprise-guide4gl

Read More
Find top N per category using Proc SQL...


sasproc-sqldense-rank

Read More
How to aggretage col1 per ID and val1 per ID and values in col1 in SAS Enterprise Gude or PROC SQL?...


sasaggregateproc-sqlenterprise-guide4gl

Read More
Optimize proc sql statements in SAS...


sasproc-sql

Read More
INTNX in PROC SQL...


sasproc-sql

Read More
Remove records based on conditions in SAS...


sasproc-sql

Read More
How to drop columns with specific suffixes from a SAS table in SAS?...


sasproc-sql

Read More
How to remove columns specified in an Excel file from a SAS table?...


sasproc-sqlimport-from-excel

Read More
How to remove duplicates based on multiple columns in SAS?...


sasduplicatesproc-sql

Read More
sas proc sql having with condition for positive and negative values...


sasproc-sql

Read More
How to delete variables with huge percent of missings in table in SAS?...


sasmissing-dataproc-sql4gl

Read More
How to join on multiple conditions in SQL?...


sqlsasproc-sql

Read More
How to extracting all values that contain part of particular number and then deleting them?...


sassas-macroproc-sql

Read More
BackNext