creating categorical variable based on date (before/after)

amigapomba — Sat, 15 Dec 2018 03:36:24 GMT

hi all,

I imported an xlsx file into university addition using the import snippet. Date is in MM/DD/YYYY format. I assume SAS doesn't know that so I wrote a format statement to clarify. I then tried to create a categorical variable "reg" based on the date. The code I used is as follows:

data sc.date;
set sc2;
format date mmddyy10.;
run;

data sc.change;
set sc.date;
if date < 06/06/2014 then reg = "before";
else reg = "after";

run;

I'm not getting any errors, however all of my observations have been assigned "after", even though many of them have a date prior to 6/6/2014.

Thanks in advance for any help!

Re: creating categorical variable based on date (before/after)

Reeza — Sat, 15 Dec 2018 03:41:32 GMT

SAS is seeing, 06/06/2014 which is 6 divided by 6, divided by 2014.

To specify a date, a specific format has to be used, the date9 format and enclosed in quotes and with a d at the end.

if date < '06Jun2014'd then reg='Before';
else reg = 'After';

Date and time literals:

t -> time -> '08:00't

dt -> datetime

d -> date

@amigapomba wrote:

hi all,

I imported an xlsx file into university addition using the import snippet. Date is in MM/DD/YYYY format. I assume SAS doesn't know that so I wrote a format statement to clarify. I then tried to create a categorical variable "reg" based on the date. The code I used is as follows:

data sc.date;
set sc2;
format date mmddyy10.;
run;

data sc.change;
set sc.date;
if date < 06/06/2014 then reg = "before";
else reg = "after";

run;

I'm not getting any errors, however all of my observations have been assigned "after", even though many of them have a date prior to 6/6/2014.

Thanks in advance for any help!

Re: creating categorical variable based on date (before/after)

amigapomba — Sat, 15 Dec 2018 03:48:40 GMT

thank you!!

topic creating categorical variable based on date (before/after) in SAS Programming

creating categorical variable based on date (before/after)

Re: creating categorical variable based on date (before/after)

Re: creating categorical variable based on date (before/after)