topic Re: build a macro for a categorical variable (by taking the counts in to unique macros) in SAS Programming

build a macro for a categorical variable (by taking the counts in to unique macros)

sahoositaram555 — Tue, 14 Jul 2020 08:27:19 GMT

Hi Experts,

I've a dataset containing a column named Category like below

Re: build a macro for a categorical variable (by taking the counts in to unique macros)

Kurt_Bremser — Tue, 14 Jul 2020 08:35:10 GMT

This is simple summarizing of data, so you don't need a macro:

data want;
set have;
by category;
if first.category
then count = 1;
else count + 1;
if last.category;
result = catx('-',category,count);
keep result;
run;

Re: build a macro for a categorical variable (by taking the counts in to unique macros)

sahoositaram555 — Tue, 14 Jul 2020 09:18:28 GMT

Hi @Kurt_Bremser,
Thank you for your response. Though this can be done by the method you have shown and i could see that its working, but for my further analysis depends on this which for which i would like to macrotize all the individual observations with it's count assigned to individual values.
Therefore, I would be grateful if you can guide me with your kind response .

Re: build a macro for a categorical variable (by taking the counts in to unique macros)

Kurt_Bremser — Tue, 14 Jul 2020 09:22:01 GMT

What do you want to do with the strings from the summarization?

Re: build a macro for a categorical variable (by taking the counts in to unique macros)

sahoositaram555 — Tue, 14 Jul 2020 09:43:02 GMT

I will pass them as arguments in to models which i'm building.

Re: build a macro for a categorical variable (by taking the counts in to unique macros)

Kurt_Bremser — Tue, 14 Jul 2020 09:47:48 GMT

So you would have a macro wrapper around your code:

%macro run_single(param);
/* your model code here, where &param would be one of the instances from the summarization */
%mend;

which you can use from the resulting dataset of my previous code:

data _null_;
set want;
call execute('%nrstr(%run_single(' !! result !! '))');
run;