Its Unique users in 2014 .   ... View more

 Hi Reeza,   Thanks for all your help . It is to identify unique id in 2014 , unique id in 2015 and unique id in both 2014 and 2015 . ... View more

Hi Reeza, After we run test data Test56 would have below columns with 0 and 1's and we do proc summary on those columns . I can rename the columns in the output data as well as in the report like CC_AOS .   SN_CCY1 SN_CCY2 SN_BBY1 SN_BBY2 SN_Pairy1 SN_Pairy2 PP_CC PP_BB SN_Pairy1Y2             DATA TEST56(KEEP=   SN_CCY1 SN_CCY2 SN_BBY1 SN_BBY2 SN_Pairy1 SN_Pairy2 PP_CC PP_BB SN_Pairy1Y2 ); SET XYZ END = EOF; BY id ; RETAIN CCY1 CCY2 BBY1 BBY1 ; IF FIRST.id THEN DO; BBY1 = 'N'; BBY2 = 'N'; CCY1 = 'N'; CCY2 = 'N'; END;   IF CC GT 0 AND YEAR = 2014 THEN CCY1 = 'Y' ; IF CC GT 0 AND YEAR = 2015 THEN CCY2 = 'Y' ; IF BB GT 0 AND YEAR = 2014 THEN BBY1 = 'Y' ; IF BB GT 0 AND YEAR = 2015 THEN BBY2 = 'Y' ;     IF LAST.id OR EOF THEN DO; SN_CCY1 = 0; SN_CCY2 = 0; PP_CC = 0; SN_BBY1 = 0; SN_BBY2 = 0; PP_BB = 0; SN_Pairy1 = 0; SN_Pairy2 = 0; SN_Pairy1Y2 = 0; IF CCY1 = 'Y' THEN SN_CCY1 = 1; IF CCY2 = 'Y' THEN SN_CCY2 = 1; IF CCY1 = 'Y' AND CCY2 = 'Y' THEN PP_CC = 1;     IF BBY1 = 'Y' THEN SN_BBY1 = 1; IF BBY2 = 'Y' THEN SN_BBY2 = 1; IF BBY1 = 'Y' AND BBY2 = 'Y' THEN PP_BB = 1; IF CCY1 = 'Y' OR BBY1 = 'Y' THEN SN_Pairy1 = 1; IF CCY2 = 'Y' OR BBY2 = 'Y' THEN SN_Pairy2 = 1; IF PP_CC = 1 or PP_BB = 1 THEN SN_Pairy1Y2 = 1; OUTPUT TEST56; END;     RUN;     PROC SUMMARY DATA = test56; VAR SN_CCY1   SN_CCY2 PP_CC SN_BBY1 SN_BBY2 PP_BB SN_Pairy1 SN_Pairy2 SN_Pairy1Y2 ; OUTPUT OUT = TEST1 SUM= ; RUN;     PROC PRINT DATA = TEST1; RUN; ... View more

Hi Cynthia , I can rename them CC_AOS , BB_AOS . Also , I can create a dataset which includes headings Total Series Id 2014, Total Series Id 2015 like that . I have attached sample data Can you please help with the report ? ... View more

Hi Reeza,   I have attached test data for Dataset xyz .            ... View more

Sure I will do that ... View more

Yes exactly right . ... View more

Can you please suggest some ideas on how to approach this ... View more

Hi Reeza, Below is the code which generates TEST1 Dataset 　 　 DATA TEST56(KEEP=   SN_CCY1 SN_CCY2 SN_BBY1 SN_BBY2 SN_Pairy1 SN_Pairy2 PP_CC PP_BB SN_Pairy1Y2 ); SET XYZ END = EOF; BY id ; RETAIN CCY1 CCY2 BBY1 BBY1 ; IF FIRST.id THEN DO; BBY1 = 'N'; BBY2 = 'N'; CCY1 = 'N'; CCY2 = 'N'; END;   IF CC GT 0 AND YEAR = 2014 THEN CCY1 = 'Y' ; IF CC GT 0 AND YEAR = 2015 THEN CCY2 = 'Y' ; IF BB GT 0 AND YEAR = 2014 THEN BBY1 = 'Y' ; IF BB GT 0 AND YEAR = 2015 THEN BBY2 = 'Y' ;     IF LAST.id OR EOF THEN DO; SN_CCY1 = 0; SN_CCY2 = 0; PP_CC = 0; SN_BBY1 = 0; SN_BBY2 = 0; PP_BB = 0; SN_Pairy1 = 0; SN_Pairy2 = 0; SN_Pairy1Y2 = 0; IF CCY1 = 'Y' THEN SN_CCY1 = 1; IF CCY2 = 'Y' THEN SN_CCY2 = 1; IF CCY1 = 'Y' AND CCY2 = 'Y' THEN PP_CC = 1;     IF BBY1 = 'Y' THEN SN_BBY1 = 1; IF BBY2 = 'Y' THEN SN_BBY2 = 1; IF BBY1 = 'Y' AND BBY2 = 'Y' THEN PP_BB = 1; IF CCY1 = 'Y' OR BBY1 = 'Y' THEN SN_Pairy1 = 1; IF CCY2 = 'Y' OR BBY2 = 'Y' THEN SN_Pairy2 = 1; IF PP_CC = 1 or PP_BB = 1 THEN SN_Pairy1Y2 = 1; OUTPUT TEST56; END;     RUN;     PROC SUMMARY DATA = test56; VAR SN_CCY1   SN_CCY2 PP_CC SN_BBY1 SN_BBY2 PP_BB SN_Pairy1 SN_Pairy2 SN_Pairy1Y2 ; OUTPUT OUT = TEST1 SUM= ; RUN;     PROC PRINT DATA = TEST1; RUN;       ... View more

Hi , No SAS Dataset has these headings I am manually typing in excel for these headings ( CC,BB,Paired , AOS , LOS Total Series Id, 2014 , Total Series Id, 2015 , Total Series Id, every year). Then putting values from SAS Dataset  Test1  .  AOS when it says SN_CCY1 then inserting into CC 2014 and so on ..         Series Id yearly             AOS     LOS                         CC BB Paired CC BB Paired   Total Series Id, 2014  values with suffix y1 values fall here             Total Series Id, 2015  values with suffix y2 fall here             Total Series Id every year                                                   ... View more

ALL SN_CCY1 , SN_BBY1 , SN_Pairy1 all these values should be under Total Series Id, 2014 and also under CC,BB,Paired respectively (10,40,235) ALL SN_CCY2 , SN_BBY2 , SN_Pairy2 all these values should be under Total Series Id, 2015 and also under CC,BB,Paired respectively (20,50,540) ALL PP_CC , PP_BB , SN_PairY1y2 all these values should be under Total Series Id, every year and also under CC,BB,Paired respectively All above reading should be under AOS heading I am manually typing in excel for these headings CC,BB,Paired , AOS , Total Series Id, 2014 , Total Series Id, 2015 , Total Series Id, every year Is there a way to put all those values from two SAS Datsets to the report and report code should automatically but the headings     Exactly same for LOS also but under heading LOS Can you please help ? Thank you ... View more