Help using Base SAS procedures

Resolving a Macro variable within Format within PROC DATA.

Accepted Solution Solved
Reply
Contributor
Posts: 30
Accepted Solution

Resolving a Macro variable within Format within PROC DATA.

[ Edited ]

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


Accepted Solutions
Solution
‎12-13-2015 01:33 PM
Super User
Posts: 19,772

Re: Resolving a Macro variable within Format within PROC DATA.

I think you need an extra period at the end of the format name. Periods are used to indicate the end of a macro variable, so the first one gets used by the macro variable and the second is for the format.

FORMAT &myVar &myVar.. ;

View solution in original post


All Replies
Solution
‎12-13-2015 01:33 PM
Super User
Posts: 19,772

Re: Resolving a Macro variable within Format within PROC DATA.

I think you need an extra period at the end of the format name. Periods are used to indicate the end of a macro variable, so the first one gets used by the macro variable and the second is for the format.

FORMAT &myVar &myVar.. ;
Contributor
Posts: 30

Re: Resolving a Macro variable within Format within PROC DATA.

Hurray! It worked. Thank you very much!
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 260 views
  • 2 likes
  • 2 in conversation