topic Re: "Format" doesn't work in New SAS User

"Format" doesn't work

dooheekim01 — Fri, 25 Sep 2020 17:59:31 GMT

data storm_new;

set pg1.storm_damage;

drop Summary;

YearsPassed=yrdif(Date, today(), "age");

Anniversary=mdy(month(Date), day(Date), year(today()));

format YearPassed 4.1 Date Anniversary mmddyy10.;

format Cost dollar20. YearPassed 4.;

run;

YearPassed 4. didn't work.

Still it shows like this "

15.084931507

I don't know why "YearPassed 4." didn't work in the statement. Please help me.

Re: "Format" doesn't work

ballardw — Fri, 25 Sep 2020 18:03:34 GMT

Where does the value show like that?

Is that supposed to be output from Proc Print? The SAS table viewer?

Or did you export the data to an external file? If so which one and what code did you use to export it?

Re: "Format" doesn't work

dooheekim01 — Fri, 25 Sep 2020 21:40:13 GMT

Hello,

Yes! the value shows like this and this is in the SAS table view.

This statement was the one of the activities. (Lesson 4 - SAS Programming 1)
Thank you!

Re: "Format" doesn't work

ballardw — Fri, 25 Sep 2020 21:53:08 GMT

Check your dataset properties to see if the format for the variable is as you expect it.

Proc contents data=storm_new.

run;

If that does not show a 4. format then check your logs to make sure the data set was created. Or that you are opening the correct data set.

Re: "Format" doesn't work

dooheekim01 — Fri, 30 Oct 2020 18:58:08 GMT

Thank you!