Top "Proc-sql" questions

SQL Passthrough in SAS

Are there any advantages of using SQL Passthrough facility along with SAS?

sql sas proc-sql

SAS datastep/SQL select latest record from multiple records with same ID

For example I have a dataset as below: id Date 1 2000/01/01 1 2001/01/01 1 2002/01/01 2 2003/01/01 By datastep or sql, how could I get the record …

sql sas proc-sql datastep

How to count distinct of the concatenation/cross of two variables in SAS Proc Sql?

I know in teradata or other sql platforms you can find the count distinct of a combination of variables by …

sas proc-sql

SAS PROC SQL NOT CONTAINS multiple values in one statement

In PROC SQL, I need to select all rows where a column called "NAME" does not contain multiple values "abc", "…

sql sas proc-sql

HAVING clause without grouping by all non-aggregate columns in SELECT

HAVING clause without grouping by all non-aggregate columns in SELECT I am often faced with tables that have an id …

sql sas proc-sql

SAS to Oracle ODBC - passing a SAS table INTO the database

Can anyone please advise the syntax for passing a table FROM a SAS library INTO an oracle database? example code …

oracle odbc sas proc-sql

SAS proc sql returning duplicate values of group by/order by variables

I have some fairly simple SQL that should provide 1 row per quarter per asset1. Instead, I get multiple rows per …

sql sas proc-sql