topic Ordered Macro Variables in SAS Programming

Ordered Macro Variables

saspert — Mon, 04 Apr 2011 16:34:09 GMT

Hello,
I am trying to create multiple macro variables based on the number of rows in a dataset. Say if I have 3 rows in dataset sample like this -

A B
NY 10
NJ 5
MD 7

I need three macro variables &CNTNJ, &CNTNY &CNTMD to have 5, 10 and 7 respectively. Should I use 2 macros, the first to create a macro containing the string and the second to resolve it in a loop?

Appreciate any suggestions.

Regards,
saspert

Re: Ordered Macro Variables

RickM — Mon, 04 Apr 2011 17:00:21 GMT

I would use something like:

call symput(catx('CNT',A),B);

in a data step.

Good luck!

Re: Ordered Macro Variables

saspert — Mon, 04 Apr 2011 18:07:38 GMT

Thank you. It worked for me.