topic Re: Simplifying IF_THEN STATEMENTS in New SAS User

Simplifying IF_THEN STATEMENTS

stancemcgraw — Fri, 15 Mar 2019 22:50:05 GMT

I am trying to create a variable called Federal_Insurance which, contains the variables, Medicaid, Medicare, Workmanscomp, Tricare. Each of those insurance types is its own variable. Is there any way I can create variable "Federal" without saying if MEdicaid=1 and Medicare=1 and so on.....

data have

studynum Medicaid Medicaid

1 1 0

2 0 1

3 1 0

Re: Simplifying IF_THEN STATEMENTS

PeterClemmensen — Fri, 15 Mar 2019 23:02:34 GMT

What is the logic behind the creation of Federal_Insurance?

If MEdicaid=1 and Medicare=1 and Workmanscomp=1 and Tricare=1 then what? 🙂

Re: Simplifying IF_THEN STATEMENTS

VDD — Sat, 16 Mar 2019 00:23:58 GMT

Federal_Insurance = compress(Medicaid||Medicare||Workmanscomp||Tricare);

if you have 1 and 0's this will give you:

1000 = medicaid

0100 = medicare

1100 = Medicaid and meidicare

and so on;

Re: Simplifying IF_THEN STATEMENTS

Reeza — Sat, 16 Mar 2019 02:25:36 GMT

1. Create an array for the list of variables

2. Use WHICHN() to get the index of the variable with a 1

3. Use VNAME () to get the name of the column

With this approach it doesn't matter how many programTypes you have and you don't need any IF statements. If the variable names are not exactly what you want, you may need to recode them.

array programTypes(*) medicaid medicare WCB Tricare;

index = whichn(1, of programTypes(*));
Program_Type = vname(programTypes(index));

@stancemcgraw wrote:

I am trying to create a variable called Federal_Insurance which, contains the variables, Medicaid, Medicare, Workmanscomp, Tricare. Each of those insurance types is its own variable. Is there any way I can create variable "Federal" without saying if MEdicaid=1 and Medicare=1 and so on.....

data have

studynum Medicaid Medicaid

1 1 0

2 0 1

3 1 0

Re: Simplifying IF_THEN STATEMENTS

PGStats — Sat, 16 Mar 2019 04:42:32 GMT

A single transpose step:

proc transpose data=have out=want(where=(col1)) name=federal;
by studynum;
var medicaid -- tricare;
run;

Re: Simplifying IF_THEN STATEMENTS

ballardw — Mon, 18 Mar 2019 16:35:58 GMT

Indian Health Service also perhaps?