topic Re: there is an error says import unsuccessful, See SAS Log for details. in SAS Programming

there is an error says import unsuccessful, See SAS Log for details.

QishengXia — Wed, 22 Nov 2023 17:23:19 GMT

libname testscan '/home/u63677777/self-test';

proc import datafile= '/home/u63677777/self-test/That.is.good.txt'
dbms = tab
out = testscan.hwscan
replace;
getnames = yes;
run;

Re: there is an error says import unsuccessful, See SAS Log for details.

mkeintz — Wed, 22 Nov 2023 17:26:13 GMT

And what did you see on the sas log? Please post it to help us help you.

Re: there is an error says import unsuccessful, See SAS Log for details.

QishengXia — Wed, 22 Nov 2023 18:35:02 GMT

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

69 libname testscan '/home/u63677777/self-test';

NOTE: Libref TESTSCAN was successfully assigned as follows:

Engine: V9

Physical Name: /home/u63677777/self-test

71 proc import datafile= '/home/u63677777/self-test/That.is.good.txt'

72 dbms = tab

73 out = testscan.hwscan

74 replace;

75 getnames = yes;

76 run;

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to

WORK.PARMS.PARMS.SLIST.

Unable to sample external file, no data in first 5 records.

ERROR: Import unsuccessful. See SAS Log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.03 seconds

user cpu time 0.02 seconds

system cpu time 0.02 seconds

memory 9582.56k

OS Memory 28444.00k

Timestamp 11/22/2023 06:33:39 PM

Step Count 24 Switch Count 6

Page Faults 0

Page Reclaims 4510

Page Swaps 0

Voluntary Context Switches 50

Involuntary Context Switches 0

Block Input Operations 0

Block Output Operations 72

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

User: u63677777

Messages: 1

Re: there is an error says import unsuccessful, See SAS Log for details.

Kurt_Bremser — Wed, 22 Nov 2023 18:50:34 GMT

This is your clue:
Unable to sample external file, no data in first 5 records.
PROC IMPORT cannot make sense of the file, inspect it with a text editor.
What does the description of the file say about its structure?

Re: there is an error says import unsuccessful, See SAS Log for details.

Tom — Wed, 22 Nov 2023 20:31:50 GMT

So what is in the first five lines??

You can ask SAS to SHOW you.

data _null_;
  infile '/home/u63677777/self-test/That.is.good.txt' obs=5;
  input;
  list;
run;