@Lohia wrote: Hi guys, there is one more thing i wanna discuss. Problem: Code run to produce a summarized report for top 5 states on top 5 disease. Currently i'm running 6 codes to produce these stats. One for, to find out the top 5 and then run on them and get whole summary(Using different values and parameter) Then other 5 codes to generate seperate reports on 5 states(because they have different data/parameter values) Now i wanna combine these to one, after running for whole i wanna store top 5 states values into a variable and wanna pass it to macro progamm to assign state value one by one and prodce results on different parameter values. Any suggestion around this problem? Thanks, Suggestions: 1) Start a new thread. This question is much more complicated than this thread and deserves a separate thread 2) Post some example of the data you have, the code you are using and what the result looks like    Post data in the form of data step so we don't have to ask what types of values, variable type and such, and the example code all in code boxes using the forum {i} menu icon.   Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.   3) Likely approaches will involve having a data set that has some of the information related to how to process each state when needed such as dataset names, variables for which role. So you may think about setting that data set up as well if it does not already exist. ... View more

Thank you everyone, i tried RWS method its working. Initially i also tried the same but forgot to remove quotes from the date Thats why when i'm applying the right method its showing me the error like not resolved "'2016-01-01'". Thanks a lot again.. ... View more

Thanks a lot Reeza and Ksharp . Really helpful guys 🙂  ... View more

data HAVE; infile cards missover; input (ID VAL1-VAL8) ($) ; cards; C1 a a b c d d V1 10 12 2 4 5 7 C2 s s f f e e V2 2 3 4 5 6 7 C3 q q w d e e e e V3 2 5 6 7 8 8 8 8 C4 f f f f f f g h V4 3 4 5 6 7 6 7 8 run; proc transpose data=have out=temp(drop=_name_); by id notsorted; var val:; run; data temp1; merge temp(where=(id=:'C' and col1 is not missing)) temp(where=(_id=:'V' and _col1 is not missing) rename=(id=_id col1=_col1) ); run; data temp2; set temp1; by id col1 notsorted; if first.col1 then sum=0; sum+input(_col1,best8.); if last.col1; run; proc transpose data=temp2 out=temp3; by id _id notsorted; var col1 sum; run; data want; set temp3; length new_id $ 40; new_id=ifc(_name_='COL1',id,_id); drop id _id _name_; run; ... View more