Tag Archives: Data Preparation

Proc SQL – SAS

SQL stands for “Structured Query Language”. It’s a language created for interacting with relational databases. SAS implements a version of this inside proc sql. This allows us to leverage the power of SQL to solve our problems. proc sql; create table out.projdata2 as select a,b,c,d, /* vars from source */ a^2 as aa, /* New […]

Data Processing in SAS

Libraries Libraries are directories where your datasets are stored. It is a good idea to declare a local library where you want store the dataset after you’re done processing it. They can be declared with the libname function. Here i declare the library out. Any datasets stored in this library can be accessed by preceding […]