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 toWORK.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 secondscpu time 0.13 seconds
When your code uses < > in the path of files I suspect something seriously wrong by including those.
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.
When your code uses < > in the path of files I suspect something seriously wrong by including those.
Nearly 200 sessions are now available on demand in the Innovate Hub.
Watch Now →SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.