Learn and Debug SAS® Procedures

 

Below is the current list of general SAS Procedures based on their strengths. In general, SAS papers are references by the primary category to avoid any duplications.  

Expect more SAS Procedures to be added soon. New to SAS Programming? See Statsitical Procedures.


SAS® Procedure

Brief Description of Strength

Proc Append

Add records from second dataset to first dataset

Proc Contents/

Proc Print


Display intermediate datasets, apply where condition as needed.

Proc Compare

Compare and contrast dataset attributes and values between two datasets.


Proc Cport/Proc Cimport

Convert datasets and catalog files to transport files to be used across different operating systems


Proc Datasets

Dataset utility procedure


Proc Document


Proc Expand and SAS Dates


Create records to fill date gaps.
Proc Export 

Writes to an external data source such as an excel files

PROC EXPORT DATA=mydata.movies OUTFILE='c:\Movies.xls' DBMS=EXCEL REPLACE;

RUN;


Proc Format

Create user defined formats



Proc Import

Access external files such as excel files.  See SAS Access to external files.  See SAS paper.

PROC IMPORT OUT=mydata.movies DATAFILE='c:\Movies.xls' DBMS=EXCEL2002 REPLACE;

RUN;


Proc Printto

Write to external files.  See SAS Access to external files.


Proc Sort

Sort dataset


Proc Transpose

Convert records to variables or variables to records.


Powered by Wild Apricot Membership Software