Software Products
| Home | Products | Support | FTP Site | Offices | Partners | Contact Us |
|
International Software Products |
|
| 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 |
| Copyright 2008 International Software Products. All Rights Reserved. |