converting numeric date variable into character date variable

[Dhana18]

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? 

[Reeza]

Select *, NEW VARIABLES go here etc.

[novinosrin · Accepted solution]

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

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

[Dhana18]

Thank you. You made my day!!!