About zhaosi

zhaosi · ‎09-11-2011

Hi: I want to use the macro catalog not named "sasmacr". Firstly, I create a macro. libname test "d:\test"; options sasmstore=test sasautos=(macrfile sasautos) mstored mautosource spool; %macro test /store source; proc print data=sashelp.class; run; %mend test; Secondly, I close the SAS and rename the file "D:\test\sasmacr.sas7bcat" to "D:\test\macr.sas7bcat". And then submit the code as follow. But it's error. libname test "d:\test"; filename macrfile catalog 'test.macr'; options sasmstore=test sasautos=(macrfile sasautos) mstored mautosource spool; %test;

zhaosi · ‎09-01-2011

Hi: Cynthia, I also use the ODS RTF HEADERY and FOOTERY to solve my problem. And maybe there's really no solution in a style template. Thanks.

zhaosi · ‎09-01-2011

Hi, I solved it just now. For example, I want the header margin is 1.5cm and footer margin is 1.75cm. Then using the following code. ods RTF sectiondata='\headery850\footery990';

zhaosi · ‎09-01-2011

Hi, We know that the body style can control the top,bottom,left and right margin in rtf. But how SAS controls the header margin and footer margin in rtf with template? This is an element to control the top,bottom,left and right margin. proc template; define style test; style Body from Document / marginbottom = 2.5cm margintop = 2.5cm marginright = 2.5cm marginleft = 2.5cm; end; run;

zhaosi · ‎08-31-2011

Uh, I think so. Thanks again.

zhaosi · ‎08-31-2011

Andre, Thanks for your element. It's useful. But still cannot solve all my problem. The last line still be dotted. I want it to be inset. Thank you all the same.

zhaosi · ‎08-30-2011

Hi: I want to control the borderstyle in the rtf table. The following figure is my want. But I don't know how to achieve it. Thanks. proc template; define style Test / store = SASUSER.TEMPLAT; parent = styles.printer; style table from table / borderbottomstyle = dotted bordertopstyle = inset borderstyle = dotted width = 100% frame = box; end; run; ods rtf file='D:\temp.rtf' bodytitle style=test; proc print data=sashelp.class(firstobs=1 obs=5) noobs label; run; ods rtf close;

zhaosi · ‎08-30-2011

Thanks! It's a good solution.

zhaosi · ‎08-30-2011

Hi: I hope that the first print process output to RTF is portrait. And the second is landscape. But it doesn't work. ods rtf file='D:\temp.rtf' bodytitle startpage=yes; options orientation=portrait; proc print data=sashelp.class; run; options orientation=landscape; proc print data=sashelp.class; run; ods rtf close;

zhaosi · ‎08-30-2011

Hi: Pretext and posttext can do this. For example: ods rtf file="&path.\one.rtf" style=custom bodytitle; proc report data = test nowd split='#' missing style = [outputwidth = 9in] style(header)=[asis=on just=left protectspecialchars=off] style(column)=[asis=on protectspecialchars=off] style(report)=[pretext='Chemistry Data' posttext='Reference Range used is local laboratory Reference Range{\par}H= high{\par}L= low{\par}A= abnormal' just=left font_weight=light font_size=12pt]; ods rft close;

zhaosi · ‎08-14-2011

Hi: Sorry,I writed the code protext is wrong. It's pretext. And I solved the problem. The code show below: ods rtf file='D:\temp.RTF' bodytitle; ods escapechar='^'; ods rtf text='TEST^{super 2}'; proc report data=sashelp.class nowd style(report)=[pretext="TEST{\super 2}"]; run; ods rtf close;

zhaosi · ‎08-13-2011

Hi: How can I make the superscript work in the protext? Thanks. ods rtf file='D:\temp.RTF' bodytitle; ods escapechar='^'; ods rtf text='TEST^{super 2}'; proc report data=sashelp.class nowd style(report)=[protext="TEST^{super 2}"]; run; ods rtf close;

