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
9
votes
5 answers

Saving results from SAS proc freq with multiple tables

I'm a beginner in SAS and I have the following problem. I need to calculate counts and percents of several variables (A B C) from one dataset and save the results to another dataset. my code is: proc freq data=mydata; tables A B C / out=data_out ;…
Natalia
  • 101
  • 1
  • 1
  • 2
7
votes
1 answer

SAS: How do I use ODS layout to put 8 graphs on 2 PDF pages?

I am using SAS ODS to create PDF documents. The code below works to put 4 graphs on 1 page. But if I try to put 8 graphs on 2 pages, all I get is 4 graphs on 1 page. I tried copying the part between the lines of asterixes and pasting it again above…
BB1
  • 95
  • 2
  • 4
5
votes
1 answer

Including syntax in SAS ODS pdf file

Is it possible to include submitted syntax or even output of log file when ODS into a PDF using SAS? For instance, give this simple code: ods pdf file = "c:\temp\myPDF.pdf"; proc reg data = mydata; model y = x; run; ods pdf close; I can get the…
Penguin_Knight
  • 1,289
  • 8
  • 13
3
votes
1 answer

Update Excel output using ODS?

I am running a macro program to analyze a data set. In the end of my macro, i used a ODS statement and a proc Report to export my results. What i want is: For each time i run the macro program with a new data set, the results will be updated in a…
buiquanghai
  • 81
  • 1
  • 6
3
votes
2 answers

SAS using CSSSTYLE and Email functionality together

I am not able to apply my CSS styles to an email which I am sending it as a html format. If I save the ODS output to a local file, I am able to apply my CSS styles. Could someone help me on how to pass the CSS styles in an email step? Here is the…
Naga Vemprala
  • 718
  • 3
  • 16
  • 38
3
votes
3 answers

Turn off automatic graph saving in SAS 9.4

In SAS 9.3, I could use ODS HTML GPATH to specify the path where I wanted graphs to be saved (if I so desired). In 9.4, by default (i.e. every time I open SAS) whenever I make a graph (with PROC SGPLOT, e.g.), it automatically saves the plot to the…
Meg
  • 696
  • 1
  • 7
  • 20
3
votes
2 answers

SAS ODS PDF Insert Link

I am trying to do something that I think would be simple. I want to insert a link to an xls workbook into a title on a chart generated in GPLOT and output through ODS as a PDF. I have tried: ods escapechar="^"; TITLE2…
2
votes
1 answer

ods excel and proc template

I am running into an error when trying to use ods excel after defining a style named excel via ods template. I was wondering if anyone could explain why this is happening as I thought ods styles and ods destinations were two completely separate…
Robert Penridge
  • 8,424
  • 2
  • 34
  • 55
2
votes
1 answer

How can I create SAS html files with names corresponding to a dataset field

I'm trying to create a file for each record in my SAS dataset. I have been able to succesfully do this using SAS ODS output by using the "newfile=page" option and then simply running a proc report on the dataset. The problem I'm having is that…
rascale
  • 79
  • 1
  • 6
2
votes
1 answer

Is it possible to import a PNG file into SAS to include in RTF output?

I have PNG files that were created outside of SAS that I would like to include in an RTF file that I will output from SAS using ODS. Is it possible to use SAS to do this? My internet searches are turning up a lot of irrelevant results.
Sam Dickson
  • 5,082
  • 1
  • 27
  • 45
2
votes
1 answer

SAS ods html generates additional html code

I use ods html to output HTML code from SAS to body=_webout. SAS version is 9.4. I would like to output a HTML table, but SAS generates automatically an additional table around the output of each ods html statement. For example this is my SAS…
zuluk
  • 1,557
  • 8
  • 29
  • 49
2
votes
1 answer

SAS-Dynamically Writing Bar Charts to Excel workbook in SAS Macro

I am trying to dynamically generate and export bar charts to and an excel workbook. My Macro pulls certain distinct Identifier codes and creates two summary tables (prov_&x table and the prov_revcd_&x) and populates to single excel sheet, for each…
Brad
  • 85
  • 12
2
votes
1 answer

How to select output table from results in SAS

I have the problem that while I want to conditionally select output table from Results Window. In the following data set, there are three tables after running the program: 1. Variable Information 2. Simple statistics 3. Pearson correlation The first…
Elif Y
  • 251
  • 1
  • 4
  • 21
2
votes
1 answer

Improper alignment and Height issue with inline formatting

ods escapechar='^'; %let bmi=^S={font_weight=bold} Body Mass Index(Kg/m^{super 2}); When i am trying to create pdf o/p my font is changing in output(Superscript appears in different height) Is there any solution for the above issue
user3893852
  • 95
  • 1
  • 8
2
votes
2 answers

sas ods columns - make "journal style" document

I am trying to get some datasets printed to a PDF. Can anyone tell me how I can fit the last 4 proc printstatements into a 2 x 2 on a single page, while leaving the first one on it's own page (as it is now)? title; options nodate nonumber nocenter…
user1624577
  • 547
  • 2
  • 6
  • 15
1
2 3 4 5 6