SAS Support Communities

Hi all, Proc mixed generates datasets where D8.4 implemented. Is there any way to switch this options off and see all figures? Besided further 'format _all_ informat _all_'.    ... View more

Hi all,   Can you please help to change axis attributes. Here it is the dataset: data WORK.Density; infile datalines dsd truncover; input GROUP:$200. LEVEL:32. LEVELC:$200. X:32.; label LEVEL="Level"; datalines4; Density A,1,Level 1,18.168377823 Density A,1,Level 1,18.694045175 Density A,1,Level 1,21.158110883 Density A,1,Level 1,24.443531828 Density A,1,Level 1,27.86036961 Density A,2,Level 2,18.234086242 Density A,2,Level 2,18.759753593 Density A,2,Level 2,21.437371663 Density A,2,Level 2,24.410677618 Density A,2,Level 2,28.090349076 Density A,3,Level 3,19.811088296 Density A,3,Level 3,23.72073922 Density A,3,Level 3,29.32238193 Density A,3,Level 3,30.094455852 Density A,3,Level 3,32.755646817 Density A,4,Level 4,21.190965092 Density A,4,Level 4,24.082135524 Density A,4,Level 4,31.835728953 Density A,4,Level 4,33.281314168 Density A,4,Level 4,40.213552361 Density A,5,Level 5,21.815195072 Density A,5,Level 5,27.564681725 Density A,5,Level 5,31.770020534 Density A,5,Level 5,34.891170431 Density A,5,Level 5,40.509240246 Density A,6,Level 6,25.757700205 Density A,6,Level 6,31.901437372 Density A,6,Level 6,38.636550308 Density A,6,Level 6,43.466119097 Density A,6,Level 6,53.420944559 Density B,1,Level 1,18 Density B,1,Level 1,18 Density B,1,Level 1,18 Density B,1,Level 1,20 Density B,1,Level 1,26 Density B,2,Level 2,18 Density B,2,Level 2,18 Density B,2,Level 2,18 Density B,2,Level 2,26.5 Density B,2,Level 2,32.8 Density B,3,Level 3,18 Density B,3,Level 3,22.5 Density B,3,Level 3,28 Density B,3,Level 3,29.5 Density B,3,Level 3,32.2 Density B,4,Level 4,22 Density B,4,Level 4,26.5 Density B,4,Level 4,29.5 Density B,4,Level 4,31.3 Density B,4,Level 4,33.1 Density B,5,Level 5,25 Density B,5,Level 5,28.5 Density B,5,Level 5,31 Density B,5,Level 5,34 Density B,5,Level 5,35.2 Density B,6,Level 6,27.7 Density B,6,Level 6,31 Density B,6,Level 6,33.5 Density B,6,Level 6,36 Density B,6,Level 6,36.4 Density A,1,Level 1,23.490759754 Density A,1,Level 1,26.349075975 Density A,1,Level 1,60.747433265 Density A,1,Level 1,66.234086242 Density A,1,Level 1,74.05338809 Density A,2,Level 2,51.909650924 Density A,2,Level 2,56.016427105 Density A,2,Level 2,68.238193018 Density A,2,Level 2,75.531827515 Density A,2,Level 2,86.308008214 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,4,Level 4,54.899383984 Density A,4,Level 4,57.708418891 Density A,4,Level 4,68.041067762 Density A,4,Level 4,95.211498973 Density A,4,Level 4,114.85831622 Density A,5,Level 5,70.472279261 Density A,5,Level 5,75.86036961 Density A,5,Level 5,80.854209446 Density A,5,Level 5,98.825462012 Density A,5,Level 5,122.21765914 Density A,6,Level 6,68.468172485 Density A,6,Level 6,83.482546201 Density A,6,Level 6,104.11498973 Density A,6,Level 6,127.17864476 Density A,6,Level 6,184.41067762 Density B,1,Level 1,42 Density B,1,Level 1,47 Density B,1,Level 1,64.5 Density B,1,Level 1,92 Density B,1,Level 1,150.5 Density B,2,Level 2,62.6 Density B,2,Level 2,72.3 Density B,2,Level 2,91 Density B,2,Level 2,114.8 Density B,2,Level 2,166.4 Density B,5,Level 5,63.8 Density B,5,Level 5,78 Density B,5,Level 5,96 Density B,5,Level 5,157 Density B,5,Level 5,188.4 Density B,6,Level 6,68 Density B,6,Level 6,84.8 Density B,6,Level 6,116 Density B,6,Level 6,159 Density B,6,Level 6,227 ;;;; run; %let attrs=thickness=2px; proc sgplot data=WORK.Density noautolegend; styleattrs datacontrastcolors=(gray CXE2B977) datalinepatterns=(1 1); yaxis label="Level"; xaxis min=0 label="Units X"; hbox x / category=levelc whiskerpct=0 nomean nofill group=group lineattrs =(&attrs) medianattrs =(&attrs) whiskerattrs=(&attrs) name= "box"; keylegend "box" / noborder location=outside position=bottom ; run; Here it is the output: But in accordance to Template 'Level 0' to be presented (although 'Level 0' data are absent in the dataset) and scale units to be '12' instead of '50'. ... View more

