topic Re: Else then else error in SAS Programming

topic Re: Else then else error in SAS Programming https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568453#M160020 <P>Are you missing a DATA statement at the beginning?</P> Mon, 24 Jun 2019 18:29:55 GMT PGStats 2019-06-24T18:29:55Z Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568449#M160018 <P>Hi,</P><P>I'm trying to run what seems like pretty basic code, but continually get an error.</P><P> </P><P>Here is the code:</P><P> </P><P>set OAH_BL;</P><P><BR />Gradeb=left(trim(Grade));</P><P>If Gradeb<='8th' then GradeNu3=1;<BR />else if Gradeb='9th' or Gradeb='10th' then GradeNu3=2;<BR />else if Gradeb='11th' or Gradeb='12th' then GradeNu3=3;<BR />else if Gradeb=' ' then GradeNu3='.';<BR />else if Gradeb='High school graduate or GED' then GradeNu3=4;<BR />else if Gradeb='College/Technical school' then GradeNu3=5;<BR />run;</P><P> </P><P>proc print;<BR />var GradeNu3;<BR />run;</P><P> </P><P>Here is the log:</P><P> </P><P>NOTE: The SAS System stopped processing this step because of errors.</P><P><BR />229 If Gradeb<='8th' then GradeNu3=1;<BR />--<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>230 else if Gradeb='9th' or Gradeb='10th' then GradeNu3=2;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>231 else if Gradeb='11th' or Gradeb='12th' then GradeNu3=3;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>232 else if Gradeb=' ' then GradeNu3='.';<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>233 else if Gradeb='High school graduate or GED' then GradeNu3=4;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>234 else if Gradeb='College/Technical school' then GradeNu3=5;<BR />----<BR />180</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>235 run;<BR />236<BR />237 proc print;<BR />238 var GradeNu3;<BR />ERROR: Variable GRADENU3 not found.<BR />239 run;</P><P> </P><P>Any help would be appreciated.</P><P>Best,</P><P>Mary</P> Mon, 24 Jun 2019 18:23:16 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568449#M160018 mcgannmary1 2019-06-24T18:23:16Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568453#M160020 <P>Are you missing a DATA statement at the beginning?</P> Mon, 24 Jun 2019 18:29:55 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568453#M160020 PGStats 2019-06-24T18:29:55Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568457#M160021 <P>Side note: you should use</P> <P> </P> <P><STRONG>GradeNu3=.</STRONG></P> <P> </P> <P>or</P> <P> </P> <P><STRONG>call missing(GradeNu3)</STRONG></P> <P> </P> <P>to assign a missing value to GradeNu3.</P> Mon, 24 Jun 2019 18:33:21 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568457#M160021 PGStats 2019-06-24T18:33:21Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568461#M160023 I don't think alphabetical comparisons will give you want you want. Those are character values so it will sort/order less 11<2 for example. <BR /><BR />As PgStats indicate, you're msising a data statement as well as a DATA= on your PROC PRINT. Which data set is your PROC PRINT referring to? How do you know that? Mon, 24 Jun 2019 18:34:05 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568461#M160023 Reeza 2019-06-24T18:34:05Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568500#M160035 <P>Yes, indeed I did! Thank you for catching that.</P><P> </P><P>I put that in and re-ran this code:</P><P> </P><P>/*Create a new file*/<BR />data oahbl_Recode_20190620;<BR />/*Set the file to be accessed*/<BR />set OAH_BL;</P><P>Gradeb=left(trim(Grade));</P><P>If Gradeb<='8th' then GradeNu3=1;<BR />else if Gradeb='9th' or Gradeb='10th' then GradeNu3=2;<BR />else if Gradeb='11th' or Gradeb='12th' then GradeNu3=3;<BR />else if Gradeb=' ' then GradeNu3=.;<BR />else if Gradeb='High school graduate or GED' then GradeNu3=4;<BR />else if Gradeb='College/Technical school' then GradeNu3=5;<BR />run;</P><P> </P><P>And end up with the output below:</P><DIV class="branch"><DIV align="center"><TABLE><TBODY><TR><TD><DIV align="center">Table of GradeNu3 by GradeGradeNu3 Grade(Grade)10th 11th 12th 9th College/Technicalschool Ungraded Total125TotalFrequency Missing = 29 <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>17</TD></TR><TR><TD>6.85</TD></TR><TR><TD>14.05</TD></TR><TR><TD>100.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>26</TD></TR><TR><TD>10.48</TD></TR><TR><TD>21.49</TD></TR><TR><TD>100.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>78</TD></TR><TR><TD>31.45</TD></TR><TR><TD>64.46</TD></TR><TR><TD>100.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>.</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>121</TD></TR><TR><TD>48.79</TD></TR><TR><TD> </TD></TR><TR><TD> </TD></TR></TBODY></TABLE></TD></TR><TR><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>1</TD></TR><TR><TD>0.40</TD></TR><TR><TD>100.00</TD></TR><TR><TD>100.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>.</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>1</TD></TR><TR><TD>0.40</TD></TR><TR><TD> </TD></TR><TR><TD> </TD></TR></TBODY></TABLE></TD></TR><TR><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>126</TD></TR><TR><TD>50.81</TD></TR><TR><TD>100.00</TD></TR><TR><TD>100.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR><TR><TD>0.00</TD></TR><TR><TD>.</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>126</TD></TR><TR><TD>50.81</TD></TR><TR><TD> </TD></TR><TR><TD> </TD></TR></TBODY></TABLE></TD></TR><TR><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>17</TD></TR><TR><TD>6.85</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>26</TD></TR><TR><TD>10.48</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>78</TD></TR><TR><TD>31.45</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>1</TD></TR><TR><TD>0.40</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>126</TD></TR><TR><TD>50.81</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>0</TD></TR><TR><TD>0.00</TD></TR></TBODY></TABLE></TD><TD><TABLE border="0" cellspacing="0" cellpadding="5"><TBODY><TR><TD>248</TD></TR><TR><TD>100.00</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE><P> </P><P>I checked the raw data and there should be records in groups 3 and 4.</P><P>Thank you and please excuse the centering of my desk!!</P></DIV></DIV> Mon, 24 Jun 2019 19:10:11 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568500#M160035 mcgannmary1 2019-06-24T19:10:11Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568502#M160036 <P>This is only slightly better.</P><P> </P><TABLE><TBODY><TR><TD><P>The SAS System</P></TD></TR></TBODY></TABLE><P> </P><P>The FREQ Procedure</P><TABLE><TBODY><TR><TD><TABLE><TBODY><TR><TD><TABLE><TBODY><TR><TD><P><STRONG>Frequency</STRONG></P></TD></TR><TR><TD><P><STRONG>Percent</STRONG></P></TD></TR><TR><TD><P><STRONG>Row Pct</STRONG></P></TD></TR><TR><TD><P><STRONG>Col Pct</STRONG></P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P><STRONG>Table of GradeNu3 by Grade</STRONG></P></TD></TR><TR><TD><P><STRONG>GradeNu3</STRONG></P></TD><TD><P><STRONG>Grade(Grade)</STRONG></P></TD></TR><TR><TD><P><STRONG>10th</STRONG></P></TD><TD><P><STRONG>11th</STRONG></P></TD><TD><P><STRONG>12th</STRONG></P></TD><TD><P><STRONG>9th</STRONG></P></TD><TD><P><STRONG>College/Technical<BR />school</STRONG></P></TD><TD><P><STRONG>Ungraded</STRONG></P></TD><TD><P><STRONG>Total</STRONG></P></TD></TR><TR><TD><P><STRONG>1 </STRONG></P></TD><TD><TABLE><TBODY><TR><TD><P>17</P></TD></TR><TR><TD><P>6.85</P></TD></TR><TR><TD><P>14.05</P></TD></TR><TR><TD><P>100.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>26</P></TD></TR><TR><TD><P>10.48</P></TD></TR><TR><TD><P>21.49</P></TD></TR><TR><TD><P>100.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>78</P></TD></TR><TR><TD><P>31.45</P></TD></TR><TR><TD><P>64.46</P></TD></TR><TR><TD><P>100.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>.</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>121</P></TD></TR><TR><TD><P>48.79</P></TD></TR><TR><TD><P> </P></TD></TR><TR><TD><P> </P></TD></TR></TBODY></TABLE></TD></TR><TR><TD><P><STRONG>2 </STRONG></P></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>1</P></TD></TR><TR><TD><P>0.40</P></TD></TR><TR><TD><P>100.00</P></TD></TR><TR><TD><P>100.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>.</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>1</P></TD></TR><TR><TD><P>0.40</P></TD></TR><TR><TD><P> </P></TD></TR><TR><TD><P> </P></TD></TR></TBODY></TABLE></TD></TR><TR><TD><P><STRONG>5 </STRONG></P></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>126</P></TD></TR><TR><TD><P>50.81</P></TD></TR><TR><TD><P>100.00</P></TD></TR><TR><TD><P>100.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>0.00</P></TD></TR><TR><TD><P>.</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>126</P></TD></TR><TR><TD><P>50.81</P></TD></TR><TR><TD><P> </P></TD></TR><TR><TD><P> </P></TD></TR></TBODY></TABLE></TD></TR><TR><TD><P><STRONG>Total </STRONG></P></TD><TD><TABLE><TBODY><TR><TD><P>17</P></TD></TR><TR><TD><P>6.85</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>26</P></TD></TR><TR><TD><P>10.48</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>78</P></TD></TR><TR><TD><P>31.45</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>1</P></TD></TR><TR><TD><P>0.40</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>126</P></TD></TR><TR><TD><P>50.81</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>0</P></TD></TR><TR><TD><P>0.00</P></TD></TR></TBODY></TABLE></TD><TD><TABLE><TBODY><TR><TD><P>248</P></TD></TR><TR><TD><P>100.00</P></TD></TR></TBODY></TABLE></TD></TR><TR><TD><P><STRONG>Frequency Missing = 29</STRONG></P></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P> </P> Mon, 24 Jun 2019 19:12:52 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568502#M160036 mcgannmary1 2019-06-24T19:12:52Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568503#M160037 <P>Thank you!</P><P> </P> Mon, 24 Jun 2019 19:13:44 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568503#M160037 mcgannmary1 2019-06-24T19:13:44Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568508#M160039 <P>I was trying to convert the alphabetic characters to numeric. Are you saying that converting the alphanumeric variables to numeric isn't possible with a statement like this,</P><P> </P><P>else if Gradeb='9th' or Gradeb='10th' then GradeNu3=2;</P><P> </P><P>How else might I go about creating a numeric variable from this Gradeb variable?</P><P> </P><P>Thank you!</P><P>Mary</P> Mon, 24 Jun 2019 19:21:26 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568508#M160039 mcgannmary1 2019-06-24T19:21:26Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568510#M160040 For equality comparisons that's totally fine, but for inequalities it's not. Your first line is an inequality:<BR /><BR />If Gradeb <= '8th' then GradeNu3=1;<BR /><BR />You may get unexpected behaviour with that line. Test your re-coding thoroughly.<BR /><BR /> Mon, 24 Jun 2019 19:22:51 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568510#M160040 Reeza 2019-06-24T19:22:51Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568612#M160091 <P>One approach is to use an INFORMAT to convert text to numeric.</P> <PRE>proc format library = work; invalue GradeNu (upcase) '8TH' = 1 '9TH','10TH'=2 '11TH','12TH'=3 'HIGH SCHOOL GRADUATE OR GED' =4 'COLLEGE/TECHNICAL SCHOOL' =5 ' '=. other= 1 /* assumes all the others are < 8th*/ ; data want ; set have; gradenu = input(gradeb,gradenu.)); run;</PRE> <P> </P> <P>without seeing actual values I would actually tend to actually list the grades "<" 8th grade and use OTHER=_error_ instead.</P> <P>Note the UPCASE instruction will convert the text to uppercase before comparing to the  listed values. Which may help if you have some poor data entry and have a mix of "High School" "HIGH SCHOOL" "High school". With if/then/else you  have to list every single occurring combinations of case.</P> <P> </P> <P>The other=_error_ would put an invalid data message in the log in case someone sneaks in an unexpected value such as "Graduate School" or "Vocational/Technical". If that happens you just add the appropriate text to the INVALUE and rerun the data step. No need to add additional If/then/else statements. Since I deal with data where my providers randomly make changes such as from "Returned to work or school" to "Returned to work" I have several informats like this to warn me of changed data entry.</P> Mon, 24 Jun 2019 23:12:53 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568612#M160091 ballardw 2019-06-24T23:12:53Z Re: Else then else error https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568922#M160251 <P>This is extremely helpful!</P><P>Thanks for taking the time to share this.</P><P>Best,</P><P>Mary</P> Tue, 25 Jun 2019 20:37:29 GMT https://communities.sas.com/t5/SAS-Programming/Else-then-else-error/m-p/568922#M160251 mcgannmary1 2019-06-25T20:37:29Z