proc sql; select * from qqq format date date9.; quit;

Hi, I have one dataset like
id date ex: id date
1 13 1 13Oct2011
2 14 2 14Oct2011
3 15 3 15Oct2011 --->this is the current date
here i want date format like 13Oct2011,14Oct2011 how we can
modify the numeric to date format plz answer.

Question Posted / naveen

4 Answers
6250 Views
I also Faced
E-Mail Answers

Answer Posted / naveen

proc sql;
select *
from qqq
format date date9.;
quit;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how do the in= variables improve the capability of a merge? : Sas programming

1484

What versions of SAS have you used (on which platforms)?

1565

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1066

Mention the validation tools used in SAS?

1230

What is the purpose of _character_ and _numeric_?

1108

How can sas program be validated?

1072

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1153

Tell me about % include and % eval? : sas-macro

1190

what is data governance? : Sas-di

1067

What do you code to create a macro? : sas-macro

1191

what other sas products have you used and consider yourself proficient in using? : Sas programming

1164

What are the different versions of sas that you have used until now? : sas-grid-administration

1389

Name validation tools used in SAS

1220

Mention what is PROC in SAS?

1113

How do you specify the number of iterations and specific condition within a single do loop?

1155