topic Re: how do you change a sasdate in a sas datastep? in SAS Programming

how do you change a sasdate in a sas datastep?

mgrzyb — Sat, 21 Jul 2018 11:32:30 GMT

I hope some one can help me.

There is a wrong date in the original database. I don't want to go back to the original database.

I have searched on it in google and at this website and found NO ANSWER.

https://communities.sas.com/t5/Base-SAS-Programming/how-to-convert-char-var-to-sas-date/td-p/45067

Now, here is what the contents of the dataset say for that variable.

woundvstdate

Num

MMDDYY8

My code is:

data initial;

set aung.initialdat_mg2;

if id=55 then woundvstdate=04/20/10;

proc print;

run;

My outpout is:

Obs id woundvstdate1

01/01/60

Obviously, that is wrong.

I know there more wrong dates and don't want to keep going back to the original dataset.

I know this will happen in future endeavors.

Is there a way to do this in a datastep?

thank you!

Re: how do you change a sasdate in a sas datastep?

PaigeMiller — Sat, 21 Jul 2018 11:50:15 GMT

@mgrzyb wrote:

There is a wrong date in the original database. I don't want to go back to the original database.

...

My code is:

data initial;

set aung.initialdat_mg2;

if id=55 then woundvstdate=04/20/10;

When you type 04/20/10, it is division. You are dividing 04 by 20 and then dividing by 10.

To indicate that 04/20/10 is a date value, use

if id=55 then woundvstdate='20APR10'D;

Re: how do you change a sasdate in a sas datastep?

mgrzyb — Sat, 21 Jul 2018 11:51:11 GMT

Thankyou!

That worked. I also tried this, and it seemed to work after I checked out proc contents again.

If there is a difference between the 2, please let know.

if id=55 then put=(woundvstdate=04/20/10);

Thank you again!!!!

Re: how do you change a sasdate in a sas datastep?

PaigeMiller — Sat, 21 Jul 2018 13:00:29 GMT

PROC CONTENTS would not contain information about whether or not changing the value of a variable was successful or not.

if id=55 then put=(woundvstdate=04/20/10);

I don't see how this code would successfully change the value of a variable either.

The bottom line is you have to LOOK at the data set with your own eyes, and see if the value is correct in the data set or not. PROC CONTENTS, and PUT statements don't suffice.