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.