Dear everybody!
How can I refer to the dynamic name of the format?
Here is my situation:
%Macro myMacro (myVar);
PROC FORMAT CNTLOUT= fmtdataset;
VALUE &myVar
1 = 'Label1'
2 = 'Label2'
;
RUN;
Data somedataset_formatted;
set somedataset;
FORMAT &myVar &myVar. ; /*I also tried FORMAT &myVar "&myVar."; – get a syntax error message */
RUN;
%Mend myMacro
When I call %myMacro (variableName) I get no errors. The file fmtdataset contains the appropriate format "variableName". However, in the dataset "somedataset" the variable variableName doesn't get formatted. If I replace the macro with values, i.e.,
FORMAT variableName variableName. it works just fine.
Thank you very much
Julia
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.