Archive für November 2007

Import external data or files into SAS using wildcards

If you want to import all files of a folder with a specific name or type you can use wildcards to store them in a SAS dataset.
You can use this example:

/*
this datastep will import all
ASC files of the specified folder
*/
data WORK.share;
infile ‘D:\yourPath\*.asc’
delimiter=’09′x
MISSOVER
DSD
lrecl=32767 ;
format date mmddyy10. ;
informat date mmddyy10. ;
input
date
;
run;

SAS Enterprise Guide 4.x & Autoexec.sas

If you have problems using the autoexec.sas in combination of SAS Enterpise Guide you can use my instructions:

1. run Enterprise Guide
2. Click on Tools
3. Click on Enterprise Guide Explorer
4. In the Folder “Servers” right click on the SAS Server of your choice
5. If possible click on “Disconnect” otherwise click on “Properties”
6. Click on Options then you can type in a “SAS startup statement”
7. Here you type in the startup instruction for your autoexec.sas.
For Example:
%include ‘/path/autoexec.sas’;
Don’t forget the semicolon!

|