Hello everyone, I have a large dataset that looks like this:   data have; input customerID product; datalines; A1 P4 A1 P6 A1 P2 A2 P3 A2 P4 A3 P1 ;   I want to get a count of how many products each customerID has assigned to it. Each row is unique so there is no need to account for duplicates. This is what I'm trying to achieve:   data want; input customerID product count; datalines; A1 P4 3 A1 P6 3 A1 P2 3 A2 P3 2 A2 P4 2 A3 P1 1 ;   ... View more

I have some data that I pulled for current year orders in a database. The variable changed indicates if they had sensitive information changed in that year. I want to modify the previous entries, or any entries going forward to have changed = 1 if the customer_id is the same and changed = 1 at any entry of that customer_id. If a customer_id doesnt have changed = 1 on any row then I want to leave it alone.   here is a small subset of one customer id as an example.   DATA have; input order_num customer_id changed DATALINES; 412 067 0 623 067 0 871 067 1 942 067 0 512 098 0 662 098 0 112 023 0 987 023 1 In this example I'm trying to have customer_id 067 and 023 have changed = 1 for all rows while leaving customer id 098 alone. like so:   DATA have; input order_num customer_id changed DATALINES; 412 067 1 623 067 1 871 067 1 942 067 1 512 098 0 662 098 0 112 023 1 987 023 1 I'm not sure how this can be done so any help would be appreciated. Thanks ... View more

Hello, I have a dataset I'm trying to reshape using proc transpose but I cant quite seem to figure it out     data have; input id $ record1 $ record2 $ record3 $; datalines; A1 a15 n14 A1 a15 b12 b17 A1 a12 b18 A2 a29 a28 a21 A3 a34 a36 c34 ; I want this data to look like this:      data want; input id $ record $; A1 a15 A1 n14 A1 a15 A1 b12 A1 b17 A1 a12 A1 b18 A2 a29 A2 a28 A2 a21 A3 a34 A3 a36 A3 c34 Using proc transpose i get a set with multiple columns and i cant figure out how to get only one column. Does anyone have any tips on how to do this? Thank you. ... View more

Hello, I have a dataset I want to create a format from, but then I want to add an 'other' clause to assign a value for things that are not included in the dataset. Sorry if this is a simple question but I don't know how to go about doing this. Thank you. ... View more

So i have a dataset like this that has a few million rows: Unique_Id Age Segment 1 56 0 1 57 4 1 57 0 2 23 0 2 24 0 2 24 1 3 77 0 3 77 2 3 78 0 3 78 0 4 86 0 4 88 1.1 4 88 0 5 12 0 5 12 0 5 14 0 5 14 0 I want to fill the segment portion up by matching it with age and unique_id. So unique_id 2 is in segment 1 when age is 24, i want both unqiue id 2 at age 24s to have segment 1 but not have it at age 23.   For a more clear picture, heres what i am looking for the dataset to resemble: Unique_Id Age Segment 1 56 0 1 57 4 1 57 4 2 23 0 2 24 1 2 24 1 3 77 2 3 77 2 3 78 0 3 78 0 4 86 0 4 88 1.1 4 88 1.1 5 12 0 5 12 0 5 14 0 5 14 0 My problem is that I don't even know where to start to do this. If anyone can provide help or tips it would be much appreciated. Thanks.   ... View more

Hello, I have about 500 DOBs and i need to find how old each one was on a certain date.  My data is like this and the date is ordered YYYY-MM-DD Name DateOfBirth Robert 1987-12-27 Alex 1946-11-23 Paul 1996-3-12 I need to find how old each member was in November of 2020 and I'm not sure how to do this ... View more