Well given that you only provide pieces of information, here is one way you could make your Period  variable be a date: data in; input Period $    Col1    Col2    Col3    Col4    Col5    Col6    Col7    Col8    Col9    Col10    Col11; cards; 1/9    0    0    12    48    0    0    0    0    36    0    0 10/8    48    528    48    24    12    96    24    0    24    1725    210 10/9    24    312    192    300    120    132    120    60    228    735    150 11/8    0    0    24    48    12    0    0    0    36    0    0 11/9    36    372    192    192    48    60    144    24    168    960    75 12/8    36    372    180    192    36    108    72    36    132    960    105 12/9    36    180    180    300    36    72    120    48    168    1005    105 13/8    84    372    180    192    84    108    60    48    108    735    180 13/9    12    228    108    24    0    108    60    60    84    1140    135 14/8    24    552    144    156    12    24    84    12    180    915    105 14/9    24    492    96    48    0    84    48    0    60    1140    90 15/8    24    336    168    144    48    36    60    24    132    960    105 15/9    0    0    24    36    12    0    0    0    60    0    0 16/8    24    336    96    60    24    36    60    24    36    1080    225 16/9    24    180    144    144    0    84    60    24    180    660    135 17/8    0    528    24    12    24    72    48    0    24    1455    90 17/9    24    120    120    156    72    72    48    72    132    450    120 18/8    0    0    12    24    12    0    0    0    36    0    0 19/8    12    336    120    132    24    84    36    84    120    915    105 2/9    36    240    144    192    72    60    72    36    216    855    150 20/8    36    420    132    204    24    36    120    24    156    780    60 ; data want; set in; my_date = mdy(scan(period,2, "/"), scan(period, 1,"/"), 2013); format my_date date9.; run; I obviously don't know what year is attached to these dates.... Anca. ... View more

Hi. It would helpful to provide a bit more detail. But, the name = col_name it is simply you renaming the name as col_name. OK, you want to have that variable be numeric, but that is not possible because the NAME variable contains the name of the variable you are transposing. Ok, let me try to explain with an example (as you should have,too) proc transpose data = sashelp.class out = test name = col_name; var sex; run; If you run the code above, you'll see that all you've done is change the name of the variable _NAME_ to col_name, which is the same as running this code proc transpose data = sashelp.class out = test; var sex; run; The variable _NAME_ (or whatever you may want to call it) will always be character because it contains the information (name...) of the variable you are transposing. ok. So, maybe you can provide more details about what would you like? Anca. ... View more

Hi. This code will get you started, however I don't have time now to think about how tor remove the extra commas. proc sort data = have out = temp;by requestid criteriaid criteria; proc transpose data = temp out = temp2(drop = _NAME_ _LABEL_) prefix = criteria;     var criteria_value;     by requestid criteriaid criteria; run; data want(keep = requestid criteriaid my_criteria_final );     set temp2; /*    temp_var = cat(compbl(criteria), ":", compbl(criteria_value));*/     my_criteria_final = cats(criteria, ":",criteria1,",",criteria2,",",criteria3); run; Good luck. Anca. ... View more

Hi. glad it worked. You need to remove the comma before the mflag = "Mflag" * (....); Using this data: data test; do grp=1 to 4;   do flg='Yes','No';    do mflag  = "Yes", "No";    do sec='dsfsa', 'fdafa', 'afafa';    output;   end;   end; end; end; run; proc tabulate data=test; class grp flg sec mflag; table grp *flg ,   sec="Section" * (n="n" * f=10. PCTN<FLG>="%" * f=7.2 )   mflag="Mflag" * (n="n" * f=10. PCTN<FLG>="%" * f=7.2 )   / misstext="0" rts=40; run; Good luck. Anca. ... View more

Thank you, Sanjay, I finally got it to work. It is not the most intuitive to me what is the wallpercent but for the longest time I kept getting "out of bounds" error. drawarrow x1="10"  y1=1.25 x2="40" y2=1.25 /           x1space=wallpercent y1space=datavalue            x2space=wallpercent y2space=datavalue            arrowheadshape=filled lineattrs=(color=red) ; The bolded statement, once I get them to work make sense. Thank you! ... View more