I have a issue where i want to have a group vbar with only group which has nonmissing data. data WORK.FINAL; infile datalines dsd truncover; input aetoxgr:$12. pct_toxg:PERCENT8. new_subj:$29. EXDOSE:32.; format pct_toxg PERCENT8.; datalines4; Grmdr1,8%,C1D1(n=12),0.3 Grmdr1,33%,C1D1(n=12),1 Grmdr2,8%,C1D1(n=12),1 Grmdr1,10%,C1D8(n=10),3 Grmdr1,10%,C1D8(n=10),10 Grmdr2,10%,C1D8(n=10),3 Grmdr2,20%,C1D8(n=10),10 Grmdr3,10%,C1D8(n=10),10 Grmdr1,13%,C1D15(n=8),30 Grmdr2,13%,C1D15(n=8),30 Grmdr3,13%,C1D15(n=8),30 Grmdr2,25%,C2D1(n=4),10 Grmdr1,50%,C2D8(n=4),10 ;;;; i want to remove nonmissing legends as highlighted in attachedment with blue marker and also get percentages as shown in second sample figure attached, not sure how to do, Can anyone please help. I used the below code proc template; define statgraph final2; begingraph / datacolors=(lightblue lightgreen orange red cyan); layout datalattice columnvar=new_subj/ rowaxisopts=( Label=' ' offsetmin=0) columnaxisopts=(offsetmin=0.3 offsetmax=0.3 display=(ticks tickvalues)) headerlabeldisplay=value headeropaque=false columnheaders=bottom; layout prototype /walldisplay=none; BarChartParm X=exdose Y=pct_toxg / primary=true Group=aetoxgr NAME="Status" groupdisplay=stack barwidth=0.9; Scatterplot x=exdose y=yScatter / group=aetoxgr markercharacter=pct_toxg labelstrip=true markercharacterattrs=(size=16 weight=bold color=white); endlayout; endlayout; layout globallegend; DiscreteLegend "Status"/ title="Toxicity Grade"; endlayout; endgraph; end; run; ods listing gpath='output\'; ods graphics / imagename="test" imagefmt=png; proc sgrender data=final2 template=final2; run; ods graphics off;     ... View more

Hi, I want to get cumulative sum between 2 groups. I have data something like this   data WORK.NSUBJ1; infile datalines dsd truncover; input cnt_subj:32. trt:$13. EOSE:32.; datalines4; 1,X1D1,0.3 11,X1D1,1 1,X1D15,3 3,X1D15,10 4,X1D15,30 5,X1D8,3 5,X1D8,10 ;;;; and i want sum of cnt_subj across each trt and eose. I did something like this data nsubj2; set nsubj1; by trt exose; if First.trt then cnt=0; cnt + cnt_subj; if Last.trt; keep trt exose cnt; run; But i will miss first observations of eose for example 0.3 will miss I want something like below which has sum per rt and xde and populate for across for these 2 groups i.e cnt should be added up within trt and populated group wise like example trt=X1D1 cnt_subj should be 1+11=12 and i want 12 in trtr=X1D1 cnt =12 should be for EOSE=0.3 and 1 as below. my code removes the first record cnt_subj trt EOSE cnt 1 X1D1 0,3 12 11 X1D1 1 12 1 X1D15 3 8 3 X1D15 10 8 4 X1D15 30 8 5 X1D8 3 10 5 X1D8 10 10                   ... View more

Can you help me on where to find sas program to convert dataset to sas code to  post as example  in community   ... View more

I want to concatente 3 variables and if i have missing varaible at end than want to replace it with "Y". Can anyone help me how to do it? ... View more

I have data something which has negative values and 0 with decimals and i want 2 decimals for all non zero values.   I tried format=6.2 in proc report but it also makes 0 as 0.00. is there any way to skip 0 while using it in define in proc report? ... View more

I am doing the below step to get last ID but if the group has more than one number with last than i want multiple i.e if for ID the group has 3 as last record adn if i have multiple 3's than i want them all. CUrrently i dont get by the below step, Can anyone help me   Data have; infile datalines dlm=',' dsd missover; input ID ON_OFF :$8. CATEGORY :$8. Group:8.; datalines; 1,OFF,P,1 1,ON,G,2 2,OFF,C,1 2,OFF,C,1 3,OFF,O,1 3,OFF,R,2 4,OFF,C,2 4,ON,G,2 5,OFF,S,1 5,OFF,R,2 5,ON,G,2 6,ON,S,1 6,ON,S,3 6,ON,R,3 ; run; data want; set have; by ID group notsorted; if last.ID; run; ... View more

I have an issue where a variable has  var1 1-Text out of range 11-minimum-score of text   and  var2 MES1102 MES1129   I want to replace after "-" from var1 and get text in var2 in that place. something like below.   var3 MES1102-Text out of range MES1129-minimum-score of text   any help on how to do it in datastep ... View more

I have data like Item value LYUI0105 10 LYUI0114 20 LYUI0123 22 LYUI0132 22 LYUI0141 12 LYUI0150 12 LYUI0158 35 LYUI0165 21 LYUI0170 22 LYUI0175 112 LYUI0201 21 LYUI0207 11 and i want a new row with total of  LYUI0105 LYUI0114 LYUI0123 LYUI0132 LYUI0141 LYUI0150 like new_score Item value LYUI0105 10 LYUI0114 20 LYUI0123 22 LYUI0132 22 LYUI0141 12 LYUI0150 12 LYUI0158 35 LYUI0165 21 LYUI0170 22 LYUI0175 112 LYUI0201 21 LYUI0207 11 New_score 98     Can anyone help me on it   ... View more