SAS Array question each data subject has multiple rows

Question

My data is structured Monthly, on each month an update is added to each customers record. these are stacked vertically. I want to search through each customer if a flag or indicator appears in any month I want to record that permanently. From my example if there is ever a missed payment I want the ever_missed flag to always be 1

1234 Jan 0
1234 Feb 0
1234 Mar 1
1234 Apr 0
5678 Jan 1
5678 Feb 0
5678 Mar 1
5678 Apr 0

I have been looking at array tutorials but generally the dates etc are horizontal

Jan Feb Mar.

essentially all i want to do is loop through each record per customer and if missed_pay = 1 then ever_missed = 1

Quentin · Accepted Answer · 2023-04-06 13:01:07Z

1

This could be done in a DATA step with "DOW loop", but SAS PROC SQL makes it easy, because of the "remerging" feature. I don't think arrays would be helpful for this.

data have ;
  input Cust_ID Month $3. missed_pay ;
  cards ;
1234 Jan 0
1234 Feb 0
1234 Mar 1
1234 Apr 0
5678 Jan 1
5678 Feb 0
5678 Mar 1
5678 Apr 0
9999 Jan 0
9999 Feb 0
9999 Mar 0
9999 Apr 0
;

proc sql ;
  create table want as
  select *,max(missed_pay) as ever_missed
  from have
  group by Cust_ID
  ;
quit ;

proc print data=want ;
run ;

answered Apr 6, 2023 at 13:01

Quentin

6,3881 gold badge16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SAS Array question each data subject has multiple rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related