topic Re: Coding in SAS EG 4.1 in SAS Enterprise Guide

Coding in SAS EG 4.1

deleted_user — Thu, 02 Oct 2008 18:28:31 GMT

I have had some success in importing .csv file (AUG 5) in SAS using this code

proc import datafile="D:\Data\Desktop\AUG 5.csv"
out=mydata
dbms=dlm
replace;
run;
proc print data=mydata;
run;

I'm not having any success when I convert the same file AUG 5 in Excel format (AUG 5.xls) and try to import it.

proc import datafile="D:\Data\Desktop\AUG 5.xls"
out=mydata
dbms=dlm
replace;
run;
proc print data=mydata;
run;

I keep getting an error msg 'File WORK.MYDATA.DATA does not exist !
Is my coding wrong, Please help with the correct code for excel.
Jay

Re: Coding in SAS EG 4.1

deleted_user — Thu, 02 Oct 2008 19:31:49 GMT

You could find a solution at
http://support.sas.com/kb/6/976.html

Re: Coding in SAS EG 4.1

LinusH — Fri, 03 Oct 2008 07:15:13 GMT

Or here:

http://support.sas.com/kb/10/818.html
http://support.sas.com/kb/6/024.html
http://support.sas.com/kb/5/704.html

/Linus