topic Re: how to separate data and time and assign time am/pm in New SAS User

how to separate data and time and assign time am/pm

Sundeep_M — Sun, 24 Feb 2019 13:15:05 GMT

How to separate date and time when combined and assign time with am and pm.

And also can you please write down the code.

Re: SAS query

PaigeMiller — Sun, 24 Feb 2019 12:46:44 GMT

Give us an example of your input data. Please specify in your reply whether or not the data is already in a SAS data set as numeric or character, and whether it is formatted. If the data is not in a SAS data set and has to be read in from some text file, please show us an example of such a date and time.

Also, please, we are trying to help you, and you can help us by providing a more specific subject line to your original question. The existing subject line "SAS query" could apply to any question about anything in SAS.

Re: SAS query

Kurt_Bremser — Sun, 24 Feb 2019 12:52:21 GMT

See my footnotes for hints on posting data in form of code.

Note that this is a website for helping people do their work, not doing their work for them. If you need someone to write your code, hire a consultant.

Work through the free Programming 1 course to have all the basics settled.

Re: how to separate data and time and assign time am/pm

Sundeep_M — Sun, 24 Feb 2019 13:07:20 GMT

SIR HERE IS THE DATA SET

Mr. Manoj 18/02/2007:3:30

Mr. Jacob 19/02/2007:4:15

Mr.Anil 19/02/2007:13:00

Mr.Rathod 20/03/2007:14:30

Sir for the above data set can you explain how to separate data and time and assign time am/pm.

Thanks for your feedback i will change my subject.

Re: how to separate data and time and assign time am/pm

PaigeMiller — Sun, 24 Feb 2019 13:13:04 GMT

@Sundeep_M wrote:

SIR HERE IS THE DATA SET

Mr. Manoj 18/02/2007:3:30

Mr. Jacob 19/02/2007:4:15

Mr.Anil 19/02/2007:13:00

Mr.Rathod 20/03/2007:14:30

Sir for the above data set can you explain how to separate data and time and assign time am/pm.

Thanks for your feedback i will change my subject.

Thank you, but is this a SAS data set, or text that has to be read in from some external file?

Also, we request that you change the subject line of the original post in this thread.

Re: how to separate data and time and assign time am/pm

Sundeep_M — Sun, 24 Feb 2019 13:14:01 GMT

Sir this is a text that has to be read from external file

Re: how to separate date and time and assign time am/pm

PaigeMiller — Sun, 24 Feb 2019 13:26:18 GMT

/*** UNTESTED CODE ***/

data want;
     infile "filename.txt";
     input name $10. & datetime :ANYDTDTM16.;
     date=datetpart(datetime);
     time=timepart(datetime);
     format date ddyymm8. time timeampm8.;
run;