topic Re: separate datetime using Datepart() and Timepart() in New SAS User

separate datetime using Datepart() and Timepart()

RebeccaJW — Wed, 13 Mar 2019 03:59:19 GMT

I am working on a data set that is merged from two sets. Then I want to separate date and time to two columns.

This is what I have done:

data JF_XY;
	merge JF XY;
	by number;
	format date datepart(DateTime, date9.);
run;

The left is the data set that I am working on. The right is the expected output.

Thank you in advance for help!

PGStats — Wed, 13 Mar 2019 04:06:43 GMT

Do not confuse functions and formats :

data JF_XY;
	merge JF XY;
	by number;
    date = datepart(datetime);
    time = timepart(datetime);
    format date yymmdd10. time time.;
run;

RebeccaJW — Wed, 13 Mar 2019 04:14:43 GMT

Thank you so much for answering!