Dead Urgent... Please respond immediately

Siddhartha — Wed, 12 Dec 2007 14:56:52 GMT

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)

Re: Dead Urgent... Please respond immediately

Cynthia_sas — Wed, 12 Dec 2007 16:10:30 GMT

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

topic Dead Urgent... Please respond immediately in ODS and Base Reporting

Dead Urgent... Please respond immediately

Re: Dead Urgent... Please respond immediately