topic Re: Coding an indicator 0-1 in SAS Programming

Coding an indicator 0-1

ma23nu32el — Tue, 16 Jun 2020 16:40:03 GMT

I have to create a 0-1 variable called dblehdr that indicates whether the triple play occurred during a game that was part of a double-header this is what I have but is not returning the value that I need, what I'm doing wrong?

data trp2;
infile trpd2 DLM=',' DSD Firstobs=2 missover;
input Year Date :$12. Game IAT Team :$12. LG $ HA $ oppteam :$12.
OLG $ players :$150. inn $ SCRVH $ batter :$20. runner1 :$20. runner2 :$20.
runner3 :$20.;
if Date='' then delete;
if dblehdr= indexc(Date,'()') then do;
dblehdr=1;
end;

Thank you

Re: Coding an indicator 0-1

smantha — Tue, 16 Jun 2020 16:48:58 GMT

sample input data would be good. How is date coded for double header? does it have two values in parantheses. dblehdr is not previously defined so it will never be true. try the code below instead.

data trp2;
infile trpd2 DLM=',' DSD Firstobs=2 missover;
input Year Date :$12. Game IAT Team :$12. LG $ HA $ oppteam :$12.
OLG $ players :$150. inn $ SCRVH $ batter :$20. runner1 :$20. runner2 :$20.
runner3 :$20.;
if Date='' then delete;
dblehdr= (indexc(Date,'()')>0) ;
run;

Re: Coding an indicator 0-1

ballardw — Tue, 16 Jun 2020 17:07:28 GMT

@ma23nu32el wrote:

I have to create a 0-1 variable called dblehdr that indicates whether the triple play occurred during a game that was part of a double-header this is what I have but is not returning the value that I need, what I'm doing wrong?

data trp2;
infile trpd2 DLM=',' DSD Firstobs=2 missover;
input Year Date :$12. Game IAT Team :$12. LG $ HA $ oppteam :$12.
OLG $ players :$150. inn $ SCRVH $ batter :$20. runner1 :$20. runner2 :$20.
runner3 :$20.;
if Date='' then delete;
if dblehdr= indexc(Date,'()') then do;
dblehdr=1;
end;

Thank you

You code does not show where dblehdr is read from. So this statement

if dblehdr= indexc(Date,'()') then do;

has a serious problem because you are using the value of the variable dblehdr in the IF before it has a value assigned. So the if is always false.

SAS will return 0 for "false" and 1 for "true" when using logical comparisons. So @smantha's code will assign a 1 if the "date" has either a ( or ) character in it.

And what value would indicate a triple play? What variable?

Re: Coding an indicator 0-1

Reeza — Tue, 16 Jun 2020 17:21:00 GMT

I would recommend separating your steps. First read the data in. Make sure that is working correctly and then do your cleaning in a second step. This allows you to test each stage separately and more easily identify errors.

As BallardW indicated, the variable, dblehdr, is never read in or exists prior to usage so that will not work.

data trp2;
infile trpd2 DLM=',' DSD Firstobs=2 missover;
input Year Date :$12. Game IAT Team :$12. LG $ HA $ oppteam :$12.
OLG $ players :$150. inn $ SCRVH $ batter :$20. runner1 :$20. runner2 :$20.
runner3 :$20.;

run;

data trp3;
set trp2;
if Date='' then delete;
if dblehdr= indexc(Date,'()') then
dblehdr=1;
run;