topic Re: Create categories in New SAS User

Create categories

Ranjeeta — Wed, 17 Oct 2018 20:43:02 GMT

Hello,

I have a column of time in minutes ranging from 0 to 1440 minutes

I want to create 2 categories for this data in sas

360< Category 1 >=0 minutes and

1440< Category 2 >=360 minutes

Please advise what sas commands would I use to achieve the above result

Re: Create categories

PeterClemmensen — Wed, 17 Oct 2018 20:54:42 GMT

Hi and welcome to the SAS community 🙂

Does your actual data contain only two categories? Or more?

If just the two, do something like this

data have;
   do time=1 to 2000;
      output;
   end;
run;

data want;
   set have;
   Category=ifc((0 <= time <=360), "Category 1", "Category 2");
run;

Re: Create categories

Ranjeeta — Wed, 17 Oct 2018 20:53:40 GMT

Thankyou !!

Yes and These are the only two categories that I want to create

Re: Create categories

PeterClemmensen — Wed, 17 Oct 2018 20:55:15 GMT

Ok. I have edited the above answer with a small code example.

Let me know if it fits your needs

Re: Create categories

SuryaKiran — Wed, 17 Oct 2018 21:02:33 GMT

Hi,

You can use case when expression in proc sql or If then in data step or else you can also use proc format.

/* Method 1*/
proc sql;
select *, case when 0<=time<360 then "Cat 1"
			   when 360<=time<1440 then "Cat 2"
			   else "NA" end as cat
	from have;
quit;
/* Method 2*/
data want ;
set have;
if  0<=time<360 then cat="Cat 1";
else if 360<=time<1440 then cat="Cat 2";
else cat='NA';
run;
/* Method 3*/
proc format;
value timevar 0-360="cat1"
			  360-above="cat 2";
run;

data want;
set have;
format time_variable timevar.;
run;

Re: Create categories

Ranjeeta — Wed, 17 Oct 2018 21:15:13 GMT

Thankyou very much this is very helpful

I used method 2

Re: Create categories

Ranjeeta — Wed, 17 Oct 2018 21:17:26 GMT

Thankyou for your response Im new to sas therefore used if then /else as Im familiar

Will try the IFC function as well