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
5956 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

In ARRAY processing, what does the DIM function do?

1116

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

968

How would you invoke a macro? : sas-macro

1044

What are the features of base sas system?

1018

In sas, what are the areas that you are most interested in? : sas-grid-administration

1025

Did you used proc test? when?

1982

what are the scrubbing procedures in sas? : Sas programming

1228

explain the key concept of sas? : Sas-administrator

943

how to do user inputs and command line arguments in sas?

2978

what is broad cast agent? : Sas-bi

1011

how many types prompting framework can be broken down to? : Sas-bi

1035

What are the ways in which macro variables can be created in sas programming?

1032

Explain the difference between informat and format with an example.

1115

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

963

how many display types available in sas bi dashboard? : Sas-bi

1034