Hi Paige! Sorry for the picture. That didnt occur to me, actually but makes perfect sense! Excuse my naivete, but is there a way to copy and paste the data efficiently? I am trying to create the variable like you said! If you look at the first bit of code, I was intending to create a "yes" and "no" category and I have been working off that premise using different variations of this: data obese2;
set BMI_DOB;
If age = 18 and 30>=BMI >= 20 then Class = 'Yes';
Else if age = 18 and (20>BMI or BMI >30) then Class = 'No';
run;
data obese2;
set obese2;
if ID >0 and Class= 'Yes' then Class = 'Yes';
else if ID > 1 and Class='No' then Class='No';
run; Basically, I got the part where when age=18 and its in that BMI range i get a yes. Otherwise, I get a no. However, for the rest of the occurences of that ID, I can not get them all to populate "Yes" or "No". If I try make a category, then if the same ID goes above 30 BMI then it changes the Class from "Yes" to "No" if that makes sense. I will attempt to put my data here. I apologize. data WORK.BMI_DOB;
infile datalines dsd truncover;
input ID:32. Gender:32. DOB_M:32. DOB_Y:32. Race:32. Year:32. Height:32. Weight:32. BMI:6.3 DOB:MONYY7. Age:32.;
format BMI 6.3 DOB MONYY7.;
label ID="PUBID - YTH ID CODE 1997" Gender="1= Male, 2=Female" DOB_M="Date of Birth Month" DOB_Y="Date of Birth Year" Race="1= Black, 2= Hispanic, 3= Mixed Race (Non-Hispanic) 4= Non-Black / Non-Hispanic" Year="Year the Survey took place" Height="Height in
Inches" Weight="Weight in pounds" BMI="Body Mass Index";
datalines;
1 2 9 1981 4 1997 67 145 22.708 SEP1981 16
1 2 9 1981 4 1998 67 150 23.491 SEP1981 17
1 2 9 1981 4 1999 67 150 23.491 SEP1981 18
1 2 9 1981 4 2000 68 160 24.325 SEP1981 19
1 2 9 1981 4 2001 67 163 25.527 SEP1981 20
1 2 9 1981 4 2002 67 155 24.274 SEP1981 21
1 2 9 1981 4 2003 67 153 23.961 SEP1981 22
1 2 9 1981 4 2004 67 160 25.057 SEP1981 23
1 2 9 1981 4 2005 67 160 25.057 SEP1981 24
1 2 9 1981 4 2006 67 157 24.587 SEP1981 25
1 2 9 1981 4 2007 67 156 24.430 SEP1981 26
1 2 9 1981 4 2008 67 160 25.057 SEP1981 27
1 2 9 1981 4 2009 67 158 24.744 SEP1981 28
1 2 9 1981 4 2010 67 152 23.804 SEP1981 29
1 2 9 1981 4 2011 67 155 24.274 SEP1981 30
1 2 9 1981 4 2013 67 152 23.804 SEP1981 32
1 2 9 1981 4 2015 67 175 27.406 SEP1981 34
2 1 7 1982 2 1997 67 135 21.142 JUL1982 15
;;;; Thank you for that link, it was REALLY helpful- will bookmark. Im not getting errors per se, but not getting the results that I am intending. Trying to find a creative solution around the problem and wanted to see if anyone had experience with this sort of thing/could give me a hint. If I havent explained well enough, I can try to explain better.
... View more