Hi Paige, If arrays look across rows, then how would I do the same thing as I was trying? Attached is the dataset. Also, for the final output, it should contain the records that say Abdominal pain, Eye Irritation and Nasopharyngitis. I am trying to make an array that will look across the rows and choose only the columns that have at least the value 2. If it looks across the row and doesn't find a value greater than or equal to 2, it won't be part of the subset. Below is my code. data omkar.final;
set final;
array n{*} _numeric_; /* gets all numeric variables into array */
do i=1 to dim(n); /* Do for all elements */
if n{i}=. then n{i}=0;
if n(i) gt 2;
end;
run;
... View more