topic Re: code for creating 3 groups based on 2 variables in SAS Programming

code for creating 3 groups based on 2 variables

HEB1 — Mon, 20 Mar 2023 12:46:26 GMT

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,

Re: code for creating 3 groups based on 2 variables

Quentin — Mon, 20 Mar 2023 13:51:48 GMT

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.) .

Re: code for creating 3 groups based on 2 variables

ballardw — Mon, 20 Mar 2023 14:18:42 GMT

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>