topic Proc import parameter list update error in SAS Programming

Proc import parameter list update error

priya2 — Wed, 27 Jul 2016 16:08:46 GMT

I am getting a parameter update error that I am not sure how to resolve?

26 option validvarname=ANY ;

28 ! PROC IMPORT OUT= SKINNER.skn_data

30 file="/MARKET/NETWORK/MARKET & CHANNEL ANALYTICS/RETAIL ANALYTICS/Ad-Hoc Projects/Veronica's ad

30 ! hoc/xxx.txt"

32 DBMS=DLM REPLACE;

34 DELIMITER='|';

36 GETNAMES=YES;

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

Re: Proc import parameter list update error

ballardw — Wed, 27 Jul 2016 16:16:04 GMT

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.

Re: Proc import parameter list update error

priya2 — Tue, 02 Aug 2016 13:04:30 GMT

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