topic First time customer appear VS first time File exist in SAS Programming

First time customer appear VS first time File exist

Ronein — Mon, 22 May 2023 06:55:00 GMT

Hello

For each customer ID there is information of existence of 5 files (binary variables minus1,minus2,minus3,minus4,minus5).

There is also information of fist location customer appear.

I want to create want data set with following information:

For each customer ID:

Customer_First_Location (This column already exist in have data set)

First_File_Location (New column need to create)

status(New column need to create)

IF Customer_First_Location =First_File_Location then it is ok.

IF Customer_First_Location is after First_File_Location then it is not_ok

What is the way to create want data set?

data have;
input ID  minus1 minus2 minus3 minus4 minus5 Customer_First_Location;
cards;
1 1 1 1 1 1 -1 
2 0 1 0 0 1 -5
3 0 0 0 1 0 -4
4 0 0 0 0 1 . 
;
Run;

Data want;
input ID Customer_First_Location First_File_Location  status;
cards;
1 -1 -1 OK
2 -5 -2 Not_OK
3 -4 -4 OK
4  . -5 Not_OK
;
Run;

Re: First time customer appear VS first time File exist

SASJedi — Mon, 22 May 2023 12:22:28 GMT

From your description:
>First_File_Location (New column need to create)

Nothing in this code indicates how that value is derived. Please explain how you are generating the value for First_File_Location.

Re: First time customer appear VS first time File exist

PaigeMiller — Mon, 22 May 2023 12:22:37 GMT

You have not explained how First_File_Location is created.

Re: First time customer appear VS first time File exist

Quentin — Mon, 22 May 2023 13:10:37 GMT

I took a guess at how to derive first_file_location:

data want ;
  set have ;
  length Status $8 ;

  First_File_Location=whichn(1,of minus1-minus5) * -1 ;

  if First_File_Location=Customer_First_Location then status='OK' ;
  else status='Not_OK' ;

run ;

proc print ;
run ;