topic Re: converting numeric date variable into character date variable in SAS Programming

converting numeric date variable into character date variable

Dhana18 — Mon, 10 Sep 2018 16:19:08 GMT

I converted the numeric date variable into character variable using this code

proc sql;

create table as date_char as select put (visit_dt,yymmdd10.) as visdate

from stdtelmt merged; quit;

it worked as I wanted but in my new table I only have new variable. how do I get all of the variable I had in the from table? or all of the variable in the previous dataset?

Re: converting numeric date variable into character date variable

Reeza — Mon, 10 Sep 2018 16:30:24 GMT

Select *, NEW VARIABLES go here etc.

Re: converting numeric date variable into character date variable

novinosrin — Mon, 10 Sep 2018 16:30:29 GMT

coz you selected only select put (visit_dt,yymmdd10.) as visdate

select *,put (visit_dt,yymmdd10.) as visdate

Re: converting numeric date variable into character date variable

Dhana18 — Mon, 10 Sep 2018 16:36:38 GMT

Thank you. You made my day!!!