Hi ChrisNZ,
I would like to use your code in a similar case, but I got errors. The tast is simply to scale down all columns (numeric format), except the first, by 100. Could you please help to correct for me. Thank you very much. Mai
proc contents
data = MP
out = test (keep = name varnum);
run;
proc sql ;
select distinct name
into : varlist separated by ' ' from test
where varnum not in (1),
%macro loop; %local i varname; %do i=1 %to dim(&varlist); %let varname=%scan(&varlist,&i);
,(&varname/100) as &varname
%end; %mend; %loop
from test
quit;
@q5pham Turn on option mprint then look at the invalid SQL query you are generating. The issue should become obvious.
Thank you all very much for your quick and efficient replies.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.