Problem extracting Date information from a cell

edison83 — Tue, 30 Jun 2020 21:34:17 GMT

Hello everyone, this might be a dumb question but here we go.

I am trying to extract a specific date information pra a column in one table into another new table. However, when i try to do that, the date information in the new table is shown as serial number. Is there any way to do this and extract only the first 9 characters aligned on the left in the column week1?

This is the code that i am using and the output that i am getting (the wrong one):

data test2; set test;
length week2 $ 10;
week2= left(week1);
run;

week1	week2
05JAN2018:00:00:00	1830729600
05JAN2018:00:00:00	1830729600
05JAN2018:00:00:00	1830729600
05JAN2018:00:00:00	1830729600
05JAN2018:00:00:00	1830729600
05JAN2018:00:00:00	1830729600

*Note: The date column in the original table is numerical and has this weirds "00:00" on it.

This is the output that i desire in the new table:

week1	week2
05JAN2018:00:00:00	05JAN2018
05JAN2018:00:00:00	05JAN2018
05JAN2018:00:00:00	05JAN2018
05JAN2018:00:00:00	05JAN2018
05JAN2018:00:00:00	05JAN2018
05JAN2018:00:00:00	05JAN2018

Thanks guys

Re: Problem extracting Date information from a cell

Shmuel — Thu, 02 Jul 2020 12:57:50 GMT

Your code:

data test2; set test;
length week2 $ 10;
week2= left(week1);
run;

You need to replace the left function into:

- week_date = datepart(week1);

- week2 = put(week_date,date9.);

Re: Problem extracting Date information from a cell

edison83 — Sun, 19 Jul 2020 23:48:21 GMT

Thanks, it worked! Sorry for the late reply

topic Re: Problem extracting Date information from a cell in SAS Programming

Problem extracting Date information from a cell

Re: Problem extracting Date information from a cell

Re: Problem extracting Date information from a cell