Rank Beginner: Help with PROC IMPORT

[explenture]

Using this code:

*read excel using proc import;
libname sasfiles 'C:\saslib';
proc immport data file=c:\MyExcel\houses.xlsx out=h1 dbms=xlsx replace;

It says PROCEURE IMPORT NOT FOUND

Using SAS studio/SAS on demand for academics

How do I fix this?

[ballardw]

---

@explenture wrote:

Using this code:

*read excel using proc import;
libname sasfiles 'C:\saslib';
proc immport data file=c:\MyExcel\houses.xlsx out=h1 dbms=xlsx replace;

It says PROCEURE IMPORT NOT FOUND

Using SAS studio/SAS on demand for academics

How do I fix this?

---

Look VERY closely at the log message. Does is say "Procedure IMPORT" or "Procedure IMMPORT"?

Hopefully you can copy text from the LOG where those messages occur. Paste that text, the entire procedure code and messages into a text box opened on this forum with the </> icon to show us the exact message and submitted code.

If you are using SAS On Demand it does not see your hard drive at all. You have to upload your files to the work space and then import there. Similarly Libraries won't be created on your hard drive, only on the work space in On Demand.

[explenture]

*read excel using proc import;
libname sasfiles 'C:\saslib';
proc immport data file=c:\MyExcel\houses.xlsx out=h1 dbms=xlsx replace;
OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 *read excel using proc import;
74 libname sasfiles 'C:\saslib';
NOTE: Library SASFILES does not exist.
75 proc immport data file=c:\MyExcel\houses.xlsx out=h1 dbms=xlsx replace;
ERROR: Procedure IMMPORT not found.
76
77
78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
90

[Reeza]

• Spelling mistake IMMPORT versus IMPORT - extra M
• Datafile is one word not two, extra space
• Path should be in quotes, though I think because you have no spaces it will still work. 
• You assign a library but don't use it. I'll assume that's on purpose for now. So you're importing the data to your WORK library not SASFILES and it will dissappear once you end your session.

*permanent library to save files;
libname sasfiles 'C:\saslib';

*import raw data, Houses, into work library;
proc import datafile="c:\MyExcel\houses.xlsx" out=h1 dbms=xlsx replace;
run;