Hello   I am trying to insert data into my table using the case-when statement, however I am getting a syntax error. Here's what I am trying to do:   proc sql; insert into temp1 (x,y,z) values( case when condition 1 then a         when condition 2 then b         else c         end as x, case when condition 3 then c         when condition 4 then d         else e         end as y, case when condition 5 then f         when condition 6 then g         else g         end as z) run;   Thank you. ... View more

Hello, I am new to SAS and learning basics at the moment. I want to do insert values in my table for a particular date frame - say, a week. How should I write this in proc sql using a do loop so I don't have to write 7 similar queries for each date? Thank you!     ... View more