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

[sahoositaram555]

Hi Experts,

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

Category

1

1

1

1

1

2

2

2

2

2

3 

3

3

3

4

4

4

4

4

;

I would like to create a macro that gives me output with its count like below

1- 5

2-5

3-4

4-5

;

To do this i have taken

%macro cat(); 

%let Received_data = %sysfunc(open(dataset.p1));
%If &Received_data %Then %Do;
Proc freq data=dataset.p1;
Table &col./out=outfile;
run;
%End;

%mend cat();

Later from this step I'm trying to put it in to call symputx(). 

If anyone knows a better method to complete this please do help with your response.

[Kurt_Bremser]

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;

[sahoositaram555]

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 .

[Kurt_Bremser]

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

[sahoositaram555]

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

[Kurt_Bremser]

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;