I have many variables that I need to run through the same series of procedures--such as a proc freq, multiple proc phregs, proc means, and a proc univariate. In order to accomplish this, I have been using a macro variable, for example:   %let myvariable=grams_fruit followed by my various procedures, such as    proc freq data=mydata; tables age*&myvariable / chisq; where &myvariable ne 0; run;   proc means data=mydata; var age; class &myvariable; run; and so on.   Then, I would run the let statement again with the next variable (%let myvariable=grams_veg), and run all of my procedures again.   Is there a better way to do this, where I can loop my list of variables to be used in this series of procedures? It is important that all of these procedures produce results for one variable (eg grams_fruit) before moving on to the next. ... View more

  I would like to create an indicator at the row level for if a series of codes appears in a range of columns. The logic should be: If any of columns code_0-code_n have values starting with '345', '817' or 'I37'  indicator=1, else indicator=0. It's important that it is "starts with" rather than contains, because I do not want codes like "G345" to be counted.   Here is a small version of what the data looks like--in reality it is up to 24 codes. data WORK.IMPORT; infile datalines dsd truncover; input person:$4. code_0:$4. code_1:$4. code_2:$4. code_3:$4. code_4:$4. code_5:$4.; datalines; Jane 345 I371 693 1125 G260 2461 Jake G345 8170 565 8172 8701 2717 Joan 890 8172 653 C980 3652 I370 Mark 410 149 K628 3450 229 S280 Mary 2797 D140 P635 1025 445 O980 ;;;;   I'm relatively new to SAS--I tried with this array, but it seemed to only count if the last code began with those strings: array icd code_0-code_5; do i = 1 to dim(icd); if icd[i]=:'345' or icd[i]=:'817' or icd[i]=:'I37' the indicator=1; else indicator=0; end;  Thanks in advance for your help.   ... View more