Stack Overflow
Stack Overflow

Questions tagged [sas-ods]

SAS ODS is the Output Delivery System for the SAS language, the method by which various formats of output (PDF, HTML, RTF, etc.) are usually produced in SAS.

In , the Output Delivery System is the method by which you control the output from procedures. It can allow you to produce PDFs, RTFs, HTML files, Excel files, LaTeX documents, and many other output destinations. It also is used as a method of directing output from procedures to datasets.

Resources

86 questions
1
vote
1 answer

ODS Excel Macro Overwritten SAS

Here is the code %macro ODS1 (Type=, var=, data=); ODS listing close; ODS tagsets.excelXP file = "H:\Liv_Divide\Dispersion1.xml"; proc format; value myfmt .='#N/A' other = [11.2]; run; ODS Tagsets.ExcelXP options…
mustafghan
  • 169
  • 4
  • 15
1
vote
1 answer

Using "ods html text=" to inject html into an output document for a batch SAS program

I am currently trying to setup an automated SAS report. I have written the following test batch program for the automation piece that will be scheduled in Windows Task Scheduler: "C:\SAS Location\sas.exe" -sysin "C:\SAS program…
skijunkie
  • 151
  • 6
1
vote
1 answer

Drawing "boxes" on my PDF output

I am working on a corporate-level summary report for my employer. Because this is a fairly high-level report, I'm trying to "pretty" it up a bit (I think the standard SAS output is exceptionally ugly). I've managed to include graphics using ODS…
JDB
  • 25,172
  • 5
  • 72
  • 123
1
vote
1 answer

SAS - Multiple Proc Reports on one excel worksheet

Is it possible to use proc report to stack multiple tables on one excel worksheet? For example, below is a simplfied version of my code where I'd like to display table1 using the first proc report, then skip a row and display table2 immediately…
user2941280
  • 285
  • 3
  • 9
  • 16
1
vote
1 answer

sas page footnote in ods pdf

I'd like to have a page number in the format of "X OF Y PAGES" at the right bottom of each page. I tried the following code for a pdf result but it's just displaying "Page *{thispage} of &num" literally. Can anyone help with this? Thanks! * create…
user2146697
  • 33
  • 1
  • 6
1
vote
1 answer

Using namedpipes to transfer ods output and datasets

I'm trying to figure out how to use SAS namedpipes to exchange data in SAS processes. Here is a simple example: Server FILENAME stdout namepipe '\\.\pipe\Sas\PipeOut' server eofconnect retry=15 block; FILENAME DIRLIST pipe 'dir "C:\atemp"'; data…
Dweeberly
  • 4,668
  • 2
  • 22
  • 41
1
vote
1 answer

SAS ods output: axis labels too condensed

I am trying to output some plots (of cumulative incidence functions made by using proc gplot) with SAS 9.2 but somehow the letters of the axis labels keep to stay condensed, sort of covering each other. I would attach a picture with the problem but…
Rieux
  • 103
  • 1
  • 1
  • 5
1
vote
1 answer

SAS ODS Output: Get Histogram (only!) in PDF

I'm running the following code to output a histogram of a certain variable: ods results off; ods listing close; ods pdf file="&folder/temp.pdf"; title ; * Histogram of betCount; proc univariate data=want; var…
user2146441
  • 220
  • 1
  • 19
  • 43
1
vote
1 answer

SAS: ODS LATEX tagsets omits LINE ENDING MARK

I'm running a 'proc means' command to print out summary stats on two variables below: var1 and var2. I'm creating latex on-the-fly and picking the latex up in a larger document with the appropriate headers for the table and all that. It works…
user2146441
  • 220
  • 1
  • 19
  • 43
1
vote
1 answer

SAS: Custom ODS LATEX tagset

I'm trying to customize the output from SAS for the tagsets.latex, tagsets.simpleLatex and tagsets.tablesOnlyLatex tagsets. I nearly have what I want: only the data rows, no headers, no other tags at all. This is the output I'm getting:…
user2146441
  • 220
  • 1
  • 19
  • 43
1
vote
1 answer

SAS Conditional row highlighting with ODS and Proc Print

I want to turn the entire row red for people whose names begin with 'J'. Is this possible using proc print? ods html file=odsout style=htmlblue ; proc print data=sashelp.class noobs label; var name age; run; ods html close;
Robert Penridge
  • 8,424
  • 2
  • 34
  • 55
0
votes
1 answer

How to color proc report variable label with multiple colors in one cell using define statement?

I am trying to output SAS DS with multiple columns into excel and want to show two columns' name/label with two different colors. Please see the expected example output below: So I need both black and red colors in one cell label. I have done this…
Rhythm
  • 680
  • 5
  • 9
0
votes
1 answer

link color clashes with background using MAGNIFY ODS style

I recently switched from the HTML destination to HTML5 so I would get SVG graphics in a job, and everything looks lovely, except my table-of-contents links, which now have bad contrast against the dark background produced by the MAGNIFY style. Dig…
Roy Pardee
  • 196
  • 2
  • 12
0
votes
0 answers

Order ODS Output by Variable Not in Graph

I am using ODS to output an rtf file with graphs for each warehouse, using the warehouse ID as the by value. I need to organize the graphs in ascending order of rejected products per 100 produced. I was reordering the graphs manually in Word, but…
Druscilla
  • 3
  • 2
0
votes
2 answers

SAS ODS RTF - Best option to embed Title/Footnote into Table

Looking for advice to embed title/footnote as part of the table (see below - making it easier to copy & paste into the different document) Options explored so far 1) PROC REPORT - COMPUTE PAGE BEFORE (COMPUTE doesn't support justification option…
R007
  • 101
  • 1
  • 13
1 2 3
4
5 6