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
2 answers

SAS: PROC SGPLOT BY GROUP auto file names

I am plotting some data using BY GROUP option. While I am able to use #byval option to automatically put BY GROUP value in title of each plot, but I want to save each plot individually and want to name it after #byval instead of calling it -…
user877204
  • 97
  • 2
  • 6
1
vote
0 answers

Graph output on a remote server

I am trying to create a series of graphs on a remote server using Base SAS. SAS appears quite happy to produce graphs in a local session (Windows). This appears to be routed through the ODS HTML destination and appears in the Results window…
Iain Paterson
  • 73
  • 4
1
vote
2 answers

How to insert the #byval value in the png filename when using sgplot with a by statement in SAS

I'm making several png image using sgplot and the by statement like this: ods html path="&graphPath" body="index.html" image_dpi=300 style=sciensano1 device=png; ods graphics on / reset noborder imagename="boom" height=10cm width=16cm…
stallingOne
  • 3,633
  • 3
  • 41
  • 63
1
vote
1 answer

SAS regression result output to excel in one sheet

I want to output my SAS regression result into excel. The code is: proc import datafile = 'cmds.csv' out = Work.cmds dbms = CSV; run; ODS TAGSETS.EXCELXP file="dt.xls"; STYLE = STATISTICAL; proc sort data=Work.Cmds out=Work.Cmds; by…
Peter Chen
  • 1,464
  • 3
  • 21
  • 48
1
vote
0 answers

In SAS, how to define table cell padding for tables with template styles using ODS tagsets.sasreport13?

I'm trying to define my template styles and I cannot increase the table cells padding when output is "ODS tagsets.sasreport13". style Table / cellpadding = 50pt /* ONLY EFFECT HTML, PDF, RTF */ ; This code can change…
stallingOne
  • 3,633
  • 3
  • 41
  • 63
1
vote
1 answer

Display an empty table with ODS Tagsets.ExcelXP

I have this code to write a report in an Excel file, using ODS Tagsets.ExcelXP. When the dataset "revenus" is not empty, the report is displayed in the Excel sheet. But, when the dataset "revenus" is empty, the report is not created. How we can…
D. O.
  • 616
  • 1
  • 11
  • 25
1
vote
1 answer

SAS adding white space between the bottom of a graph and the footnote

I hope you can help. I would like to reduce the amount of white space that SAS adds between the bottom of a graph and the footnote. I'm generating graphs into .pdf files that need to meet certain requirements in terms of having a minimum margin…
Kevin
  • 13
  • 4
1
vote
1 answer

SAS ODS Query/Statement print along with it's output

SAS EG Is there any way I can print the query/statement used to get the output, along with the output, using SAS ODS? Suppose, ods pdf file=pdfile; proc sql; select a.* from tab1 a inner join tab2 b on a.something=b.something where <> having…
samkart
  • 6,007
  • 2
  • 14
  • 29
1
vote
1 answer

How can I insert a transparent image using ODS PDF

I'm trying to insert an image that has a transparent background into a PDF document using ODS. When I check the created PDF file, the image is using a white background. My code looks like this: ods escapechar="~"; ods text="~{STYLE…
Robert Penridge
  • 8,424
  • 2
  • 34
  • 55
1
vote
1 answer

SAS - how to stop results tab opening in sas using code.

I have the below code: ods _all_ close; ods csv file="filename.csv" %macro mac_name (st, en=); %do j=1 %to &en.; %let k=%eval(&j.+1); proc freq data=data_name; tables status&j. * status&k. / nocol norow nopercent missing; …
Sunny
  • 35
  • 1
  • 1
  • 8
1
vote
1 answer

SAS-How to NOPRINT in ODS CSV

I have some sas code: ods csv file="filename.csv" %macro mac_name (st, en=); %do j=1 %to &en.; %let k=%eval(&j.+1); proc freq data=data_name; tables status&j. * status&k. / nocol norow nopercent missing; run; …
Sunny
  • 35
  • 1
  • 1
  • 8
1
vote
1 answer

Is it possible to add a class to a table row in SAS Proc Report with a compute statement?

I have an ODS HTML table made with Proc Report where I need to add an HTML class attribute to a table row , and not each individual cell in that row. The reason is that this is required in an stickyRow option in the TableSorter jQuery…
Kim B.
  • 11
  • 4
1
vote
1 answer

Hide 'by' group titles in ODS output

I'm trying to hide the titles for each by group in my ODS output. Code: ods noproctitle; ods html ; proc sort data=sashelp.class out=class; by sex; run; proc freq data=class; by sex; tables sex / list; run; Specifically, the titles I'm…
Robert Penridge
  • 8,424
  • 2
  • 34
  • 55
1
vote
2 answers

Showing markers on a series chart using the GTL

I'm trying to get markers to show up on my chart using the Graphics Template Language. I've tried adding the marker definitions to the style, to the seriesplot statement within a markerattrs= option statement, and also using discreteattrmaps for…
Robert Penridge
  • 8,424
  • 2
  • 34
  • 55
1
vote
1 answer

ODS PDF - Two columns of output interrupted by one column of output on a single page

I'm trying to create an output for a requestor that wants me to take a preexisting report that comes in two columns on a single page and break it apart on that single page into different subsections, which they want indicated by a new title in the…
Kristopher Snyder
  • 13
  • 2
1
2
3 4 5 6