I am getting a parameter update error that I am not sure how to resolve?
26 option validvarname=ANY ;
27
28
28 ! PROC IMPORT OUT= SKINNER.skn_data
29
30 file="/MARKET/NETWORK/MARKET & CHANNEL ANALYTICS/RETAIL ANALYTICS/Ad-Hoc Projects/Veronica's ad
30 ! hoc/xxx.txt"
31
32 DBMS=DLM REPLACE;
33
34 DELIMITER='|';
35
36 GETNAMES=YES;
37
38 DATAROW=2;
39 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.
ERROR: Physical file does not exist, /MARKET/NETWORK/MARKET & CHANNEL ANALYTICS/RETAIL ANALYTICS/Ad-Hoc Projects/Veronica's ad hoc/xxx.txt.
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.36 seconds
cpu time 0.09 seconds
The parameter list is not an error. Your actual error is more likely the path to the datafile. You really should provide a complete path from the root or mount point. As written SAS is looking subordinate to where the SAS execution point is, a relative path.
I believe you are right. I had suspicion on the file path. so i saved the data to a different folder. the apostrophe in the file folder path.. was giving the error.
thanks
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.