Stack Overflow
Stack Overflow

Questions tagged [ods]

ODS, OpenDocument Spreadsheet, is an extension of spreadsheet files in Open Document Format for Office Applications (ODF).

195 questions
1
vote
1 answer

How to read xlsx or ods columns as numpy arrays in python

Right now I am using this, but it seems to be very slow and also prints the columns as lists. Additionally, here I am manually adding columns to my list. Is there a more efficient way using numpy and reading the columns as arrays? If not this, I was…
PolkaDot
  • 520
  • 1
  • 7
  • 18
1
vote
1 answer

How to get any type of content of specific .ODS cells in XSLT

I am trying to transform an .ods file (content.xml file from the zip) with XSLT in order to produce a desired .xml file. XSLT uses "fixed" positions of the elements to get the content, but in my .ods file I have many blank fields and I don't know…
Sojimanatsu
  • 619
  • 11
  • 28
1
vote
1 answer

SAS ODS Excel to produce a excel sheet with three tables side by side

I am trying to prepare a report in Excel using ODS Excel in SAS. The report contains two sheets with three tables place side by side. I used Panelcol option but it is not available in ODS Excel. Also, the Start_at= option does not seem to be…
shankar
  • 63
  • 1
  • 8
1
vote
1 answer

Insert image into PDF SAS

I am properly confused, I am trying to get my head around ODS PDF. I don't need it to look pretty, I just need to insert an image of a statistical formula. ODS PDF FILE="&exceldir\README.pdf"; TITLE "DATA INDEX FOR &STUDY"; ODS PDF TEXT = "blah…
Jason Rogers
  • 667
  • 1
  • 6
  • 19
1
vote
1 answer

R write_ods function send back status 127

I try to write ods file using R, with the readODS package. It is working fine on a computer, on another, with the same code, I get : Warning message: running command '"zip" -r9X "test.ods" "content.xml" "META-INF" "meta.xml" "mimetype" "styles.xml"…
Malta
  • 1,883
  • 3
  • 17
  • 30
1
vote
1 answer

SAS ODS Documentation Syntax Error

I have many questions regarding the ODS system and am trying to educate myself. However, I am unable to do so as the SAS documentation example generates an error. The documentation in question is Controlling Where Your Output Is Stored. The very…
Lorem Ipsum
  • 4,020
  • 4
  • 41
  • 67
1
vote
1 answer

SAS ODS Sandwich in PROC ARIMA with BY statement generate strange results

I'm trying to export a bunch of stationarity tests to both HTML and Excel. With PROC ARIMA I'm getting strange behaviour when I try to wrap each part in an "ODS Sandwich". It appears this is due to using the BY var command in PROC ARIMA. When BY…
Tony Beans
  • 175
  • 1
  • 11
1
vote
1 answer

how to insert html text in SAS email body

Hi Could you all please help me in inserting HTML Text with font options in SAS Email. I tried the below code but without proc report in body the output is blank. enter code here /*options errorabend;*/ %MACRO mail_send1(); filename mymail email…
santosh315345
  • 23
  • 1
  • 2
  • 5
1
vote
1 answer

How to embed external pics and incorporate header in ODS pdf -SAS

The idea is to create an output pdf file with just header and footer and embed a picture file. I have used ods pdf and specified ods overlay, region to get header , pagination and footer.proc print was used to embed picture and a dummy dataset with…
Pragathi
  • 33
  • 2
1
vote
0 answers

sas ods.rtf output headline w/in macro

i´m having trouble getting a headline for a macro since for some reason the title produced by the gplot routine overwrites the predefined headline (title1) what am i missing? data one; input state $2. sales @@; datalines; VA 5200 SC 9800 NC …
fleischfressendepflanze
  • 13
  • 5
1
vote
1 answer

How do I output a SAS data set looking exactly like my result in PROC TABULATE?

So I am a complete beginner in SAS and it seems that I am missing something that is very obvious since I cannot figure this out. Hopefully someone could help me on this. I have disorganized data in a .csv file with which I need to compute some…
Laksa
  • 11
  • 2
1
vote
1 answer

Proc Report Bookmark Titles in ODS PDF

I am looking to make each proc report that is within the ODS PDF have its own designated title on the third level of the PDF bookmarks. How can I achieve this concept? For example, in the image below, I'd like to change the "Table 1" entry to some…
Tinkinc
  • 449
  • 2
  • 8
  • 21
1
vote
0 answers

Formatting numbers in Proc Tabulate for ODS Excel

I have a simple PROC TABULATE that is working fine and produces output in Excel by ODS. However, all my numbers are shown in a kind of 'general' format without points or decimals between thousands. I tried formats such as COMMA12.2 COMMAX12.2 but…
Wim Weyers
  • 11
  • 2
1
vote
0 answers

OpenDocument spreadsheet corrupt in Microsoft Excel

I am using a gem to write to an OpenDocument spreadsheet (RSpreadsheet). Once the data is written I let the user download it. The spreadsheet works fine in OpenOffice Calc and Numbers for Mac. However, when I try to open the spreadsheet in Microsoft…
Cjmarkham
  • 9,484
  • 5
  • 48
  • 81
1
vote
1 answer

Plotting with sgplot and ODS on SAS

Here's my dataset Column 1: Lipid level Column 2: Age Column 3: Fat content category Column 4: Gender (1=male) 0.73 1 1 1 0.67 1 2 1 0.15 1 3 1 0.86 2 1 1 0.67 2 2 1 …
oxnot
  • 55
  • 5
1 2 3
…
12 13