topic Re: time difference column in SAS Programming

time difference column

BrahmanandaRao — Wed, 03 Jul 2019 06:18:04 GMT

Re: time difference column

andreas_lds — Wed, 03 Jul 2019 05:23:49 GMT

At least at on my mobile phone your text is hardly readable. Please post the data we should work with in usable form: a data step with datalines.

Re: time difference column

ChrisNZ — Wed, 03 Jul 2019 05:49:46 GMT

> I want standard time format arrival and departure

What's not standard in the times you show?

> also difference between two columns timings

You have the duration already.

Or are these all text strings and you want to change them to SAS times?

Show us a proc contents.

Re: time difference column

BrahmanandaRao — Wed, 03 Jul 2019 05:52:38 GMT

please look into attachment

i want output what i mentioned

Re: time difference column

Kurt_Bremser — Wed, 03 Jul 2019 06:00:12 GMT

This is the SAS Communities. For help with Excel, consult Microsoft Support.

Please post your SAS dataset in usable form (a data step with datalines).

If I download an Excel file from the internet, my Chief Security Officer will nail my hide to the company door.

Re: time difference column

Kurt_Bremser — Wed, 03 Jul 2019 06:04:30 GMT

PS to calculate time differences, just subtract start from end time. SAS times are counts of seconds, so the result will be a SAS time value again. Assign the time5. format for proper display.

Re: time difference column

ChrisNZ — Wed, 03 Jul 2019 06:18:09 GMT

> please look into attachment

No I will not.

1. MS office files are potentially dangerous.

2. The least you can do is make the effort to provide usable data and information.

> i want output what i mentioned

Good luck.