GLOBAL INSIGHT:DRI/McGraw-Hill Format CITIBASE Files, OUTSELECT=ON
/*--------------------------------------------------------------
SAS Sample Library
Name: datex04c.sas
Description: Example program from SAS/ETS User's Guide,
The DATASOURCE Procedure
Title: GLOBAL INSIGHT:DRI/McGraw-Hill Format CITIBASE Files, OUTSELECT=ON
Product: ETS SAS/ETS Software
System: ALL
Keys: DATASOURCE data extraction from various sources
Procs: DATASOURCE
Data: sasmisc: citidem.dat (DATASOURCE database files)
Notes: Read this before you run this sample.
The database resides in the ets/sasmisc folder. You
must copy the database to a writeable folder before
using it. Then define your Windows system environment
variable, DATASRC_DATA, to the path of your
writeable folder containing
the citidem.dat file.
To assign a fileref to the external file to be processed,
use the following form of the filename statement:
filename citidemo "%sysget(DATASRC_DATA)citidem.dat" RECFM=D LRECL=80;
--------------------------------------------------------------*/
filename citidemo "%sysget(DATASRC_DATA)citidem.dat" RECFM=D LRECL=80;
proc datasource filetype=citibase infile=citidemo
interval=week
outall=allon outby=keyon outselect=on;
keep WSP:;
run;
title1 'Summary Information on Weekly Data for CITIDEMO File';
proc print data=keyon;
run;
title1 'Weekly Series Available in CITIDEMO File';
proc print data=allon( keep=name kept selected st_date
end_date ntime nobs );
run;