Thanks I have contacted tech support. ... View more

I think you need to post some data for this, not sure I’m following what is going on here. ... View more

ods graphics on; proc lifetest data=sashelp.BMT plots=survival(strata=individual); time T * Status(0); strata Group; run; Have you tried the STRATA=INDIVIDUAL option? ... View more

I need plot two groups on X axis say Female and Male and Y axis say age for different countries.   If there are 10 Male and 15 Female subjects, what I need is on the plot 10 dots for Male and 15 dots for Female on the BoxPlot. Also, in addition, color code dot with age=10 with a different color.   An example is attached where say blue is female and orange is male and a set of two boxes belong to each country   Thanks for your help.     ... View more

Check your data and do the conversions manually using PUT/INPUT. You ultimately have few options with Excel types:   1. Convert to CSV and have full control 2. Import as XLS or XLSX and clean up after the fact.    @sfo wrote: Yea I do have. Could you let me know the solution to fix this issue then ?     ... View more

@ballardw wrote: If Randomness is not an issue this is another way: Using a SAS set you should have as a starting point: proc sort data=sashelp.class out=work.class; by sex; run; data work.want; set work.class; by sex; group= mod(_n_,4)+1; run; Which will evenly distribute the group identifier within the BY variable. And if randomness is an issue, then you can assign random numbers to each observation and use those to split the data into 4 groups. ... View more

Is there a way I can also add Median and Quartile?   When I output Proc Means output to a dataset only N Min Max MEAN and STD comes out.   In my transpose I also want median and the quartile information.   Thanks! ... View more

Below is the graphic and symbol options, hope this will help   goptions YMAX=1500 in vsize=1000 in hsize=1000 in;   /*vertical axis option*/ axis3 label = (a=90 f=arial h=3 " Subject") length = 100 style = 1 width = 5 color = black offset = (0 cm, 0 cm) order = 0 to %eval(&NSub+1) major = (h=0.75 w=6) minor=(h=0.5 n=6) value = (%do i=1 %to &NSub; tick=1 h=1 ' ' tick=%eval(&i+1) h=1 "&&N&i" /* N is the maco variable that contains the subject number */ %end; tick=%eval(&NSub+1) h=1 ' ');   /*Symbol option*/ goptions display hby=2 fby=arial; goptions colors=();   symbol1 w=0.5 h=0.5 v=dot c=black ; symbol2 w=0.5 h=0.5 v=dot c=red ; symbol3 w=0.5 h=0.5 v=dot c=blue ; symbol4 w=0.5 h=0.5 v=dot c=green ; ..... ... View more