topic Re: Case Statement in SAS Programming https://communities.sas.com/t5/SAS-Programming/Case-Statement/m-p/197482#M305417 <HTML><HEAD></HEAD><BODY><P>The first one is missing the END keyword before the AS keyword</P></BODY></HTML> Tue, 07 Jul 2015 18:52:24 GMT Tom 2015-07-07T18:52:24Z Case Statement https://communities.sas.com/t5/SAS-Programming/Case-Statement/m-p/197481#M305416 <HTML><HEAD></HEAD><BODY><P>Can I have some help on the case statement please, hopefully the logic of what im trying to do is clear, I just need to put it within the correct format please?</P><P></P><P>Proc sql;<BR />Create table work.sk as <BR />select <BR />Product_End_Date as Product_end_date,<BR />Term as Term,<BR />Launch_Code as launch_code,<BR />LTD_Pipeline as Pipeline_ytd,<BR />LTD_Completions as Completions_ytd,<BR />CATX(",", product_end_date, term, launchcode)as Date_Term_Prod,<BR />Term_hedge_2 as Term_hedge_2 ,<BR />Prepayment_rate_hedge_2 as Prepayment_rate_hedge_2,<BR />Conversion_Rate_hedge as Conversion_Rate_hedge,<BR />Key_hedge as Key_hedge,<BR />Product_Term_comps as Product_Term_comps,</P><P></P><P><SPAN style="color: #ff0000;">case </SPAN><BR /><SPAN style="color: #ff0000;">when Date_Term_Prod = Key_hedge then Conversion_Rate_hedge else 0 as Alco_pc,</SPAN><BR /><SPAN style="color: #ff0000;">Case</SPAN><BR /><SPAN style="color: #ff0000;">when Product_Term_comps = Term_hedge_2 then Prepayment_rate_hedge_2 else 0 end as prepayment</SPAN></P><P></P><P>From Hedging_Dataset;<BR />quit;</P></BODY></HTML> Tue, 07 Jul 2015 18:33:03 GMT https://communities.sas.com/t5/SAS-Programming/Case-Statement/m-p/197481#M305416 anonymous_user 2015-07-07T18:33:03Z Re: Case Statement https://communities.sas.com/t5/SAS-Programming/Case-Statement/m-p/197482#M305417 <HTML><HEAD></HEAD><BODY><P>The first one is missing the END keyword before the AS keyword</P></BODY></HTML> Tue, 07 Jul 2015 18:52:24 GMT https://communities.sas.com/t5/SAS-Programming/Case-Statement/m-p/197482#M305417 Tom 2015-07-07T18:52:24Z