topic Re: I have multiple dates in one column. How I can add them in separate columns. in SAS Programming

I have multiple dates in one column. How I can add them in separate columns.

Agha — Tue, 31 Dec 2024 16:29:41 GMT

dates

2013-08-13,2013-10-18,2013-12-16,2014-03-07,2014-04-30,2014-06-11,2014-07-24,2014-08-11,2014-09-29,2014-11-24,2015-05-05,2015-08-19,2015-10-19,2016-04-15,2016-06-28,2016-10-28,2017-02-13,2017-11-06

2020-09-25,2020-10-27,2020-12-08,2021-02-02,2021-04-13,2021-06-08,2022-05-06,2022-07-26,2023-02-28

2022-06-27,2022-08-23,2022-11-07,2022-12-13,2023-01-24

Re: I have multiple dates in one column. How I can add them in separate columns.

PaigeMiller — Tue, 31 Dec 2024 16:50:19 GMT

Let me speak from experience, you will be better off if you have all the dates in one column, rather than separate columns. Many times people choose a poor layout for the data, and wind up causing later programming difficulties. So, a word to the wise, put the dates in a single column.

This code assumes your data is in a SAS data set named HAVE.

data want;
    set have;
    seq=_n_;
    do i=1 to countw(dates,',');
         date=input(scan(dates,i,','),yymmdd10.);
         output;
    end;
    format date yymmdd10.;
    drop i dates;
run;

Re: I have multiple dates in one column. How I can add them in separate columns.

Astounding — Tue, 31 Dec 2024 18:36:20 GMT

Agree with the advice. A small tweak to the solution:

 do i=1 to 1 + countw(dates,',');

Re: I have multiple dates in one column. How I can add them in separate columns.

Agha — Tue, 31 Dec 2024 20:38:12 GMT

Thanks a lot.