topic Re: Modify date of an observations SAS in SAS Programming

Modify date of an observations SAS

jonatan_velarde — Tue, 06 Sep 2016 19:29:38 GMT

Good morning:

I have an dataset and i have to replace some dates (including formats):

i was trying to use this:

data have;

input ID birth_day:mmddyy10.;

format birth_day mmddyy10.;

cards;

1515 03/22/2000

1533 12/19/2000

;

Data want;

set have;

if ID = 1515 then birth_day = '01/26/2003';

if ID = 1533 then birth_day = '01/30/2004';

run;

I tried this estatements and it is not working

Can anybody give me some hints please??

thanks

Re: Modify date of an observations SAS

LinusH — Tue, 06 Sep 2016 19:36:08 GMT

The date your are trying to assign is a string, dates in SAS a numerical.

If you wish to express a data constant, you need to use the date format and using a data literal:

'01Jan205'd

Re: Modify date of an observations SAS

jonatan_velarde — Tue, 06 Sep 2016 19:39:24 GMT

Thanks for your answer:

i use this format:

mmddyy10.

the original data is formated like this.

ill try and give notices

Re: Modify date of an observations SAS

ballardw — Tue, 06 Sep 2016 20:11:28 GMT

The value of a Date literal must be in the form of 'ddMONyy'd or 'ddMONyyyy'd for SAS to recognize it as a date. If you have assigned a format of mmddyy10. to the variable then that is the default appearance the value will have in your data set.