data work.combined; merge TMP1.HW10Demo (in=inD) TMP2.HW10Baseline (in=inB); by Site; if inD and inB then Complete=11; else if inD and ~inB then Complete=10; else Complete=01; Age=yrdif(DOB,Entry,'act/act'); TTime=datdif(Entry,Test,'act/act'); data work.DBF; merge work.combined TMP3.HW10Followup; FupTime=datdif(Entry,fupdt,'act/act'); data work.SID; merge TMP1.HW10Baseline (in=inB) TMP3.HW10Followup (in=inF); by Site; if inB and inF then keep Site ID fupdt fuptest Test Score; else if inB and ~inF then drop fupdt fuptest Test Score; run; My last data step I am trying to merge those two sets and only keep variables that have both Baseline and Follow Up data in the new set. I am getting an error that says my variables have never been referenced. Help please! ... View more

I am using a paired means test to determine how many subjects to add to my sample to increase my power to 80%. I am still confused on what to use for my correlation though. I used my Satterthwaite t-value but want to make sure that is correct. If not, can you explain what the proper steps would be? ... View more

Hi, I am on SAS 9.4 and I need to convert weight variables in a column to pounds if they are in kilograms and do nothing if the value is in pounds. Some variables read 7lbs12oz and others read 3.4kg. I don't know how to ignore or remove the alphabetical characters so that I can cleanly do the math on the kilogram values and leave the rest alone. Does that make sense? Please help! ... View more