topic Re: Pass dataset variable value to a macro in SAS Programming

Pass dataset variable value to a macro

RXM — Thu, 24 Aug 2017 16:10:35 GMT

I have a simple macro that converts a letter value to a numeric value:

%macro grade(color);

%global colorgrade;

%let incolor=&color;

select(&incolor);

when ('L') colorgrade=8;

when ('B') colorgrade=6;

when ('G') colorgrade=4;

when ('Y') colorgrade=2;

when ('R') colorgrade=0;

otherwise colorgrade=-2;

end;

%mend grade;

My problem is passing the value of the dataset variable to the macro. Instead of the value of the variable ('G'), it passes the variable name (color).

Re: Pass dataset variable value to a macro

Reeza — Thu, 24 Aug 2017 16:16:35 GMT

Please show how you're using this.

An alternative - a better one IMO - is to use a FORMAT.

Re: Pass dataset variable value to a macro

Astounding — Thu, 24 Aug 2017 16:20:22 GMT

From what you have shown so far, the macro actually needs the variable name. It would be wrong to pass the variable value. Certainly this statement would be incorrect syntax in a DATA step:

select ('G');

Secondarily, what is the purpose of the %GLOBAL statement? There is nothing about this code that assigns a value to a macro variable named COLORGRADE.

Re: Pass dataset variable value to a macro

Reeza — Thu, 24 Aug 2017 16:22:03 GMT

%global colorgrade; <- what's this for, it's not used in the code you've shown.

%let incolor=&color; <- this isn't needed, renaming the macro variable?

Re: Pass dataset variable value to a macro

RXM — Thu, 24 Aug 2017 16:26:43 GMT

Reeza,

As you can tell, I am a complete neophyte and am converting code fragments from the SAS documentation. I thought of the FORMAT function first, but have not found any examples where it was used to convert a character value to a numeric value.

RXM

Re: Pass dataset variable value to a macro

Reeza — Thu, 24 Aug 2017 16:32:17 GMT

Search Lexjansen.com for any topics, you'll find papers and full code examples:

Page 4 of this paper has an example.

http://www2.sas.com/proceedings/sugi27/p056-27.pdf

Re: Pass dataset variable value to a macro

RXM — Thu, 24 Aug 2017 16:35:33 GMT

Reeza,

Thank you so much! I knew there would be an elegant solution!

RXM

Re: Pass dataset variable value to a macro

Tom — Thu, 24 Aug 2017 21:09:17 GMT

@RXM wrote:

Reeza,

As you can tell, I am a complete neophyte and am converting code fragments from the SAS documentation. I thought of the FORMAT function first, but have not found any examples where it was used to convert a character value to a numeric value.

RXM

Formats are for displaying values, so they always generate text. But an INFORMAT can be used to generate numeric values.

proc format ;
  invalue colorgrade
    'L'=8
    'B'=6
    'G'=4
    'Y'=2
    'R'=0
    other=-2
  ;
run;