Hi all, I need to extend keyleged with some text. Can you please help with options? Here it is an example and the proc sgplot code: data WORK.Density; infile datalines dsd truncover; input GROUP:$200. LEVEL:32. LEVELC:$200. X:32.; label LEVEL="Level"; datalines4; Density A,1,Level 1,18.168377823 Density A,1,Level 1,18.694045175 Density A,1,Level 1,21.158110883 Density A,1,Level 1,24.443531828 Density A,1,Level 1,27.86036961 Density A,2,Level 2,18.234086242 Density A,2,Level 2,18.759753593 Density A,2,Level 2,21.437371663 Density A,2,Level 2,24.410677618 Density A,2,Level 2,28.090349076 Density A,3,Level 3,19.811088296 Density A,3,Level 3,23.72073922 Density A,3,Level 3,29.32238193 Density A,3,Level 3,30.094455852 Density A,3,Level 3,32.755646817 Density A,4,Level 4,21.190965092 Density A,4,Level 4,24.082135524 Density A,4,Level 4,31.835728953 Density A,4,Level 4,33.281314168 Density A,4,Level 4,40.213552361 Density A,5,Level 5,21.815195072 Density A,5,Level 5,27.564681725 Density A,5,Level 5,31.770020534 Density A,5,Level 5,34.891170431 Density A,5,Level 5,40.509240246 Density A,6,Level 6,25.757700205 Density A,6,Level 6,31.901437372 Density A,6,Level 6,38.636550308 Density A,6,Level 6,43.466119097 Density A,6,Level 6,53.420944559 Density B,1,Level 1,18 Density B,1,Level 1,18 Density B,1,Level 1,18 Density B,1,Level 1,20 Density B,1,Level 1,26 Density B,2,Level 2,18 Density B,2,Level 2,18 Density B,2,Level 2,18 Density B,2,Level 2,26.5 Density B,2,Level 2,32.8 Density B,3,Level 3,18 Density B,3,Level 3,22.5 Density B,3,Level 3,28 Density B,3,Level 3,29.5 Density B,3,Level 3,32.2 Density B,4,Level 4,22 Density B,4,Level 4,26.5 Density B,4,Level 4,29.5 Density B,4,Level 4,31.3 Density B,4,Level 4,33.1 Density B,5,Level 5,25 Density B,5,Level 5,28.5 Density B,5,Level 5,31 Density B,5,Level 5,34 Density B,5,Level 5,35.2 Density B,6,Level 6,27.7 Density B,6,Level 6,31 Density B,6,Level 6,33.5 Density B,6,Level 6,36 Density B,6,Level 6,36.4 Density A,0,Level 0,77.141683778 Density A,0,Level 0,77.141683778 Density A,0,Level 0,77.141683778 Density A,0,Level 0,77.141683778 Density A,0,Level 0,77.141683778 Density A,1,Level 1,23.490759754 Density A,1,Level 1,26.349075975 Density A,1,Level 1,60.747433265 Density A,1,Level 1,66.234086242 Density A,1,Level 1,74.05338809 Density A,2,Level 2,51.909650924 Density A,2,Level 2,56.016427105 Density A,2,Level 2,68.238193018 Density A,2,Level 2,75.531827515 Density A,2,Level 2,86.308008214 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,3,Level 3,68.238193018 Density A,4,Level 4,54.899383984 Density A,4,Level 4,57.708418891 Density A,4,Level 4,68.041067762 Density A,4,Level 4,95.211498973 Density A,4,Level 4,114.85831622 Density A,5,Level 5,70.472279261 Density A,5,Level 5,75.86036961 Density A,5,Level 5,80.854209446 Density A,5,Level 5,98.825462012 Density A,5,Level 5,122.21765914 Density A,6,Level 6,68.468172485 Density A,6,Level 6,83.482546201 Density A,6,Level 6,104.11498973 Density A,6,Level 6,127.17864476 Density A,6,Level 6,184.41067762 Density B,1,Level 1,42 Density B,1,Level 1,47 Density B,1,Level 1,64.5 Density B,1,Level 1,92 Density B,1,Level 1,150.5 Density B,2,Level 2,62.6 Density B,2,Level 2,72.3 Density B,2,Level 2,91 Density B,2,Level 2,114.8 Density B,2,Level 2,166.4 Density B,5,Level 5,63.8 Density B,5,Level 5,78 Density B,5,Level 5,96 Density B,5,Level 5,157 Density B,5,Level 5,188.4 Density B,6,Level 6,68 Density B,6,Level 6,84.8 Density B,6,Level 6,116 Density B,6,Level 6,159 Density B,6,Level 6,227 ;;;; run; %let attrs=thickness=2px; proc sgplot data=a1 noautolegend; styleattrs datacontrastcolors=(gray CXE2B977) datalinepatterns=(1 1); yaxis label="Level"; xaxis min=0 label="Units X"; hbox x / category=levelc whiskerpct=0 nomean nofill group=group lineattrs =(&attrs) medianattrs =(&attrs) whiskerattrs=(&attrs) name= "box"; keylegend "box" / noborder location=outside position=bottom ; run; Here it is the result: But I need some more text to be added into keylegend (underlined red): I tried to use LEGENDITEM but failed. ... View more

