I am wondering if there is any very clever way of renaming the observations in a variable according to the frequency they appear, it has been a bit of a brain teaser for me today. Imagine having the dataset data have;
set have;
input ID Business $;
datalines;
1 Retail
2 Corporate
3 Retail
4 Retail
5 Retail
6 Corporate
7 SME
8 Retail
9 Retail
10 Corporate
;
run; is there any way that you can change observations in the business variable if there is less than 10% representation in the variable I.e. in a proc freq - variable SME would account for 10%, would there possibly be a code to say data want;
set have;
if business(Obs)<10% then business="Other";
run; it's sounding a little far fetched but if this is not possible, my question is can I have multiple constraints on the statement below: data want;
set have;
if Business^= "Retail" or "Corporate"
then Business = "Other";
run;
... View more