code for creating 3 groups based on 2 variables

[HEB1]

hello,

I wand to construct 3 groups based on 2 variables (F_D and reporting_firm) , by CIK- that is I want to define each cik ID to 1 of the 3 groups:

Group1- every cik that has F_D =1 before reporting_firm=1

Group2- every cik that has F_D =1 and reporting_firm=0 for all cik years

Group- every cik that has F_D =0 before reporting_firm=1

best, 

HB

[Quentin]

A lot of people won't download files for security reasons.  You will make it much easier for people to help you if you post example data you HAVE as a DATA step with the CARDS statement (with 10-20 records, showing the different scenarios).  And also include the data you WANT to generate.  Also suggest including the code you have tried, and any problems with your code (wrong result, error message, etc.) .

[ballardw]

What do you want for

Group- every cik that has F_D =0 never reporting_firm=1?

The second reason for showing small example of the data is that you can manually show a second set with the desired result. I'm not sure what you expect a result to look like.

is your "group" variable supposed to be numeric or character? Actually say "Group1"?  What is the name of the variable to be constructed>