I was able to format the variables the way I was hoping, but now I am having an issue with using the "IF statement" This is the code I currently have: options nodate nonumber; proc format; value $institutef 'Cancer Institute 1' = 'CI1' 'Cancer Institute 2' = 'CI2' 'Cancer Institute 3' = 'CI3' 'Cancer Institute 4' = 'CI4' 'Cancer Institute 5' = 'CI5'; value $cancertypef 'Acute Lymphocytic Leukemia (ALL)' = 'ALL' 'Acute Myeloid Leukemia (AML)' = 'AML' 'Chronic Lymphocutic Leukemia (CLL)' = 'CLL' 'Chronic Myeloid Leukemia (CML)' = 'CML'; proc import out=Project3 datafile = "C:\Users\efwalters\Documents\computerapps\Project3.xlsx" dbms=xlsx replace; getnames=yes; run; data project3; set project3; format leu_type $cancertypef. inst_num $institutef.; run; data tempp; set project3; if inst_num = CI1; data temp1; set tempp; if leu_type = ALL; x = ranuni(0); output; proc sort data=temp1; by x; run; data one; set temp1 (obs=5); run; proc print data=one; run; And in the log window, this note appears: "NOTE: Variable CI1 is uninitialized."
... View more