topic Re: SQL in SAS Programming

SQL

Ranjeeta — Fri, 07 Dec 2018 21:45:40 GMT

title "Ablation Procedures by Site";

proc sql;

create table procedures as

select id,days_to_removal date,acceptancesitenumber,fyear,

case

when ep_diagnosticprocedureind = 'Y' as ep_study,

when ep_ablationprocedureind ='Y' and (ep_dp_simpleind ='Y' or ep_dp_standard_otherind ='Y')then 'Y' else 'N' end as ablations simple

from ccnrecs

where removalreasoncd='PS';

quit;

I would appreciate if someone can advise if the above is written technically accurately?

Re: SQL

PeterClemmensen — Fri, 07 Dec 2018 21:49:56 GMT

Have you tried to run it? What does the log say?

Re: SQL

Ranjeeta — Fri, 07 Dec 2018 22:09:42 GMT

Im waiting for an actual connection to the server to get the data ..just writing the query to make sure I have it ready when I get the data so wanted to ensure its correct

Re: SQL

SASKiwi — Fri, 07 Dec 2018 22:28:26 GMT

The syntax of your CASE statement isn't right. This version is but I have no idea if it is "correct". You will have to prove that for yourself by running it.

case
when ep_ablationprocedureind = 'Y' and (ep_dp_simpleind = 'Y' or ep_dp_standard_otherind = 'Y') then 'Y' 
else 'N' 
end 
as ablations_simple