Learning SAS? Welcome to the exclusive online community for all SAS learners.

New University Edition user stuck on Proc Import

Reply
New Contributor
Posts: 4

New University Edition user stuck on Proc Import

Hi,

I need help in Proc Import.

Thanks very much,

BB

 

Here is my code:

LIBNAME HOSPICE ' C:\USERS\BRENDA\ALEXA ';
LIBNAME LIBRARY ' C:\USERS\BRENDA\ALEXA ';
*import N_1505_UNIVERSITY;
PROC IMPORT DATAFILE= " C:\USERS\BRENDA\ALEXA\N_1505.xlsx "
DBMS=XLSX OUT= HOSPICE.N_1505;
RANGE=" Sheet1$ ";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

 

Here is my Log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 LIBNAME HOSPICE ' C:\USERS\BRENDA\ALEXA ';
NOTE: Libref HOSPICE refers to the same physical library as LIBRARY.
WARNING: Library HOSPICE does not exist.
NOTE: Libref HOSPICE was successfully assigned as follows:
Engine: V9
Physical Name: /opt/sasinside/SASConfig/Lev1/SASApp/C:\USERS\BRENDA\ALEXA
63 LIBNAME LIBRARY ' C:\USERS\BRENDA\ALEXA ';
NOTE: Libref LIBRARY refers to the same physical library as HOSPICE.
WARNING: Library LIBRARY does not exist.
NOTE: Libref LIBRARY was successfully assigned as follows:
Engine: V9
Physical Name: /opt/sasinside/SASConfig/Lev1/SASApp/C:\USERS\BRENDA\ALEXA
64 *import N_1505_UNIVERSITY;
65 PROC IMPORT DATAFILE= " C:\USERS\BRENDA\ALEXA\N_1505.xlsX "
66 DBMS=EXCEL OUT= HOSPICE.N_1505;
ERROR: DBMS type EXCEL not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
 
67 RANGE=" Sheet1$ ";
68 GETNAMES=YES;
69 MIXED=NO;
70 SCANTEXT=YES;
71 USEDATE=YES;
72 SCANTIME=YES;
73 RUN;
74
75
76 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
89
 
Herre are sample data:
 
pt_ref_numRef_SourceCriteria_hospice_admagesexMarital_StatusPoverty_QuintileRaceandEthnicityLiving_StatusLanguagePayerDiseaselosKPS
101411881222211125999
1023117012232199150999
106111492234222186999
107511481223213150999
11401181124999913110999
1150116821139913136999
Super User
Posts: 18,588

Re: New University Edition user stuck on Proc Import

[ Edited ]

1. Did you set up the shared folders as noted in the instructions?

2. Did you place your files there?

3. Did you check how to properly reference the files and set up a library in the SAS UE Help Centre or the Analytics U forum? 

 

The second link below has the answer to your question, and some more links you may find helpful as you start using SAS. If you're still having trouble please do post back though.

 

 

University Edition FAQ

https://support.sas.com/software/products/university-edition/faq/main.htm

 

University Edition FAQ - Import files

https://support.sas.com/software/products/university-edition/faq/SAS_accessdata_Excel.htm

 

Video tutorials

support.sas.com/training/tutorials

 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 129 views
  • 1 like
  • 2 in conversation