Hi all,   Can you please help with proc boxplot. I have the dataset where there are just calculated percentiles 10, 25, 50, 75, 90: data WORK.MOTOR; infile datalines dsd truncover; input LEVEL:32. MOTOR_TYPE:$14. SUB_TYPE_N:32. P10:32. P25:32. P50:32. P75:32. P90:32.; label LEVEL="Level" MOTOR_TYPE="Motor Type" SUB_TYPE_N="Motor Type(N)" P10="10th Percentile" P25="25th Percentile" P50="50th Percentile" P75="75th Percentile" P90="90th Percentile"; datalines4; 1,M14,1,24.7,31,33.15,36.3,36.34 2,M14,1,14.3,22.5,28,29.15,32.72 3,M14,1,14.3,22.5,28,29.5,32.72 4,M14,1,15,18,18,26.15,32.78 5,M14,1,25.2,28.5,31,34.3,35.2 6,M14,1,16.2,18,18.3,20,26 1,M15,2,53.8,78,96.5,157,188.14 2,M15,2,58.2,84.8,120.2,159,227.9 3,M15,2,52.6,72.33,91.3,114.8,166.4 4,M15,2,52.6,72.32,91.3,114.8,166.4 5,M15,2,42,47,64.5,92.3,150.5 6,M15,2,52.6,72.33,91.3,114.8,166.4 ;;;; I need to generate boxplots just for percentiles (for each motor_type)     Is it possible with proc boxplot and what is the syntax? Thank you! ... View more