Hello , sorry for the delayed response. I have added an attachment here that show input and output data. In the input data - there are 4 M variables & year . Each M contains value either from 10,20,30,40,50. Now on this input data column M1 if i use proc sql query I provided earlier , I get output data ( which is basically a table for M1 only) I need to create such tables for M2, M3 & M4 in one go without writing this query 3 more times. These tables will be later exported into excel. Any help on this will be great. Thanks
... View more