topic Re: Physical file does not exist in New SAS User

Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 18:24:46 GMT

Hello there! i am a new SAS user and I am trying to import a CSV file...I have already created a folder in SAS where the csv file is..The problem is that when I press run, it keeps saying physical file does not exist...The folder name is rapid_syphilis and the csv in it is named sample_8.3.2020...

Here is my code:

/*import a CSV file*/

%let path=S:\CSV Import;

options validvarname=v7;

proc import datafile="&path\rapid_syphilis.csv"

out=syphilis

dbms=csv replace;

run;

Re: Physical file does not exist

PaigeMiller — Tue, 04 Aug 2020 18:54:11 GMT

When you have a macro variable that has a value of S:\CSV Import then your code uses it in this line

proc import datafile="&path\rapid_syphilis.csv"

and so &path is replaced by S:\CSV Import and so now SAS is looking for the file

S:\CSV Import\rapid_syphilis.csv

and the ERROR message you are getting is that this file does not exist. You are pointing in the wrong folder, or you have the wrong file name.

Side issue: you don't need a macro variable here at all. Just get rid of it and type in the correct folder and file name in PROC IMPORT. Especially for a beginner, it's easier to get the file name and folder correct by typing it in yourself than by resorting to a macro variable.

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 18:56:17 GMT

Now it is giving me a syntax error for:

proc import datafile= s:\CSV Import\rapid_syphilis.csv

The line is under the colon..it says it is not recognized and will be ignored

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:03:44 GMT

Also, when I change the colon to semicolon...It says output SAS data set must be provided

Re: Physical file does not exist

PaigeMiller — Tue, 04 Aug 2020 19:07:40 GMT

First, I don't think you have actually stated that s:\CSV Import\rapid_syphilis.csv actually exists, and SAS thinks it doesn't exist, so I believe SAS.

Show us the LOG from this portion of the code. Do not chop anything out. Copy the log as text and then use the </> icon here to open a window which the log should be pasted into — do not skip this step.

Re: Physical file does not exist

Reeza — Tue, 04 Aug 2020 19:10:24 GMT

Does the code work without any macro variables?

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:14:04 GMT

/*Import a CSV File*/
%let path=S:\CSV Import;
options validvarname=v7;

proc import datafile= s:\CSV Import\rapid_syphilis.csv
			out=sample_8.3.2020.csv
			dbms=csv replace;
run;

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:14:42 GMT

No it gave me syntax error..and it didn't work with it

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:15:17 GMT

How do I state it exist?

Re: Physical file does not exist

PaigeMiller — Tue, 04 Aug 2020 19:17:02 GMT

You did not show me the LOG from your code. I need to see the LOG including the code, NOTES, WARNINGs and ERRORs.

You confirm that the file exists by showing me a screen capture of the folder so we can all see what files are in it.

Re: Physical file does not exist

PaigeMiller — Tue, 04 Aug 2020 19:18:26 GMT

Adding, this is probably the error

out=sample_8.3.2020.csv

you have to use a valid SAS data set name here, which can't have periods, spaces or any special characters except an underscore. Which is why you really need to show us the log in the first place, this would have saved lots of time.

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:29:50 GMT

 NOTE: The SAS System stopped processing this step because of errors.
 77         proc import datafile= s:\CSV Import\rapid_syphilis.csv
                                   _
                                   22
                                   200
 ERROR 22-322: Syntax error, expecting one of the following: ;, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, 
               _DEBUG_.  
 
 ERROR 200-322: The symbol is not recognized and will be ignored.
78         out=sample_8.3.2020.csv
                             _____
                             22
                             76
 ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE, 
               _DEBUG_.  
 
 ERROR 76-322: Syntax error, statement will be ignored.
 
 79         dbms=csv replace;
 80         run;
 81

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:31:21 GMT

 NOTE: PROCEDURE IMPORT used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              204.09k
       OS Memory           30372.00k
       Timestamp           08/04/2020 07:23:15 PM
       Step Count                        24  Switch Count  0
       Page Faults                       0
       Page Reclaims                     63
       Page Swaps                        0
       Voluntary Context Switches        0
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           0
       
 NOTE: The SAS System stopped processing this step because of errors.

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 19:33:54 GMT

Sorry about that. I changed it to sample

Re: Physical file does not exist

PaigeMiller — Tue, 04 Aug 2020 19:46:22 GMT

Try this:

proc import datafile="s:\CSV Import\rapid_syphilis.csv"

and fix the OUT=

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 20:00:07 GMT

Now it says libname is not assigned...I am sorry for bugging you..I am really new at this.

Re: Physical file does not exist

ballardw — Tue, 04 Aug 2020 20:11:59 GMT

The filename should be in quotes

proc import datafile= "s:\CSV Import\rapid_syphilis.csv"

The only output Proc Import will create is a SAS data set. Not CSV.

So you specify a library name and data set name.

out= libname.dataset

which uses a single dot between the SAS library name and the data set name. Multiple dots are right out. Data set names can only have letters, digits and the _ character.

If you later want to send SAS data out to a CSV file you would use Proc Export.

Re: Physical file does not exist

Kimberly_2020 — Tue, 04 Aug 2020 20:04:49 GMT

libname syphilis "/home/u49152645/syphilis";

Note:

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         libname syphilis "/home/u49152645/syphilis";
 NOTE: Library SYPHILIS does not exist.
 74         
 75         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 87

Re: Physical file does not exist

Reeza — Wed, 05 Aug 2020 02:27:33 GMT

You need to show your whole code and log. We're seeing bits and pieces that don't make sense.

Re: Physical file does not exist

Kurt_Bremser — Wed, 05 Aug 2020 04:17:47 GMT

Which kind of SAS installation are you using?

University Edition in a downloaded virtual machine
SAS on Demand for Academics
licensed SAS in a local installation
licensed SAS in a client/server installation

All these need different methods for accessing external files and defining libnames, so it is essential for us to know how you use SAS.