Top "Sas" questions

How can I read a SAS dataset?

I have a lot of files in SAS format, and I'd like to be able to read them in programs …

sas

Treat missing values as zero in SAS where clause

Is there an equivalent of the Oracle NVL function in SAS? For example, if I have a where clause in …

sas

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

How to remove duplicated records\observations WITHOUT sorting in SAS？

I wonder if there is a way to unduplicate records WITHOUT sorting?Sometimes, I want to keep original order and …

sorting sas duplicates

Is there a way to make SAS stop upon the first warning or error?

SAS likes to continue processing well after warnings and errors, so I often need to scroll back through pages in …

sas

How to import a CSV file with delimiter as ";" and decimal separator as "," into SAS?

I`ve got (and will receive in the future) many CSV files that use the semicolon as delimiter and the …

csv sas decimalformat

Writing Efficient Queries in SAS Using Proc sql with Teradata

EDIT: Here is a more complete set of code that shows exactly what's going on per the answer below. libname …

sql sas teradata

SAS variable concatenation through data step

I am looking for a way to create a string variable containing certain values of the dataset while going through …

variables sas sas-macro datastep

Open SAS .egp file to view code without having SAS installed

Is there any solution to open SAS .egp file without having SAS installed on my pc? I need to open …

sas enterprise-guide

Is there a way to detect when you've reached the last observation in a SAS DATA step?

Is there a way to check how many observations are in a SAS data set at runtime OR to detect …

sas