DATA Step, Macro, Functions and more

Proc import parameter list update error

Reply
New Contributor
Posts: 2

Proc import parameter list update error

 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

 

Super User
Posts: 10,483

Re: Proc import parameter list update error

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.

New Contributor
Posts: 2

Re: Proc import parameter list update error

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

Ask a Question
Discussion stats
  • 2 replies
  • 151 views
  • 0 likes
  • 2 in conversation