About cobba

cobba · ‎05-09-2022

For your first question, then yes you'd ignore the CN2 and join the 2 on either side. And yes, for your second question. Just as long as the previous is less than 7 days then it chains along.

cobba · ‎05-09-2022

I have the following data where there are clients with different events and a specific condition. If a client returns within 7 days with the same condition then it should actually be considered as the same event. If a client returns within 7 days with a different condition then it should be considered a separate event. data have; input client:$ eventid:$ condition:$ start:date9. finish:date9. ; format start DATE9. finish DATE9. ; datalines ; CL01 EV01 CN1 01AUG2019 07AUG2019 CL01 EV02 CN1 10AUG2019 18AUG2019 CL01 EV03 CN1 27AUG2019 30AUG2019 CL02 EV04 CN1 01AUG2019 07AUG2019 CL02 EV05 CN2 10AUG2019 18AUG2019 CL02 EV06 CN2 27AUG2019 30AUG2019 ; run; I do not want to change the eventid already in the data. I'd rather create another field to indicate that the events should be grouped. data want; input client:$ eventid:$ condition:$ start:date9. finish:date9. client_condition_grp:$10.; format start DATE9. finish DATE9. ; datalines ; CL01 EV01 CN1 01AUG2019 07AUG2019 CL01CN1_1 CL01 EV02 CN1 10AUG2019 18AUG2019 CL01CN1_1 CL01 EV03 CN1 27AUG2019 30AUG2019 CL01CN1_2 CL02 EV04 CN1 01AUG2019 07AUG2019 CL02CN1_1 CL02 EV05 CN2 10AUG2019 18AUG2019 CL02CN2_1 CL02 EV06 CN2 27AUG2019 30AUG2019 CL02CN2_2 ; run; I'm unsure how to tell SAS about the next or previous value in a table.

cobba · ‎03-24-2022

I have a table of contracted rates for different companies that change depending on the length of duration and get updated once a year. Then I also have a table of events which consists of the company, duration and Item Code. data have_rate_table; input Supplier $ Item $ Sub_Code $ Group $ Duration $ Rate_Start :DATE9. Rate_Finish :DATE9. Rate ; format Rate_Start DATE9. Rate_Finish DATE9.; datalines ; ACME A001 A001_1 1 1-2 01JUL2017 30JUN2018 1000 ACME A001 A001_2 2 3-14 01JUL2017 30JUN2018 500 ACME A001 A001_3 3 15+ 01JUL2017 30JUN2018 200 ACME A001 A001_1 1 1-2 01JUL2018 30JUN2019 1105 ACME A001 A001_2 2 3-14 01JUL2018 30JUN2019 545 ACME A001 A001_3 3 15+ 01JUL2018 30JUN2019 215 ACME A002 A002_1 1 1-4 01JUL2017 30JUN2018 800 ACME A002 A002_2 2 5+ 01JUL2017 30JUN2018 650 ACME A002 A002_1 1 1-4 01JUL2018 30JUN2019 820 ACME A002 A002_2 2 5+ 01JUL2018 30JUN2019 700 TidyCorp A001 A001_1 1 1-2 01JUL2017 30JUN2018 1500 TidyCorp A001 A001_2 2 3-14 01JUL2017 30JUN2018 1200 TidyCorp A001 A001_3 3 15+ 01JUL2017 30JUN2018 900 TidyCorp A001 A001_1 1 1-2 01JUL2018 30JUN2019 1550 TidyCorp A001 A001_2 2 3-14 01JUL2018 30JUN2019 1230 TidyCorp A001 A001_3 3 15+ 01JUL2018 30JUN2019 910 TidyCorp A002 A002_1 1 1-4 01JUL2017 30JUN2018 600 TidyCorp A002 A002_2 2 5+ 01JUL2017 30JUN2018 550 TidyCorp A002 A002_1 1 1-4 01JUL2018 30JUN2019 660 TidyCorp A002 A002_2 2 5+ 01JUL2018 30JUN2019 575 ; run; data have_events; input Event_ID $ Supplier $ Item $ Duration $ Event_Start :DATE9. Event_Finish :DATE9. ; format Event_Start DATE9. Event_Finish DATE9.; datalines ; E01 ACME A001 2 01JUL2017 02JUL2017 E02 ACME A001 4 01JUL2017 04JUL2017 E03 ACME A001 4 30JUN2018 03JUL2018 E04 TidyCorp A001 16 01JUL2018 16JUL2018 E05 TidyCorp A002 5 27JUN2018 01JUL2018 ; run; What I want is to calculate the total charges for each event based on the step down contract agreement and also the fact that rates change every year. data want; input Event_ID $ Supplier $ Item $ Duration $ Event_Start :DATE9. Event_Finish :DATE9. Total_Chgs ; format Event_Start DATE9. Event_Finish DATE9.; datalines ; E01 ACME A001 2 01JUL2017 02JUL2017 2000 E02 ACME A001 4 01JUL2017 04JUL2017 3000 E03 ACME A001 4 30JUN2018 03JUL2018 3195 E04 TidyCorp A001 16 01JUL2018 16JUL2018 19680 E05 TidyCorp A002 5 27JUN2018 01JUL2018 2975 ; run; How would one go about calculating this?

