The SAS Output Delivery System and reporting techniques

Dead Urgent... Please respond immediately

Reply
Contributor
Posts: 69

Dead Urgent... Please respond immediately

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)
SAS Super FREQ
Posts: 8,863

Re: Dead Urgent... Please respond immediately

Posted in reply to Siddhartha
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
Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 0 likes
  • 2 in conversation