Top "Proc-sql" questions

Limiting results in PROC SQL

I am trying to use PROC SQL to query a DB2 table with hundreds of millions of records. During the …

sas proc-sql

How to convert date in SAS to YYYYMMDD number format

In test_1 table, the my_date field is a "DATE9." format. I would like to convert it to a pure …

sas proc-sql

convert datetime to date in proc-sql sas

I'm trying to convert datetime22.3 variable to ddmmmyy10. in proc sql, this is giving me ****** in the output column. How …

sas proc-sql

LEFT JOIN in SAS using PROC SQL

I am new to SAS and have this basic problem. I have a list of NYSE trading dates in table …

join sas left-join proc-sql

Dropping a table in SAS

What is the most efficient way to drop a table in SAS? I have a program that loops and drops …

sas proc-sql drop-table

Extract left part of the string in SAS?

Is there a function SAS proc SQL which i can use to extract left part of the string.it is …

sas proc-sql

How to find the length of a numerical variable using PROC SQL

I have a dataset with a column of phone numbers. I want to filter this dataset using PROC SQL WHERE …

sql sas numerical string-length proc-sql

SAS Proc sql row number

How do I get the row number of an observation in proc sql, similar to _N_ for a datastep in …

sql sas proc-sql

SAS Proc SQL Database Table Insert

Using SAS's Proc SQL, is there a way to insert records from a SAS Dataset into a table in the …

insert sas proc-sql

SAS data step/ proc sql insert rows from another table with auto increment primary key

I have 2 datasets as below id name status 1 A a 2 B b 3 C c Another dataset name status new C …

sas proc-sql datastep