ISP

International Software Products

Home  |   Products & Services  |  Support   |   Offices   |   Partners   |   Contact Us

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



All Trademarks Acknowledged

Copyright 2012 International Software Products. All Rights Reserved.