Hi Sundaresh,   I tried to apply filters on similar variable with spaces in variabe name and this is how it worked for me-     Condition:    'Team Name'n = 'Atlanta'   Please check attached screenshots.   ... View more

Try this:-    %let mon=201305;  %let mon = %sysfunc( intnx( month , %sysfunc( inputn( &mon. , yymmn6. ) ) , 0 ) , date9. ) ;  %let want=%sysfunc(catx(/,%sysfunc(substr(&mon,3,3)),%sysfunc(substr(&mon,6,4))));  %put &want;     ... View more

Hi RW9,   I tried executing your code. The final structure of the output table is perfect as per the requirement but the values are dragged over observation. Also there are some unnecessary columns in final dataset. See below:             data want; 1130            set test; 1131            array vol_{3}; 1132            array rev_{3}; 1133            array profit_{3}; 1134            array sp_{3}; 1135            do i=1 to 3; 1136              volume=cats("Vol_",put(i,1.)); 1137              volume_fig=vol_{i}; 1138              revenue=cats("Rev_",put(i,1.)); 1139              revenue_fig=rev_{i}; 1140              profit=cats("Profit_",put(i,1.)); 1141              profit_fig=profit_{i}; 1142              sp=cats("SP_",put(i,1.)); 1143              sp_fig=sp_{i}; 1144              output; 1145            end; 1146          run; NOTE: There were 2 observations read from the data set WORK.TEST. NOTE: The data set WORK.WANT has 6 observations and 24 variables. NOTE: Compressing data set WORK.WANT increased size by 100.00 percent.       Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time):       real time           0.39 seconds       cpu time            0.01 seconds       But with the code i shared, we get the final table structure as well as desired values and columns perfectly. Still Your code and use of arrays is really impressive. It reduced a lot of typing work. Thanks for sharing that technique.     -Rishi     ... View more

Check this if its useful. Its lenghty but final dataset has the output what you expected...           data test;         Input Item Category $  Subcategory $ Vol_1 Vol_2 Vol_3 Rev_1 Rev_2 Rev_3 Profit_1 Profit_2 Profit_3 SP_1 SP_2 SP_3;         cards;         1 ABC cv 2 3 4 10 34 55 12 12 11 20 21 22         2 xyz xc 4 6 7 23 44 66 14 15 12 23 23 25         ;         run;         data Vol(keep= Item Category Subcategory Vol_1 Vol_2 Vol_3);            set test;         run;         data Rev(keep= Item Category Subcategory Rev_1 Rev_2 Rev_3);            set test;         run;         data Profit(keep= Item Category Subcategory Profit_1 Profit_2 Profit_3);            set test;         run;         data SP(keep= Item Category Subcategory SP_1 SP_2 SP_3);            set test;         run;           proc transpose data=Vol                        out=Vol_tp(rename=(col1=Volume_Fig))                        name=Volume;         by Item category Subcategory ;         label volume=" ";         run;         proc transpose data=Rev                        out=Rev_tp(rename=(col1=Revenue_Fig))                        name=Revenue;         by Item category Subcategory ;         label Revenue=" ";         run;         proc transpose data=Profit                        out=Profit_tp(rename=(col1=Profit_Fig))                        name=Profit;         by Item category Subcategory ;         label Profit=" ";         run;         proc transpose data=SP                        out=SP_tp(rename=(col1=SP_Fig))                        name=SP;         by Item category Subcategory ;         label SP=" ";         run;         data final;         merge vol_tp rev_tp profit_tp sp_tp;         by item category subcategory;         run;       ... View more