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.

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

what is the difference between unique key and primary key? : Sas-di

591


what is slowly changing dimension? : Sas-di

620


How substr function works in sas?

699


Give e an example of..

1650


What is the difference between using drop = data set option in data statement and set statement?

636






what is sas metadata server? : Sas-di

587


If money were no object, what would you like to do?

2684


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

596


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1159


What is the use of function Proc summary?

651


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

1878


What are the differences between proc means and proc summary?

599


explain the proc in sas? : Sas-administrator

618


I have a dataset concat having variable a b & c. How to rename a b to e & f?

576


What is the SAS data set?

675