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!
... View more