topic Re: SAS in SAS Programming

SAS

Aswanth — Mon, 11 Sep 2017 09:07:31 GMT

i want to seperate the date and time and finally i want only time format how can i do..

eg; 08SEP09:15:50:02

Re: SAS

ChrisBrooks — Mon, 11 Sep 2017 09:33:18 GMT

This should give you what you want

data _null_;

	format datebit date9. timebit time.;
	dtime='08SEP09:15:50:02'dt;
	datebit=datepart(dtime);
	timebit=timepart(dtime);
	
	put datebit=;
	put timebit=;
run;

Re: SAS

RW9 — Mon, 11 Sep 2017 09:43:52 GMT

And what format is the data in? Is it datetime or text? This is where providing test data in the form of a datastep and what the required output should look like really helps. If its datetime then use the datepart/timepart functions. If its text, then use substr and input.

Re: SAS

Aswanth — Mon, 11 Sep 2017 10:21:45 GMT

thank you...chrisbook

how can i convert the time eg...09:30
and this time will be concat to date . if this is correct time format to concat please explain.

Re: SAS

Aswanth — Mon, 11 Sep 2017 10:22:08 GMT

thank you...Rw9

how can i convert the time eg...09:30
and this time will be concat to date . if this is correct time format to concat please explain.

Re: SAS

RW9 — Mon, 11 Sep 2017 10:24:09 GMT

I am sorry, I have no idea what you are talking about. Have a look at some of the other questions posted here for guidance on how to ask a question which provides all the information needed to give an answer, for example:

https://communities.sas.com/t5/Base-SAS-Programming/Getting-max-value-by-group-complex-table/m-p/394613

Note the test data datastep and what the output should look like.