Hi I have to do a boxplot with category "Visits". I want to connect boxes of those visits by mean except one visit "End Of Treatment". So it should be like all visits=boxes are connected by line (mean) and there is one box=EOT that is not. Is it possible ?   proc sgplot data=lb3 dattrmap=attrmap ; vbox result/category=visit connect=mean FILLATTRS=red attrid=hybrid meanattrs=(symbol=circle ) whiskerattrs=(pattern=mediumdash); xaxis label="Timepoint" ; Yaxis values=(0 to 30 by 2) ; run; ... View more

Hi,   I'm a begginer at sas graph programming and I need to create a line graph with xaxis that shows patient visits and yaxis that show lab test results. Visit consits of 1st,8th and 15th visit and for one patient visit=end of treatment (EOT). I need to present this EOT  at the end of xaxis as a dot and not connected to line graph.   my code   proc sgplot data=lb; series x=vis y=result / group=usubjid grouplc=armcd break transparency=0.7 lineattrs=(pattern=solid); xaxis label="Timepoint" ; Yaxis values=(0 to 30 by 2) label="arm"; keylegend / type=linecolor title=""; run;     ... View more

hi,   i want to eliminate w.d note from these calculations data test1; calc=77; call symputx('calc',calc); run; data test; input numb; datalines; 77 58 ; data test2; set test; total=numb/&calc*100; total2=PUT (total,4.1); run;   i've tried to round total data test2; set test; total=round(numb/&calc*100,4.1); total2=PUT (total,4.1); run;   and it doesnt print me w.d but... i have wrong results, sas shows me that (77/77*100,4.1)=98.4 instead of 100. I don't understand this.   thank you for your help ... View more

hi, i want to change this table that will make one variable with aebodsys as main category and aedecod as subcategories. like that VAR Cardiac disorder atrial flutter palpitations Tachycardia Cardiac failrue   Psychiatric disorders Delirium   Gastrointestinal disorders Constipation   data AE; input USUBJID $ 1-3 AEBODSYS $ 5-30 AEDECOD $ 32-49 ; datalines; 101 Cardiac disorders Atrial flutter 101 Gastrointestinal disorders Constipation 102 Cardiac disorders Cardiac failure 102 Psychiatric disorders Delirium 103 Cardiac disorders Palpitations 103 Cardiac disorders Palpitations 103 Cardiac disorders Tachycardia run;   thank you for your help ... View more

hi, i want allign my data to get proper proc report output data have so every row in this case shoud be alligned to 217/336 (64.6%) thank you for your help   ... View more

Hi I have two variables with descriptive statistics and I need to calculate the difference between them _name_ var1 var2 var_want mean(sd) 76.4(11.39) 77.2(8.63)   min,max 40.0,113.0 50.0,106.0     i've tried this,example   if _name_="min,max" then var_want=substr(var,1,2)-substr(var2,1,2)||","||substr(var,6,3)-substr(var2,6,3) but it doesn't work cause 40-50=-10 and sas cannot convert it to char (invalid numeric data)   is there a simple way to calculate the difference between var1 and var2 ?   ... View more