topic Re: WARNING: not resolved. in SAS Programming

WARNING: not resolved.

shahparth260 — Fri, 07 Dec 2018 08:06:46 GMT

data dsn;
   infile datalines;
   input oldval $20.;
   datalines;
   Auto(%excl)
   Miles
   ;
 run;

proc format; 
value $newval 
"Auto(%excl)"="Auto- Excluded (%)" 
"Miles"="MILES" 
other=" " 
; 
run;

data dsn1;
 set dsn;
 newvalue=put(oldval,$newval.);
run;

I have few raw values which has % are included (see code:) , now when I try to change format using user define formats I am having warning really not want to see any thing in log if possible. Do we have any way ( I Dont want to compress and take that out if possible ).

Here, SAS assumes that I have used a macro symbol. How to rid of this warning ? Please help if you have any idea.

Re: WARNING: not resolved.

Kurt_Bremser — Fri, 07 Dec 2018 08:23:12 GMT

Use single quotes to prevent macro resolution:

proc format; 
value $newval 
  'Auto(%excl)' = 'Auto- Excluded (%)' 
  'Miles' = 'MILES'
  other = ' ' 
; 
run;

Re: WARNING: not resolved.

shahparth260 — Fri, 07 Dec 2018 23:59:08 GMT

Wow!! So easy... thanks for your help. Thanks for being helpful again. I really appreciate it.