Simple Data Extracts (SDE)

Quick and Easy SAS® File Data Extraction

Features:

Implemented as a standard SAS® PROC to simplify both installation and operation
Optional 'WHEN' clauses
SAS® Variable selection
Data conversion with FORMAT statements
Width parameter to vary output field size
NULLS option to add null fields to output
CSV, PRN and DIF output formats

The following sample of SDE code is designed to show how SDE can be used

SAMPLE#1 This very simple code builds a SAS® file and then extracts only two fields to a CSV format file
DATA T1 ; INFILE CARDS INPUT SASCH1 $10. +1 SASNUM1 5. ; FORMAT SASCH1 $CHAR5. ; FORMAT SASNUM1 5.2. ; CARDS ; ABSDEFGHIJ 12345 ; PROC SDE ; CONTROL CSV ; SELECT SASCH1 FORMAT ; SELECT SASNUM1 FORMAT ;
The output file will contain the data in CSV format as follows: "ABCDE",123.45

SAMPLE#1

This very simple code builds a SAS® file and then extracts only two fields to a CSV format file

DATA T1 ; INFILE CARDS
INPUT SASCH1 $10. +1 SASNUM1 5. ;
FORMAT SASCH1 $CHAR5. ;
FORMAT SASNUM1 5.2. ;
CARDS ;
ABSDEFGHIJ 12345 ;
PROC SDE ;
CONTROL CSV ;
SELECT SASCH1 FORMAT ;
SELECT SASNUM1 FORMAT ;

The output file will contain the data in CSV format as follows:

"ABCDE",123.45