topic Re: Updating a date in SAS in SAS Procedures

Updating a date in SAS

nimmis — Fri, 12 Sep 2014 18:41:37 GMT

Hello: I am an SQL professional- brand new to SAS. I need to update just one row in SAS table. The datafield is a date type. I am just trying to update one row, set the field = "01Oct2015" where the id = xyz. The code runs and the value is set to a period. I know this must be a format issue. Could someone please help me?

Re: Updating a date in SAS

Hima — Fri, 12 Sep 2014 18:49:55 GMT

data have;
input id date;
format date mmddyy10.;
informat date mmddyy10.;
cards;
1 10/25/2015
2 10/15/2015
3 10/10/2015
;
run;

data want;
set have;
if id ne 1 then date_new=put(date,mmddyy10.);
else date_new=put(date,date9.);
run;

proc print; run;

Re: Updating a date in SAS

stat_sas — Fri, 12 Sep 2014 18:59:15 GMT

Try this.

proc sql;

update have

set field='01Oct2015'd

where id='xyz';

quit;