About BETO

BETO · ‎01-20-2016

Hi ksharp I added the data step ...where you state data want is it a table your refer or column? I refer to table it failed ? The set an if are highlighted in red log states. 180-322 statement is not valid or it used out of proper order

BETO · ‎01-20-2016

Hi thank you everyone e that is assisting me ...whst I have is a data set that looks like this SITE. NUMBER. START TIME. END TIME 123. A3 06dec2015:8:24:00 .06dec2015:08:26;00 123. A3 06dec2015:8:26:00 .06dec2015:08:40:00 What I want is the min an max of those 2 entries nothing else something like this 123. A3 06dec2015:8:24:00 .06dec2015:08:40:00 The other 2 can be removed What I'm getting is all 4 entries or just the min 123. A3 06dec2015:8:24:00 .06dec2015:08:26;00 Thank you again BTW there are other dates in my data sometimes it brings those dates as my min an max for example 123. A3 03dec2015:8:25500 .06dec2015:08:26;00. Which means it's looking st who data I need it to look at each day spefic

BETO · ‎01-18-2016

Thanks reeza. I'm still getting the min and max from same entries it doesn't look at both entries any suggestions?

BETO · ‎01-18-2016

Here is my code Proc sql ; Create table report as (Select ID, NUMBER, START_TIME, END_TIME, MIN (START_TIME) FORMAT=DATE9., MAX (END_TIME)FORMAT=DATE9. FROM REPORT GROUP by Id, numbe ); run; The date9. Is coming up 1.76501E9 Yes it's number 23

BETO · ‎01-18-2016

Yes sorry didn't change it should be 23

BETO · ‎01-18-2016

I am getting these results Here is data id. Number. Start time. End time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:05:11 1a. 24. 01/01/16 11:02:00. 01/01/16 11:06:16 1a. 25. 01/01/16. 12:00:00. 01/0116 12:07:00 I'm getting id. Number. Start time. End time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:05:11 when it should be this id. Number. Start time. End time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:06:00 the min part works but max it give me the end time to the min what I'm looking for the max time to the end time almost there thanks

BETO · ‎01-18-2016

I have a ID of 1 with a number of 23 ....sorry I just notice the 24 should be a 23 number so since I have 2 entries on same date same id and same number I want to determine the min between those 2 and the max between this 2

BETO · ‎01-18-2016

Hi reeza, Is there a way using proc sql or a data step ?

BETO · ‎01-18-2016

How do I get the min time an max time by number? Data looks like this id. Number. Start time. End time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:05:11 1a. 24. 01/01/16 11:02:00. 01/01/16 11:06:16 1a. 25. 01/01/16. 12:00:00. 01/0116 12:07:00 I would want want it to look like this outpout id. Number. Min Start time. Max End time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:06:11 thanks

BETO · ‎01-17-2016

Sorry forgot to mention that i need min and max for example if we have 3 or 4 entries same id same number get the min and max from date time that falls within an hour of min an max longer than hr I will exclude it ...after that I would like to see if the min and max date time field overlaps with the other number but same id ... thanks again

BETO · ‎01-17-2016

Yes I'm grouping it by Id. So if there could be up to 4 overlap if there is no overlap than I don't need that I just need where there was overlap ... For example out put 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:05:11. 1a 24 01/01/16. 11:02:00. 01/01/16 11:06:16 would be one roll for the ones that are over lap

BETO · ‎01-17-2016

Hi I have a table that I need to determine the min and max time of 2 or 3 data time points...that is limited within hour of each point if it's greater I excluded my data looks like this id. Number. Start time. End time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:05:11 1a. 24. 01/01/16 11:02:00. 01/01/16 11:06:16 1a. 25. 01/01/16. 12:00:00. 01/0116 12:07:00 what I need here is just number 23 and 24 sine they over lap the 25 it exceeds the hour from the first 2 ....I would need 23 and 24 in one roll id. Number. Start time. End time. Id. Number. Start time. end time 1a. 23. 01/01/16. 11:01:00. 01/01/16 11:05:11. 1a 24 01/01/16. 11:02:00. 01/01/16 11:06:16 I would need the min start time of number and max end time from number first thanks in advance

BETO · ‎12-17-2015

Ksharp I ran syntax it drop my start 2 end 2 Start3 End3 It put columns I ma. St. En. ..I need the output to look like my examples minus the duplicate...the time in St an en is formated 1762078330 .... thanks for your help

BETO · ‎12-16-2015

It looks some thing like this machine1. Start1. end1. Machine2. Start2. end2. Machine3. Start3. End3 A1. 11/01/15 11:21. 11/01/15 11:38. A1. 11/01/15 11:30 11/01/15 11:35. A1 11/01/15 11:21. 11/01/15 11:38 sometimes there are up to 5 machines but normally there are 3 what I need is to remove the duplicates and keep one of the two.... Thanks

BETO · ‎12-16-2015

Hi I have a rows of data an wanted to remove any dups the data looks like this Machine. start 1. A1. 11/01/15 12:34:00. Start2 11/01/15 09:34:00 Start3. 11/01/15 09:34:00 I don't have room I didn't inlude the end time which would be also duplex ....thanks

Online Status	Offline
Date Last Visited	‎03-13-2020 05:49 PM

Re: How to drop a variable when criteria is met

How to drop a variable when criteria is met

Re: How to apply macro to proc sql ?

Re: How to apply macro to proc sql ?

How to apply macro to proc sql ?

Re: ID the day of week

Re: ID the day of week

Re: ID the day of week

Re: ID the day of week

ID the day of week

Re: How to ID min max

Re: How to ID min max

Re: How to use date/time field with a minus 1 day

Re: Best way to import Access Table?

How to adjust for 100%?

Re: How to use date/time field with a minus 1 day

Re: Assistance with transpose

Re: Between start and end

Re: How to ID min max

Re: How to ID min max

Re: How to ID min max

Re: How to ID min max

Re: How to ID min max

Re: How to ID min max

Re: How to ID min max

Re: How to ID min max

How to ID min max

Re: Min and max overlapping two date time points

Re: Min and max overlapping two date time points

Min and max overlapping two date time points

Re: removing dups in cell

Re: removing dups in cell

removing dups in cell