topic Re: IF THEN statement with a combination of variables in SAS Procedures

topic Re: IF THEN statement with a combination of variables in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508013#M72884 <P>Using <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/241271">@MBlack732</a> If statements with quotes and correct spelling for varables with samename this works but you want to rethink your formats for the men.  Also note I used the upcase on gender incase a user could enter upper or lower case values.</P><P>updated for <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/138205">@novinosrin</a> to be shorter</P><P> </P><PRE><CODE class=" language-sas">/* Notes GENDER M=Male F= Female PREGNANCY 0=never been pregnant 1=has been or is pregnant 9=not available */ data have; input name $ pregnancy $ gender $; cards; Mary 1 F Mike 1 m John 0 M Ed 0 M Ann 9 F Gwen 0 F ; data want; set have; gender = upcase(gender);   if gender = 'M' and pregnancy = '1' then cat=0;<BR />  else cat = 1; run;</CODE></PRE><TABLE><TBODY><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE> Sat, 27 Oct 2018 20:52:13 GMT VDD 2018-10-27T20:52:13Z IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508004#M72879 <P>Hi! </P><P>I'm working with a data set and I'm trying to see if any of the pregnancy responses are invalid based on gender (i.e. male participants should not be recorded as having ever been pregnant). </P><P>The values are as follows:</P><P> </P><P>GENDER</P><P>M=Male </P><P>F= Female</P><P> </P><P>PREGNANCY</P><P>0=never been pregnant</P><P>1=has been or is pregnant</P><P>9=not available</P><P> </P><P>How do I write an IF THEN statement where if the participant is a man and has been pregnant than his category is 0 but any other combination of the two variables is category 1?</P> Sat, 27 Oct 2018 17:54:32 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508004#M72879 MBlack732 2018-10-27T17:54:32Z Re: IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508006#M72880 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/241271">@MBlack732</a> wrote:<BR /> <P>Hi! </P> <P>I'm working with a data set and I'm trying to see if any of the pregnancy responses are invalid based on gender (i.e. male participants should not be recorded as having ever been pregnant). </P> <P>The values are as follows:</P> <P> </P> <P>GENDER</P> <P>M=Male </P> <P>F= Female</P> <P> </P> <P>PREGNANCY</P> <P>0=never been pregnant</P> <P>1=has been or is pregnant</P> <P>9=not available</P> <P> </P> <P>How do I write an IF THEN statement where if the participant is a man and has been pregnant than his category is 0 but any other combination of the two variables is category 1?</P> <HR /></BLOCKQUOTE> <P>Just put your last sentence in code. You have already formulated the statement, only using non-SAS syntax.</P> Sat, 27 Oct 2018 17:58:53 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508006#M72880 Kurt_Bremser 2018-10-27T17:58:53Z Re: IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508008#M72881 <P>I tried this code:</P><P> </P><P>IF pregnancy=1 AND gender=M THEN cat=0;<BR />ELSE IF pregnancy=9 and gender=M THEN cat=0;<BR />ELSE IF pregnancy=9 and gender=F THEN cat=0;<BR />ELSE IF pregnancy=1 and gender=F THEN cat=1;<BR />ELSE IF pregnacy=0 and gender=F THEN cat=1;<BR />ELSE IF pregnancy=0 and gender=M THEN cat=1;</P><P> </P><P>and my log resulted in this error message:</P><P>206 IF pregnancy=1 AND gender=M THEN cat=0;<BR />--<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>207 ELSE IF pregnancy=9 and gender=M THEN cat=0;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>208 ELSE IF pregnancy=9 and gender=F THEN cat=0;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>209 ELSE IF pregnancy=1 and gender=F THEN cat=1;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>210 ELSE IF pregnacy=0 and gender=F THEN cat=1;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>211 ELSE IF pregnancy=0 and gender=M THEN cat=1;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P> </P> Sat, 27 Oct 2018 18:10:03 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508008#M72881 MBlack732 2018-10-27T18:10:03Z Re: IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508010#M72882 <P>constants are case sensitive while variable operands are case insensitive</P> <P><SPAN>IF pregnancy=1 AND gender=M THEN cat=0;</SPAN></P> <P><SPAN>should be</SPAN></P> <P> </P> <P><SPAN>IF pregnancy=1 AND gender=<STRONG>'M'</STRONG> THEN cat=0;</SPAN></P> <P> </P> <P><SPAN>change accordingly everywhere </SPAN></P> Sat, 27 Oct 2018 18:19:14 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508010#M72882 novinosrin 2018-10-27T18:19:14Z Re: IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508012#M72883 Was that code within a data step? I think that's your issue. <BR /><BR />data want; *output data set name;<BR />set have; *input data;<BR /><BR />IF statements (corrected for character variables)<BR /><BR />run; Sat, 27 Oct 2018 19:01:41 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508012#M72883 Reeza 2018-10-27T19:01:41Z Re: IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508013#M72884 <P>Using <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/241271">@MBlack732</a> If statements with quotes and correct spelling for varables with samename this works but you want to rethink your formats for the men.  Also note I used the upcase on gender incase a user could enter upper or lower case values.</P><P>updated for <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/138205">@novinosrin</a> to be shorter</P><P> </P><PRE><CODE class=" language-sas">/* Notes GENDER M=Male F= Female PREGNANCY 0=never been pregnant 1=has been or is pregnant 9=not available */ data have; input name $ pregnancy $ gender $; cards; Mary 1 F Mike 1 m John 0 M Ed 0 M Ann 9 F Gwen 0 F ; data want; set have; gender = upcase(gender);   if gender = 'M' and pregnancy = '1' then cat=0;<BR />  else cat = 1; run;</CODE></PRE><TABLE><TBODY><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE> Sat, 27 Oct 2018 20:52:13 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508013#M72884 VDD 2018-10-27T20:52:13Z Re: IF THEN statement with a combination of variables https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508015#M72885 <P>Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/122002">@VDD</a> Pleasing to note you took time to write down the IF THEN statements. </P> <P> </P> <P>Just a nit and hint, try to see if those IF THEN's can be further shortened <img id="smileywink" class="emoticon emoticon-smileywink" src="https://communities.sas.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></P> Sat, 27 Oct 2018 20:13:03 GMT https://communities.sas.com/t5/SAS-Procedures/IF-THEN-statement-with-a-combination-of-variables/m-p/508015#M72885 novinosrin 2018-10-27T20:13:03Z