Hi,
I need to make a change to the exsiting code but it's written in PORC SQL.
My code (Below) iswritten in SAS. Any idea how I convert the SAS code into PROC SQL so it will just slot into some exisiting code please?
proc means data=Additional_Dataset mean;
var pd_long_run;
where current_default ne 'Y';
weight balance_outstanding;
output out=pd mean=;
run;
Something like this may be helpful.
proc sql;
create table pd as
select sum(pd_long_run*balance_outstanding)/sum(balance_outstanding) as Weighted_Avg from
Additional_Dataset
where current_default ne 'Y';
quit;
Thanks, but i need it in one statement, probably like a case statement as this is just a one line needed in the middle of the exisiting code.
Somthing like -
mean(case when Current_default ne 'Y' then PD_Long_Run else 0 end) as pd but this doesn't work.
Please provide some sample data.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.