About new510

new510 · ‎07-21-2021

Hi All, I am trying to add axis table, and the label(stratum) overlaps the first value. I am using the following code for the axis table. layout overlay / walldisplay=none xaxisopts=(display=none OFFSETMIN=0); axistable x=TATRISK value=ATRISK /title="Number At Risk" display=(label) valueattrs=(size=8pt) class=stratum colorgroup=stratum VALUEHALIGN=right; endlayout; Example fig: The label was supposed to be Treat11, and the first value is truncated to 41 instead of 2841. I really appreciate any help you can provide.

new510 · ‎10-30-2020

I found the answer. I need to add the curvelabel= and curvelabelposition= options in the stepplot. stepplot y=eval (1-SURVIVAL) x=TIME / group=STRATUM index=STRATUMNUM name="Survival" rolename=(_tip1=ATRISK _tip2=EVENT) tiplabel=(y="Survival Probability" _tip1="Number at Risk" _tip2="Observed Events") tip=(x y _tip1 _tip2) curvelabel=STRATUM curvelabelposition=min; 🙂

new510 · ‎10-30-2020

Dear All, I am using the Proc lifetest and GTL template to generate a survival graph. How can I modify the GTL survival template and add a curve label to the graph output? I really appreciate any help you can provide. Thank you.

new510 · ‎10-29-2020

Thank you, Dan. for your help. It worked.

new510 · ‎10-29-2020

Dear All, I use the example code to generate a transparent background but still not getting a transparent output. I am using SAS 9.4 M6 version. I really appreciate any help you can provide. proc template; define statgraph barchart; begingraph /OPAQUE=FALSE; entrytitle "Average Mileage by Vehicle Type"; layout overlay / walldisplay=NONE; barchart category=type response=mpg_highway / name="barchart" fillattrs=(color=DarkSeaGreen) stat=mean orient=horizontal dataskin=matte; endlayout; endgraph; end; ods rtf file="Barchart.rtf"; proc sgrender data=sashelp.cars template=barchart; run; ods rtf close;

new510 · ‎11-07-2018

Thank you, ChrisNZ

new510 · ‎11-07-2018

Hi, I have a question regarding retain statement. I have the following dataset: Dataset: ID flag var1 A 1 x1 A 0 x2 B 0 x1 B 0 x2 Result expecting : ID flag var1 want_var2 A 1 x1 x1 A 0 x2 x1 B 0 x1 x1 B 0 x2 x2 I am trying to retain the value of 'var1' if the flag=1 to the next observation of the same id, and keep the same value of var1 if the flag=0. I am using the code as below: data xy; input id $ flag $ z $; datalines; A 1 A1 A 0 A2 B 0 B1 B 0 B2 ; run; proc sort data=xy; by id descending flag; run; data xyz; set xy; by id descending flag; retain xy xy2; if first.id and flag=1 then do; xy=Z; end; else if first.id and flag=0 then do; xy=z; end; run; Thank you in advance.

new510 · ‎05-20-2018

Thank you Daniel.

new510 · ‎05-20-2018

Hi, I am trying to find if a date in a variable falls under Month1,Month2, Month3,Month4....Month6 category using a do loop between startdt and incremented startdate i.e., Startdate+30. By running the below logic, I get a value for the first record as Month2 and a value for rest of the Months too which is not correct. How can i fix this logic? dataset-- start vardt enddt 01Jan2017 11Mar2017 01Jan2018 01Jan2017 02May2017 01Jan2018 01Jan2017 11Apr2017 01Jan2018 data test2; set test1; mindt=startdt; maxdt=enddt; array Months(6); Mnth=30; start=mindt; do i = 1 to Months; mnth=mnth+30; stopdt=maxdt; if startdt <= vardt<=startdt+mnth then Months(i)=1; end; start=start+mnth; drop i; run; Thank you in advance.

new510 · ‎03-29-2017

Hi, This is the sample code i have put it under. I want a line under the 'Total' and above and rest of them without any spaces. data class; set sashelp.class; run; proc means data=class nmiss sum; class sex; var height weight; output out=class2 sum=; run; data class3; length gender $8; set class2; gender=sex; if _type_=0 and sex='' then do; gender='Total'; end; run; proc transpose data=class3 out=trans4; by sex; var _numeric_; id gender; run; ods rtf file='c:\test.rtf' style=x.styles; proc report data=class3 headskip headline nowd split='*'; column _type_ numobs gender height weight ; define numobs/ order order=internal noprint; define gender/'Gender' display order order=internal style={cellwidth=5%}; define height/'Height' display order order=internal style={cellwidth=5%}; define weight/'Weight' display order order=internal style={cellwidth=5%}; run; ods rtf close; Thank you in advance.

new510 · ‎03-29-2017

Hi, I am using a proc report to generate a summary. I would like to insert a blank line above and below for only one variable and rest of them wihout any blank lines. I am not able use the headline for ODS RTF output. The format is some what like the below: Header ---------- Space Overall value space var1 var2 var3 ------------ Thank you in advance.

new510 · ‎12-01-2015

Thank you

new510 · ‎12-01-2015

Hi, Please anyone explain how the below answer is correct. This question is from a sas dump. Given the SAS data set SASDATA.TWO: SASDATA.TWO XY ---- 52 31 56 The following SAS program is submitted: data sasuser.one two sasdata.three; set sasdata two; if x = 5 then output sasuser.one; else output sasdata two; run; What is the result? A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations B. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations C. data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations D. No data sets are output. The DATA step fails execution due to syntax errors. Answer: A

new510 · ‎02-21-2015

Thank you Tom.

new510 · ‎02-21-2015

thank you

Online Status	Offline
Date Last Visited	‎07-23-2021 03:29 PM

Axis table overlapping the first value

Re: modify survival template and adding curve label

modify survival template and adding curve label

Re: Opaque=false in GTL is not working

Opaque=false in GTL is not working

Re: retain statement

retain statement

Re: Do loop

Do loop

Re: How to insert a blank line above and below for only one variable ...

how to get distinct observation from a dataset without SQL