Top "Sas" questions

The SAS language is a 4GL that underpins the SAS system, a suite of products centered around data processing and statistical procedures.

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
SQL Passthrough in SAS

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

sql sas proc-sql
Set multiple datasets with similar names in sas

Suppose I have a varying number of datasets in my work environment, but all of which start with a similar …

sas datastep
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
SAS: formats/informats/types. Their differences

another question about formats and informats: formats are using for output (for show me and other user data in tables), …

types format sas informat
How to automatically assign libraries in SAS Enterprise Guide?

In the Server List of my SAS Enterprise Guide session I have a white (unassigned) library which I can right-click …

sas enterprise-guide
SAS proc export to CSV: how to add double quotes

New to this, so apologies. I have a file in SAS that I need to export as a CSV and …

csv sas
SAS Display Manager commands

The SAS display manager is a comamnd line interface to the SAS system, which remains in Base SAS as a …

command-line sas display-manager dm
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
Export pandas dataframe to SAS sas7bdat format

The flow I have in mind in this: 1. Export a sas7bdat from SAS 2. Import that file in python with …

pandas sas