I am trying to create a graph like below using scatter and series plot. I am not able to place blocks like below. This graph is temperature display over time which is from vital signs and block is from AE table where each block display AE start and end day.       I tried with highlowplot, but I am not getting what I expected . Please help me to find solution for this complicated graph     ... View more

I am trying to generate boxplot using proc sgrender. Please see the below graph I generated. Since there are outliers in my data, I have to display in the graph as well. but there is too much space between 5000 and 15000. My question is how can i shrink the space between 5000 and 15000? I would like to display 5000 close to 15000. here is the option I gave in Yaxis.  yaxisopts=( label="xxx" type=linear linearopts=(tickvaluelist=(0 5000 15000)));     ... View more

I am using macro to zip all files in a folder. When i open the zip file, date of modified becomes the date I ran the macro. When I create zip files manually, date of modified preserves original files date. Here is the code I am using. How can i preserve the original modified date in zip file?   ods package(newzip) open nopf; %do j = 1 %to &cnt; ods package(newzip) add file="&dir.&&name&j" mimetype="application/x-compress"; ods package(newzip) publish archive properties(archive_name="&zipnme..zip" archive_path="&ziploc"); %end; ods package(newzip) close; ... View more

Is there any SAS procedure to convert all RTF files to PDF?   ... View more

In the scenario where in my SAS dataset have series of same consecutive(count > 2) column values on the same row, I want to keep first and the last column values and replace with blank the ones between first and last. . Is there a way to do this using ARRAYS?   example   id var1 var2 var3 var4 var5 var6 xx 0     1       1      1      1      0   Desired Output   id var1 var2 var3 var4 var5 var6 xx 0     1                        1      0       ... View more

When I try to plot using series plot in GTL, I am getting warnings because of missing data. Is there any options that I can use to ignore missing data instead of showing warnings in Log?. The code I used is seriesplot x = xvar y = yvar/name="ser1"; seriesplot x=xvar1 y= yvar1/yaxis = y2 name = "ser2". some of the yvar1 is missing. warnings:  y=yavr1 is invalid Please let me know If there is any options to ignore missing value. ... View more

I am trying to barchart using proc sgrender. My dataset has variable called ID with 2 different values for time ,group and reasons. To plot data points correctly I formatted ID in such a way that it has values _n_ according to the data. ID  TIME  group  id_ reasons  length  stat  statvar 1    5        A         1     xxx         6         35       age 1    6        B         2     yyy         7         asian   ethinic                                                             country  xxx                                                              xxx        yyy I calculated length variable from time so that that graph plot value just above the bar . length = time+1; I want to create bar chart in such a way that group A and B gets different colors for the corresponding ID and there shouldn't be any space between bars.  The code I used is proc template; define statgraph barcolors; dynamic xvar yvar; begingraph; discreattrmaps name='catcolors'/ignorecase=true VALUE 'A'/FILLATTRS(COLOR=BLUE); VALUE 'B'/FILLATTRS(COLOR=RED); enddiscretattrmaps; discreattrmaps attrvars=group var=group attrmap='catcolors'; layout overlay/ yaxisopts----- xaxisopt------------ barchartparam x = id_ y = time/primary=yes  groups = group groupdisplay = cluster name='colors' scatterplot x =id_ y = length/markerattrs=(size=5 weight=bold)group=reasons; The problem I have is since id_ has different value for same ID , it create a space between bars. If I use ID instead of id_ in scatterplot then all the reasons goes to first bar not to corresponding bar. How can I tell SAS not to put space between bars for each ID? I am also trying to put a table under graph. since there are 2 bars for each ID, graph is having trouble to put values under each ID in the table. Is there any solution for this too? boxplot x= id_  y = stat/class=varstat; ... View more

I want to create a plot in GTL. The code I used is proc template; ---- ---- --- seriesplot x = var1 y=var1/group = grp1  name = "series" discretelegand "series" The problem I have is My group variable values occurs twice but with different values for var1 in y axis, so when I plot the graph the duplicate groups gets  same color even though they plotted separately. Is there any way to specify in template to consider those duplicates as independent and gets 2 different color for lines? ... View more