topic Re: Import Unsuccessful in New SAS User

Import Unsuccessful

vinsonros — Wed, 21 Dec 2022 06:52:25 GMT

Iam using proc import procedure to import .txt file to SAS.

The text file is in my desktop. The following is the code.

proc import datafile="/Desktop/Sample.txt"

out=new_sample

dbms=dlm

replace;

guessingrows=2;

getnames=no;

run;

The log error is given below

ERROR: Import unsuccessful. See SAS Log for details.

Is there something wrong in the way I have imported the file??. Kindly support.

Re: Import Unsuccessful

fja — Wed, 21 Dec 2022 07:37:21 GMT

Good Morning ... could you provide the log file, pls (as indicated)? And maybe the first couple of lines of your input file ...
--fja

Re: Import Unsuccessful

LinusH — Wed, 21 Dec 2022 10:33:25 GMT

Hi,

Where is SAS actually executing?

And the search path to your file doesn't look like a desktop location.

As mentioned, a complete log would help.

Re: Import Unsuccessful

D_Dunlap — Wed, 21 Dec 2022 11:46:36 GMT

Hello @vinsonros,
I'm guessing without seeing the full log that there is also a message in the Log stating ERROR: Physical file does not exist, \Desktop\Sample.txt. Here is a tip to help you locate the full path of the .txt file that is needed for the datafile= option.

Locate the file on the Desktop
Right click the file.
Select Properties
Copy and paste the value in the Location: field in the Properties window for the file into the datafile="Copy-paste-location-here/Sample.txt" option.
Try submitting the code again.

Re: Import Unsuccessful

vinsonros — Thu, 22 Dec 2022 15:22:20 GMT

Hi all,

Thanks for the reply.

Please find the attached log as requested.The following is the program run. This program run in Sas studio.

proc import datafile="C:/Users/acer/Desktop/Sample.txt"

out=vin_blanks4

dbms=dlm

replace;

guessingrows=2;

getnames=no;

run;

Re: Import Unsuccessful

Tom — Thu, 22 Dec 2022 16:05:19 GMT

There is no need to attach text as FILES. Just paste into the pop-up window opened by the Insert Code icon.

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/C:/Users/acer/Desktop/Sample.txt.

The reason it did not work is that there is no file with that name on the machine where SAS is running.

It looks like you tried to ask SAS to find a file on your machine instead of one on the machine where SAS is running. Since the filename did not start with the root node Unix interpreted it as a relative file name so it looked for that a directory named C: under the current working directory that was in effect with SAS started.

Upload the file to your SAS machine first and then use a path in the SAS code that points to where you put the file.

Re: Import Unsuccessful

Kurt_Bremser — Thu, 22 Dec 2022 16:06:36 GMT

This is your clue (as usual, the first error message is the most important):

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/C:/Users/acer/Desktop/Sample.txt.

You try to use a Windows path, while your SAS runs on a remote UNIX server.

Either upload the file to the server (both SAS Studio and Enterprise Guide can do this), or store it on a network share accessible both from your desktop and the SAS server.

If you use a licensed SAS install at your company/institution, get in touch with your SAS admins. If this happens on SAS On Demand, upload the file with SAS Studio and import from the upload location.

Re: Import Unsuccessful

Tom — Thu, 22 Dec 2022 16:12:07 GMT

There is no need to use PROC IMPORT to read a simple file like that.

vineeth 85 35 Suceess
Rosu 95 55 Failure
Ryan 35 25 Sucess
Sonny 45 21 Sucess

Just write the code yourself, you will do a MUCH better job than PROC IMPORT could.

data want;
  infile '~/Sample.txt' truncover;
  input name :$20. var1 var2 status :$10. ;
run;

Re: Import Unsuccessful

vinsonros — Fri, 23 Dec 2022 07:10:50 GMT

Hi,

Thanks for the code.

I am in the learning stage now just would like to see whether proc import procedure is working in the system and why the error is being shown in the pgm.

Part of the learning process:)

Re: Import Unsuccessful

fja — Fri, 23 Dec 2022 08:58:13 GMT

why the error is being shown in the pgm

Hello!

As indicated already by the others: Your program cannot find the file under the path and name you have provided in the code.

When looking at the log message it seems that you try to use a windows path on a unix machine (where sas runs). That is, you need to make the file available to sas first and than use the filename under which sas sees the file.

In other words: You need to upload the file to the sas machine (or use some shared folders) so that you find it listed in SAS Studio. And the properties of _that_ file (again via SAS) reveal the path and filename you need to use in your in your program.

--fja