BookmarkSubscribeRSS Feed
Linlin
Lapis Lazuli | Level 10

Hi All,

 

How to write sas output into word file?

 

Thank you very much for your help!

 

data have;
input group hypertension;
cards;
1 1
1 0
1 .
1 1
1 0
1 .
1 1
1 0
1 .
2 1
2 0
2 .
2 1
2 0
2 .
2 1
2 0
2 .
;
proc print;run;

 

 

group1

group2

group3

group4

Total

Smoking Status

 

 

 

 

 

 Never

270/603(45%)

231/457(51%)

235/603(39%)

202/457(44%)

724/2120(34%)

 Past

275/603(45%)

201/457(44%)

309/603(51%)

225/457(49%)

1018/2120(48%)

 Current

47/603(8%)

19/457(4%)

35/603(6%)

       17/457(4%)

118/2120(6%)

 Missing

11/603(2%)

6/457(1%)

24/603(4%)

13/457(3%)

268/2120(12%)

 

 

 

 

 

 

Physical Activity

 

 

 

 

 

 Yes

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 No

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 Missing

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 

 

 

 

 

 

Hypertension

 

 

 

 

 

 Yes

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 No

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 Missing

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

5 REPLIES 5
VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

what are you wanting to put into the text file?

How did you define the rows.  Can you provide more detail?

Linlin
Lapis Lazuli | Level 10

Hi VDD,

 

Thank you for your quick reply! when I run the code below I would like the outcome of proc freq going to the word file directly, so I don't have to type in the numbers.

 

proc freq data=have;
tables hypertension/missing;
where group=1;
run;

                            group=1      group=2

Hypertension

 

 

 

 

 

 Yes

3/9 (33%)

3/9 (33%)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 No

3/9 (33%)

3/9 (33%)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 Missing

3/9 (33%)

3/9 (33%)

xx/xx (xx)

xx/xx (xx)

xx/xx (xx)

 

 

 

 

 

 

 

 

novinosrin
Tourmaline | Level 20

This worked for me, but i don't know if this is what you want

 

ods rtf file='C:\Users\nsriniv2\Documents\Doc1';
proc freq data=sashelp.class;
tables sex/missing;
run;
ods rtf close;
Cynthia_sas
SAS Super FREQ

Hi: usually with ODS RTF, you use a file extension of RTF:
ods rtf FILE='c:\myreports\doc1.rtf' style=journal;

When you are using ODS RTF, you are NOT creating a .doc or .docx file. You are creating an RTF (Rich Text Format) file that many word processors know how to open and render.

Cynthia

novinosrin
Tourmaline | Level 20

@Cynthia_sas  Oh yes indeed. Thank you! 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1957 views
  • 0 likes
  • 4 in conversation