Ordered Macro Variables

[saspert]

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

[RickM]

I would use something like:

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

in a data step.

Good luck!

[saspert]

Thank you. It worked for me.