DATA Step, Macro, Functions and more

Ordered Macro Variables

Reply
Super Contributor
Posts: 268

Ordered Macro Variables

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
Regular Contributor
Posts: 165

Re: Ordered Macro Variables

I would use something like:

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

in a data step.

Good luck!
Super Contributor
Posts: 268

Re: Ordered Macro Variables

Thank you. It worked for me.
Ask a Question
Discussion stats
  • 2 replies
  • 126 views
  • 0 likes
  • 2 in conversation