Date to Text

[shenniko]

Hi,

Need some help..

Ive got a Dataset with a few variables, one of them being a Date field, and another one being a Temperature.

What i want to do is combine the Date and the temp field in a text variable..

So at the moment the Date field is shown as Date9. (02Jul2005)

So when i try combining the two fields together

E_Date = Entry_Date||' - '||Temperature;

it comes out like

16619 - 17.5

How do i get it to output 02Jul2005 - 17.5

Thanks in advance

Shenn

 

[klaz2002]

Use the PUT function.

E_Date = trim(put(Entry_Date,date9.))||' - '||Temperature;

FYI - You should use this function when converting a numeric variable to a text string. This way the sas WARNING is eliminated in the log file.
Klaz

 

[shenniko]

Ahh, gotcha..

thanks for the help

Shenn