topic Removing date information in SAS Enterprise Guide

Removing date information

rab24 — Wed, 05 Jul 2006 14:49:09 GMT

I know it sounds strange, but I need to remove information from a date variable going from a variable that includes day of the month to just month. It is part of a deidentification process so a simple format change is not sufficient. Any suggestions on how to permanently restrict my data?

Thanks.

Re: Removing date information

Olivier — Wed, 05 Jul 2006 15:01:34 GMT

You can try :
1) creating a character variable with the formula PUT(myDate, MMYYS7.) and your new variable will only contain month and year
2) create a new date variable with the formula INTNX("MONTH",myDate,0) and you new variable will be located on the 1st of the month

Re: Removing date information

rab24 — Wed, 05 Jul 2006 15:44:29 GMT

Thanks Olivier, that works perfectly.

To SAS proper, I'm sure more experienced users probably wouldn't have a problem understanding this, but instead of the syntax intnx( 'month', date, 0) the Enterprise Guide help has the syntax example as intnx( 'month', date, 0, beg )