cobba · ‎02-10-2022

I have a dataset which contains many events that contains clients records with start and end dates. Whole events should be those from clients where there are intersecting dates from the same suppliers. data have; input event:$ client:$ supplier:$ start:date9. finish:date9. spend @@@@@; format start date9. finish date9.; datalines; 001 x1 SU1 01JAN2022 10JAN2022 10 002 y2 SU3 21DEC2021 22DEC2021 50 003 x1 SU1 05JAN2022 10JAN2022 5 004 x1 SU1 31DEC2021 11JAN2022 10 005 z3 SU2 01JAN2022 05JAN2022 15 006 x1 SU1 13JAN2022 15JAN2022 6 ; run; This is the data I want. For example client x1 has 3 events that intersect dates and one that does not. I also need to sum the spend and also make a note in the event ID that I've combined multiple events into one.

cobba · ‎12-21-2021

Thats it. Yes the integers represent 24hr time.

cobba · ‎12-21-2021

This is how the data is formatted. data hourdif2; input admission_dte YYMMDD10. admission_tme BEST6. separation_dte YYMMDD10. separation_tme BEST6.; format admission_dte YYMMDD10. admission_tme BEST6. separation_dte YYMMDD10. separation_tme BEST6.; datalines; 2019-12-26 1853 2020-01-06 1525 2019-12-30 1530 2019-12-31 1005 2019-12-31 1006 2020-01-28 1002 2019-12-30 2052 2020-01-02 2006 2019-12-30 843 2019-12-30 909 ; run; The dates are as dates but the time is either a 3 or 4 digit integer

cobba · ‎12-21-2021

Looking for the difference between the values accross the rows. Each row is independent from each other so no need to calculate the difference between rows.

cobba · ‎12-21-2021

I have the following start/end dates and times in separate columns in the following formats. start_date start_time end_date end_time 2019-12-26 1853 2020-01-06 1525 2019-12-30 1530 2019-12-31 1005 2019-12-31 1006 2020-01-28 1002 2019-12-30 2052 2020-01-02 2006 2019-12-30 843 2019-12-30 909 What is the most efficient way to return the difference in hours for each of the events? I need to include the decimal as well.

cobba · ‎12-13-2021

I'm trying to create a new column for each code I'm looking for. Then flag each row that contain those codes. The code works for 1 row then terminates. How do I keep looping through each row of my data set? data have; input id$ code1$ code2$ code3$ code4$; cards; aa 03f 06x 01a 05a bb 05n 02b 01a . cc 02b . . . dd 01a 02b . . ; run; data top_codes; input top_code1$ top_code2$ top_code3$; cards; 01d 01a 02b ; run; data want (drop= i k); if _n_ eq 1 then; do; set top_codes; retain _all; array tc(*) top_code1--top_code3; end; set have; array _vars(*) code1--code4; array code_{3}; do i=1 to dim(_vars); do k = 1 to dim(code_); if _vars(i) = tc(k) then code_{k} = 1 ; end; end; run; This is a image of what I'm getting. I'm expecting to get a line for each row of my data

