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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.