Hi, I'm very new to SAS and I've written this code and it bombs out. Could any of you experts show me there errors of my way? I'm trying to get the average, max and count (some quarters are missing) for 4 quarters of data. Also, in the WHERE statement at the bottom, I'm trying to subset where the Recipients were the 3 listed?? Can I use the || to mean OR? I thought I read you could. Any help would be great! proc sql; select Employee_ID 'Employee ID', (sum(Qtr1, Qtr2, Qtr3, Qtr4)/count(Qtr1, Qtr2, Qtr3, Qtr4)) as avg_don 'Average Donation', max(Qtr1, Qtr2, Qtr3, Qtr4) as max_don 'Maximum Donation', count(Qtr1, Qtr2, Qtr3, Qtr4) as qtr_don 'Quarters Donated' from sqldata.employee_donations where (find(Recipients, "Bob" || "Kevin" || "Ashely", "i") > 0); quit;
... View more