zhaosi · ‎08-10-2011

Hi: I solved it myselft! Thank you all the same. The command "noprint" is OK and do not use ods select. Actually I still think out another method. Using: ods exclude. But this method seems more trouble. DATA SA; INPUT T@@; IF T<0 THEN CENSOR=1; ELSE CENSOR=0; IF _N_>16 THEN GROUP=2; ELSE GROUP=1; T=ABS(T); CARDS; -2 4 -6 -6 -7.5 8.5 -9 10 -12 13 18 -19 24 26 31 -43 1.5 -2 3.5 6 6.5 -6.5 11 -11 13 17 ; run; title; options nodate nonumber; ods rtf file='D:/temp.rtf' bodytitle; PROC LIFETEST METHOD=PL PLOT=(S) noprint; TIME T*CENSOR(1); STRATA GROUP; RUN; ods rtf close;

zhaosi · ‎08-10-2011

Hi: I'm sorry I forget some code. DATA SA; INPUT T@@; IF T<0 THEN CENSOR=1; ELSE CENSOR=0; IF _N_>16 THEN GROUP=2; ELSE GROUP=1; T=ABS(T); CARDS; -2 4 -6 -6 -7.5 8.5 -9 10 -12 13 18 -19 24 26 31 -43 1.5 -2 3.5 6 6.5 -6.5 11 -11 13 17 ; run; ods select LIFETEST; ods rtf file='D:/temp.rtf' bodytitle; PROC LIFETEST METHOD=PL PLOT=(S); TIME T*CENSOR(1); STRATA GROUP; RUN; ods rtf close;

zhaosi · ‎08-10-2011

Hi: I want to use "ods select LIFETEST" to select the Survival figure and output it to the rtf file. The code as follow. When I submit it the first time. It can work. But when I submit it again. It can't work. I check it in the Results Window. Click the Survival Properties. I found that the first time submit name is LIFETEST. The second is LIFETES1. When I submit the code more times. It will named:LIFETES2,LIFETES3,LIFETES4...and so on. So my question is: Do SAS has a method to make the results attribute name same no matter how many times I submit the code. My English is not good. Thanks! DATA SA; INPUT T@@; IF T<0 THEN CENSOR=1; ELSE CENSOR=0; IF _N_>16 THEN GROUP=2; ELSE GROUP=1; T=ABS(T); CARDS; -2 4 -6 -6 -7.5 8.5 -9 10 -12 13 18 -19 24 26 31 -43 1.5 -2 3.5 6 6.5 -6.5 11 -11 13 17 ; run; ods rtf file='D:/temp.rtf' bodytitle; PROC LIFETEST METHOD=PL PLOT=(S); TIME T*CENSOR(1); STRATA GROUP; RUN; ods rtf close;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

How to use the macro catalog not named "sasmacr"?

How to control the header margin and footer margin in rtf with templat...

How to control the header margin and footer margin in rtf with templat...

How to control the header margin and footer margin in rtf with templat...

Control the borderstyle in the rtf table

Control the borderstyle in the rtf table

Control the borderstyle in the rtf table

Re: Does the portrait and landscape can work in the same rtf?

Does the portrait and landscape can work in the same rtf?

Remove blank line between title and header

Re: Does the portrait and landscape can work in the same rtf?

Remove blank line between title and header

How to use the macro catalog not named "sasmacr"?

How to control the header margin and footer margin in rtf with templat...

How to control the header margin and footer margin in rtf with templat...

How to control the header margin and footer margin in rtf with templat...

Control the borderstyle in the rtf table

Control the borderstyle in the rtf table

Control the borderstyle in the rtf table

Re: Does the portrait and landscape can work in the same rtf?

Does the portrait and landscape can work in the same rtf?

Remove blank line between title and header

The superscript in the protext didn't work

The superscript in the protext didn't work

How to reset the results attribute name

How to reset the results attribute name

How to reset the results attribute name