Number into date

[rochka84]

format: BEST12.

informat: BEST32.

for both...

[rochka84]

both numeric

[art297]

Have you tried the code like @Shmuel proposed, namely:

data want;
  set have; /*replace 'have' with whatever the filename is*/
  date = mdy(1,1,year) + day -1; 
  format date date9.;
run;

Art, CEO, AnalystFinder.com

[rochka84]

ok, i did...

now i receive colum name 'date' with numbers.

exemple: for day=1 in colum 'date'= 17532.

can i convert this to dd/mm/yy format?

[rochka84]

ok, i was a little foolish with my previous question.

i search some more, and put the following syntax:

data want5; 
set model; /*original data base*/
date = mdy(1,1,year) + day -1;
format date ddmmyy10.;
run;

working excelent!!!

thank you very very very much!

[ballardw]

May want to consider this as well:

date= datejul(1000*year+day);

What you describe is refered to as a JULIAN date, tne number of the day in a year. Typically these look like  17023  (23rd day of year 17 which should be 2017) or 2017023. When you have the year and day separately then the DATEJUL function works as above creating a single numeric value of 2017023 from 2012 and 23.