topic Re: Number into date in SAS Programming

Number into date

rochka84 — Sat, 04 Mar 2017 17:28:31 GMT

hi, i use sas 9.4

i got the following 2 Columns: year and day.

year is 2008.

day: 1 to 322.

1 means 1.1.2008 and so on...

how do i convert the numbers ito dates?

super urgent!! thanxxx

Re: Number into date

art297 — Sat, 04 Mar 2017 17:37:52 GMT

You showed what day=1 looks like. What should day=322 look like?

Art, CEO, AnalystFinder.com

Re: Number into date

rochka84 — Sat, 04 Mar 2017 18:08:51 GMT

Day 1 looks like '1' (means 1.1.2008),
Day 322 looks like '322'...

Re: Number into date

art297 — Sat, 04 Mar 2017 18:13:45 GMT

Ok. Day 322 looks like '322', but means? ....

Does it mean the 322nd day of the year? Plus you said that it looks like '322'. Is that the number 322, or a character string?

Art, CEO, AnalystFinder.com

Re: Number into date

rochka84 — Sat, 04 Mar 2017 18:16:24 GMT

Number- 322

Re: Number into date

Shmuel — Sat, 04 Mar 2017 18:16:58 GMT

Assuming day is the sequential day in a year, you can calculatr the date as:

date = mdy(1,1,year) + day -1;

format day ddmmyy10. ; /* or any other date format, e.g date9. */

taht is, for year=2008 then date = Jan 1st, 2008 + day - 1;

Re: Number into date

rochka84 — Sat, 04 Mar 2017 18:22:42 GMT

Ok,i will try
Thanxxx

Re: Number into date

Shmuel — Sat, 04 Mar 2017 18:29:44 GMT

If you have the year and the day input as yyyyddd

then you can also use:

data _NULL_;
    date_in = '2016055';    /*year=2016 day=055 */
    date = input(date_in, julian7.);  /* Julian date informat */
     put date date9.;       /* check date in log */
run;

Re: Number into date

rochka84 — Sat, 04 Mar 2017 18:53:59 GMT

What will be the syntax if i have 300+ rows?

Re: Number into date

Shmuel — Sat, 04 Mar 2017 19:12:44 GMT

Tha synatx depends on your input.

Post a sample of your input file, better as data step to read it,

or maybe:

data have;
    input date julian7. ;
    format date date9.;
datalines;
2008200
2010035
2015106
;
run;

Re: Number into date

Tom — Sat, 04 Mar 2017 19:13:47 GMT

Do you have the data already in a dataset? Or are you reading from a text file? If you are reading from a text file then the data step would look like this:

data want ;
   infile 'myfile.txt' ;
   input year day ;
   date = mdy(1,1,year)+day-1;
   format date date9.;
run;

If you have an existing SAS dataset then replace the INFILE and INPUT statements with a SET statement.

Re: Number into date

rochka84 — Sat, 04 Mar 2017 21:44:03 GMT

i have data in an exel file.

how will the syntax will be?

this way it is not working...

Re: Number into date

rochka84 — Sat, 04 Mar 2017 22:21:24 GMT

i have +300 rows... in colum 'day' i have number: 1-365, in colum 'year'= 2008.

i want to create anothe colum name 'date'- which will be the xx (from colum 'day') day of the year 2008.

for exemple: if i have the number 4 in 'day' colum, i want that it colum 'date' it will show: 4/1/2008.

Re: Number into date

art297 — Sat, 04 Mar 2017 22:29:22 GMT

After importing, when you click on the file on SAS, what are the properties of each of those fields? Specifically, we need to know if each is character or numeric.

Art, CEO, AnalystFinder.com

Re: Number into date

rochka84 — Sat, 04 Mar 2017 22:30:45 GMT

is this helps?

informat year best32. ;
informat day best32.

Re: Number into date

rochka84 — Sat, 04 Mar 2017 22:32:41 GMT

format: BEST12.

informat: BEST32.

for both...

Re: Number into date

rochka84 — Sat, 04 Mar 2017 22:33:33 GMT

both numeric

Re: Number into date

art297 — Sat, 04 Mar 2017 22:37:48 GMT

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

Re: Number into date

rochka84 — Sat, 04 Mar 2017 22:39:51 GMT

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?

Re: Number into date

rochka84 — Sat, 04 Mar 2017 22:59:58 GMT

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!