cobba · ‎12-12-2021

I'm getting the following error when I run your code. I am running SAS EG 7.1 under SAS v9.3 ERROR: Array subscript out of range at line 39 column 30. id=aa cause1=001 cause2=001 cause3=002 effect1=001 effect2=003 effect3= i=1 _ERROR_=1 _N_=1

cobba · ‎12-12-2021

I have the following data. The real data is about 100 columns data have; input id$ cause1$ cause2$ cause3$ effect1$ effect2$ effect3$ @@@@@@@; datalines; aa 001 001 002 001 003 . bb 005 . . 004 005 001 cc 001 003 002 001 003 002 dd 002 004 009 002 005 006 ; run; The codes aren't very helpful for analysis. So I'd like to add a character to the start based on the header.

cobba · ‎12-07-2021

I got it to work by moving the prefix up. proc transpose data=have out=want (drop=name) prefix=code; by id; var code; run; Thanks.

cobba · ‎12-07-2021

I have the following data. A table of events that can contain any number of codes. data have; input id$ code$ @@; datalines; aa x1 aa x1 aa x2 bb x1 bb y1 bb y1 bb z2 bb z4 cc x1 cc x2 cc y1 cc x1 cc x1 cc q1 dd z2 dd z2 dd z2 dd q1 ; run; I want to transpose the data so the codes associated with each event is stored in the same row.

cobba · ‎12-06-2021

That is what I'm looking for. Thank you. How do I make the report a table?

cobba · ‎12-06-2021

Using SAS EG v7.1 I have the following data where an event is represented by an ID and any number of codes (always strings) can be applied to each event. data have; input id$ code$ @@; datalines; aa x1 aa x1 aa x2 bb x1 bb y1 bb y1 bb z2 bb z4 cc x1 cc x2 cc y1 cc x1 cc x1 cc q1 dd z2 dd z2 dd z2 dd q1 ; run; Episode IDs and Codes are always strings but can be of varying lengths. The data below is what I want. Where the unique codes make up the column headings and the count is performed for each ID.

Online Status	Offline
Date Last Visited	‎12-19-2022 02:39 AM

Re: Group if next event starts within 7 days of previous

Group if next event starts within 7 days of previous

Calculating Cost with a Changing Rate

Summarise Events with Intersecting Dates

Re: Hour Difference with Data Spread Over 4 Columns

Re: Hour Difference with Data Spread Over 4 Columns

Re: Hour Difference with Data Spread Over 4 Columns

Hour Difference with Data Spread Over 4 Columns

Nested Do Loop Terminating After 1 Row

Re: Concatenate Value Based on Header Name

Re: Group if next event starts within 7 days of previous

Allow PROC SORT to output multiple datasets

Re: Hour Difference with Data Spread Over 4 Columns

Re: Nested Do Loop Terminating After 1 Row

Re: Nested Do Loop Terminating After 1 Row

Re: Group if next event starts within 7 days of previous

Group if next event starts within 7 days of previous

Calculating Cost with a Changing Rate

Summarise Events with Intersecting Dates

Re: Hour Difference with Data Spread Over 4 Columns

Re: Hour Difference with Data Spread Over 4 Columns

Re: Hour Difference with Data Spread Over 4 Columns

Hour Difference with Data Spread Over 4 Columns

Nested Do Loop Terminating After 1 Row

Re: Concatenate Value Based on Header Name

Concatenate Value Based on Header Name

Re: Transpose Values by Unique ID

Transpose Values by Unique ID

Re: Count Unique Values by Row and Use Values as Column Names

Count Unique Values by Row and Use Values as Column Names