Hi all, I have to prepare an adhoc report like this Type Price1 Price2 Price3 Price4 Insurance Val.table1 Val.table2 Val.table3 Val.table4 Catastrophe Val.table2 Val.table4 Risk Val.table1 Val.table2 Val.table3 Val.table4 Man Made Val.table1 Val.table3 Natural Val.table1 Val.table2 Val.table3 Val.table4 Health Val.table2 Val.table4 what I am confused about is how to prepare the dataset for something like this. I have an approach in mind like to Create temp tables using SQL joins and then use them something like this proc sql; create table temp1 as select a.val1,b.name from table1 left join comm_table b on a.key=b.key where b.name in ('Insurance,Risk,Man Made,Natural); quit; proc sql; create table temp2 as select a.val2,b.name from tabel2 left join comm_table b on a.key=b.key where b.name in ('Insurance,Catastrophe,Risk,Health); quit; proc sql; create table temp3 as select a.val3,b.name from table3 left join comm_table b on a.key=b.key where b.name in ('Insurance,Risk,Natural); quit; proc sql; create table temp4 as select a.val4,b.name from table4 left join comm_table b on a.key=b.key where b.name in ('Insurance,Catastrophe,Risk,Natural); quit; data final; set temp1 temp2 temp3 temp4; run; Am I thinking in correct direction??? because this set statement will produce the missing values for remaining variables so I am in fix to how to create the final dataset. Can somebody come up with better approach. May be just one SQL statement and then how to go about producing report like this. Should I go for PROC Report or in this case one should go for data _null_ reporting.
... View more