topic Re: Multiple conditions on renaming observations in SAS Programming

Multiple conditions on renaming observations

89974114 — Wed, 14 Mar 2018 17:26:29 GMT

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;

Re: Multiple conditions on renaming observations

Reeza — Wed, 14 Mar 2018 17:33:40 GMT

What about a custom format?

data have;
input ID Business $15.;
datalines;
1 Retail
2 Corporate
3 Retail
4 Retail
5 Retail
6 Corporate
7 SME
8 Retail
9 Retail
10 Corporate
;
run;

proc format;
value $ business_type_fmt
'Retail' = 'Retail'
'Corporate' = 'Corporate'
other = 'Other';
run;

proc freq data=have;
table business;
format business $business_type_fmt.;
run;

Re: Multiple conditions on renaming observations

89974114 — Wed, 14 Mar 2018 17:35:49 GMT

Most likely the best way, I was unsure how format can be used for an umbrella "other" term thank you