BookmarkSubscribeRSS Feed
Siddhartha
Calcite | Level 5
SAS 9.1 import wizard is having problem with excel file imports, it works ok for .txt files.
I was using the same files to work in SAS in Oct this year , it worked well.
Now, I tried using both the import wizard and command line approach, same result.
This is the sas log message which I get -


1 PROC IMPORT OUT= WORK.fam
2 DATAFILE= "C:\Documents and Settings\RU46493\Desktop\PD\LRRK2_11085.xls"
3 DBMS=EXCEL REPLACE;
4 SHEET="'G2019S-all$'";
5 GETNAMES=YES;
6 MIXED=NO;
7 SCANTEXT=YES;
8 USEDATE=YES;
9 SCANTIME=YES;
10 RUN;

ERROR: Connect: 
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.54 seconds
cpu time 0.17 seconds


Also for some reason, after I reinstalled SAS ( thinking it might sort the problem )it has gone to -

Expiration: 31DEC2005.
Grace Period: 45 days (ending 14FEB2006).
Warning Period: 45 days (ending 31MAR2006)
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
This is not the forum for IMPORT Wizard problems -- since the IMPORT Wizard is not generally involved in ODS and Base SAS Reporting (PRINT, REPORT, TABULATE) production of reports.

If you are having trouble with PROC IMPORT and/or need a SETINIT, your best and fastest resource is to open a track with Tech Support. To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".

cynthia

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 663 views
  • 0 likes
  • 2 in conversation