Hello. I'm having some basic problems. First, when trying to create a new variable with if then statements I kept getting the error code 180 "Statement is not valid or it is used out of proper order". I finally figured out that when I used the code below I was able to get the if then statements to work. But I'm finding that I have to include the data step with every variable I want to create. Now, when I try to create a table with two variables I get an error that one of the variables cannot be found. I'm not really sure why the if/then statements wouldn't work at first and why I have to now include the data step every time. Any help would be appreciated for this frustrated novice 🙂 Thank you! data a; set edat.els0212byf3pststu_; latino=.; if bys15=1 then latino=1; *hispanic; if bys15=0 then latino=0; *non-hispanic; if bys15 in (-1,-2,-4,-6,-8,-9) then latino=.; else if latino=. then delete; run; proc freq data=a; tables latino; run; data a; set edat.els0212byf3pststu_; male=.; if bys14=1 then male=1; *male; if bys14=2 then male=0; *female; if bys14 in (-2,-4,-8,-9) then male=.; else if male=. then delete; run; proc surveyfreq data=a; tables latino*male; run; I
... View more