BookmarkSubscribeRSS Feed
Hb21Pzn
Calcite | Level 5

HI,

 

I will be really gratefull for help, because after three days I have run out of ideas.

I would like to present ending times of some processes on timeseries plot.

X axis should be the date (here everything is fine) and Y axis should be the corresponding time to this date. 

Unfortunetelly I am not able to do that without converting time format to numeric (only one way to convert time to measure and implement that on plot) which is not good enoough to present.

 

So the first question is --> is there any plot which allows me to present data in wanted way?

 

Secondly --> I have an idea to convert time format variable to integer, but not like amount of second from 00:00:00. Rather like below:

      

                08:37:23 (time format) --> 83723 (numeric) --> 8:37:23 (numeric with colon as decimal)

 

After carying out these steps and load data into lasr everythig should work, but i can't convert  time data properly in last transformation.

I am putting code below which partialy doing what i want, but colon is not on right places. At least is numeric and has colon, so it must be possible 🙂

 


proc format library=work;
picture mysep

0 - 999999 = '000:000:00' (decsep=':' dig3sep=':');
run;

 

data test;
x= 123456;
format x mysep.;
run;

 

Thank you very much for your help.

 

Regards,

Hubert

 

1 REPLY 1
PaigeMiller
Diamond | Level 26

Please do not post the same question more than once. You have already posted this question and received an answer here: https://communities.sas.com/t5/General-SAS-Programming/Time-to-numeric-with-colon-separator/m-p/4845...

 

All further comments should go to the other thread as well.

--
Paige Miller

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 890 views
  • 0 likes
  • 2 in conversation