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

WARNING: Physical file does not exist

mcmaxwell — Mon, 14 Dec 2020 15:45:22 GMT

Hello, I have started learning SAS studio this year. I am trying to upload a very large csv file (just under 9000 rows) and am running into an error. Here is the code I used to upload the file:

/** Import the CSV file. **/ 
FILENAME CSV "</folders/myshortcuts/SASUniversityEdition/myfolders/sasuser.v94/LineGraph/transposed_all.csv>" TERMSTR=CRLF; 
PROC IMPORT DATAFILE=CSV 
		    OUT=all 
		    DBMS=CSV 
		    REPLACE; 
RUN;

This is the same code I usually use to upload my csv files, however this time I get the following error message:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
WARNING: Physical file does not exist,
/opt/sasinside/SASConfig/Lev1/SASApp/</folders/myshortcuts/SASUniversityEdition/myfolders/sasuser.v94/LineGraph/transposed_all.csv>.

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.17 seconds
cpu time 0.13 seconds

I double checked that the file directory is correct (I copied it directly from "Server Files and Folders" panel) so I'm not sure what else could be wrong. Any help would be greatly appreciated!!

Re: WARNING: Physical file does not exist

PaigeMiller — Mon, 14 Dec 2020 15:57:15 GMT

When it says that the physical file does not exist, this means there is no such file in the folder you named. Perhaps you have spelled something wrong, either the file name or the folder path name. Or you have told SAS to look in the wrong folder.

Re: WARNING: Physical file does not exist

Reeza — Mon, 14 Dec 2020 16:05:30 GMT

You need to remove the <> from the code. Those are usually just included in answers/blog posts as an indicator of where to put your code. You could use regular parenthesis I believe, which does have a bit of a different meaning.
FYI - it looks like you set up your myfolders incorrectly given your path, otherwise the path would be /folders/myfolders/LineGraph .....
If you'd like help figuring that out, please let us know.

Re: WARNING: Physical file does not exist

ballardw — Mon, 14 Dec 2020 17:19:07 GMT

When your code uses < > in the path of files I suspect something seriously wrong by including those.