About BETO

PhilC · ‎03-13-2020

Third idea: Id. date. Journal Duration A1. 03/01/20. ABCD. 1 A2. 03/01/20. BCDA. 4 Take what you have but save and concatenate Col: variables into long strings. We over here, call strings names like this "Journey" or "Journal" because they usually are chronologically ordered for us. Using appropriate logic, change the Journal strings with Find(), Scan(), SubStr(), TranWRD(), etc. to arrive at what you want. I employ regular expressions (i.e. PRXmatch() etc.) to make matches in this context, because it eliminates a lot of if-then structures, but maybe your logic is simple enough to avoid regexp.

Kurt_Bremser · ‎10-26-2019

Please post your whole code. Use the "little running man" icon for posting code.

ballardw · ‎10-17-2019

@BETO wrote: Now that i id week 1 of the month is there a way to get it to sure it by date range for example Date sales 09/03/19 - 09/06/19. $0000.00 09/09/19 - 09/13/19. $0000.00 09/16/19 - 09/20/19 $00000.00 09/23/19 - 09/27/19. $00000.00 The data looks like this Date. Sales 09/09/19. 0000 09/10/19. 0000 09/13/19. 0000 09/15/19. 0000 09/16/19: 0000 09/24/19. 0000 09/27/19. 0000 Where does this interval come from? 09/03/19 - 09/06/19? I think you may be excluding holidays now but have not explicitly stated that anywhere. So what "interval" would expect for values in the first week of July 2019 where July 4 is a holiday that appears on Thursday??, or Christmas, New Years as other holidays that change day of the week? or Thanksgiving that is always a Thursday. I think your "interval" display needs some additional description, rules and example in an out data. The example "have" data is easy. Here is a calendar worth: data have; do date= '01Jan2019'd to '31Dec2019'd; output; end; format date date9.; run; Now provide examples of the interval value for each of those dates.

Cynthia_sas · ‎06-14-2016

Please look at the code marked "1)" in the code that I posted in 2012. The male.html and the female.html files are created as the first step of the entire program. In my code I specify the path location on my personal computer's C: drive as c:\temp in the PATH= option. I don't know where you are saving the HTML files, but you should write the files to a physical folder location where you have write access. cynthia

BETO · ‎01-27-2016

Thanks Reeza

BETO · ‎01-20-2016

Ksharp I fig it out thanks for your help

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

Ksharp · ‎12-17-2015

data have; input machine1 $ ( Start1 end1) (& anydtdtm.) Machine2 $ (Start2 end2) (& anydtdtm.) Machine3 $ (Start3 End3) (& anydtdtm.); format _numeric_ datetime.; cards; 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 A1 11/01/15 11:21 11/01/15 11:38 A1 11/01/15 11:30 11/01/15 11:35 A2 11/01/15 11:21 11/01/15 11:38 ; run; data want; if _n_ eq 1 then do; length _machine $ 100 _Start _end 8; declare hash h(); declare hiter hi('h'); h.definekey('_machine','_Start','_end'); h.definedata('_machine','_Start','_end'); h.definedone(); end; set have; array m{*} machine: ; array s{*} Start: ; array e{*} end: ; do i=1 to dim(m); _machine=m{i};_Start=s{i};_end=e{i}; h.replace(); end; call missing(of m{*} s{*} e{*}); i=0; do while(hi.next()=0); i+1; m{i}=_machine;s{i}=_Start;e{i}=_end; end; h.clear(); drop _: i ; run;

Ksharp · ‎12-15-2015

You did not post the output yet ? data t1; input Machine $ Time :time8. Date :mmddyy8.; datalines; A1 15:35:35 11/07/15 A2 10:59:06 11/04/15 A1 15:42:23 11/07/15 ; data t2; input Machine $ Time :time8. Date :mmddyy8.; datalines; A1 15:38:35 11/07/15 A2 10:55:06 11/04/15 A3 15:45:23 11/07/15 ; data t; set t1 t2; dt = dhms(date,0,0,time); format dt datetime19. date date9. time time8.; run; proc sort data=t; by machine dt; run; data want; set t; if Machine eq lag(Machine) and dif(dt) le '00:15:00't; run;

BETO · ‎12-14-2015

My mistake I was aware it was public the person help me with a same question I fig it was easy to address it to them ...

PGStats · ‎12-14-2015

Post as a new question with example data and expected output.

BETO · ‎12-14-2015

I might have gotten it I did a datepart and added date I then group it by site id. Machine. Date.

Reeza · ‎12-13-2015

1. Figure out what it is, run a proc contents to see the variable type and format. 2. If it's a character, use input with the format to read it in as a different format (input(var, time8))

Astounding · ‎11-18-2015

Is there a colon in the incoming text, after the # ???

BETO · ‎09-10-2015

Hi PGSTATS , I provided an example above of 3 tables and there structure. ..the temp query works fine the want seems to bring everything in from the 3rd table ....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 drop a variable when criteria is met

Re: How to apply macro to proc sql ?

Re: ID the day of week

Re: How to do a Drill Down

Re: How to remove entry from being used 2x

Re: How to ID min max

Re: Min and max overlapping two date time points

Re: removing dups in cell

Re: Keeping 15 min

Re: Keep 15 min pgstats

Re: Remove machine that was service at same time range

Re: grouping issue

Re: Merge issue / convert number to time8 format

Re: How to extract ticket number after # an only 8numbers ?

Re: between statement not filtering out