Sie befinden sich aktuell in den Archiven des Blogs Business Intelligence für November, 2007.
- Abstract (1)
- Geomapping (2)
- SAS Code (9)
- SAS Macros (2)
- SAS Procedures (3)
- SQL (1)
- SQL - Oracle (1)
- 26.4.2008: Export SAS data into XML File
- 18.11.2007: Import external data or files into SAS using wildcards
- 8.11.2007: SAS Enterprise Guide 4.x & Autoexec.sas
- 25.2.2007: Sample Size Calculation
- 20.1.2007: SAS: Contour Plot with PROC GCONTOUR
- 15.1.2007: SAS: Using GOTO Statement in Macro Steps
- 12.1.2007: Using email functions with SAS
- 11.1.2007: SAS: Geomapping Process (Maps based on ZIP Code)
- 11.1.2007: SAS: Import and Export Data
- 10.1.2007: Key Functions in Oracle SQL
BI News
SAS Forum
SAS Programming
Archive für November 2007
Import external data or files into SAS using wildcards
18.11.2007 von Thomas-Degenhardt.
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;
Geschrieben in SAS Code | 1 Kommentar »
SAS Enterprise Guide 4.x & Autoexec.sas
8.11.2007 von Thomas-Degenhardt.
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!
Geschrieben in SAS Code | Keine Kommentare »