ODS, OpenDocument Spreadsheet, is an extension of spreadsheet files in Open Document Format for Office Applications (ODF).
Questions tagged [ods]
195 questions
1
vote
2 answers
I changed columns names, but SAS PROC REPORT still uses the old names
Using PROC SQL, I changes column names from English to Hebrew.
When I use such tables via PROC REPORT, SAS uses the English columns names, even though the BY and DEFINE statements use the new Hebrew named column
PROC REPORT DATA= work.sharon ;
BY…
Eyal Marom
- 281
- 4
- 18
1
vote
1 answer
How to get a sheet name in an ODS file?
I saw that there are two libraries I can use: pyexcel_ods3 and pyexcel_ods.
I tried to use
pyexcel_ods.Sheet("file.ods")
and
pyexcel_ods.get_book(file_name="file.ods")
but I got these errors:
AttributeError: module 'pyexcel_ods' has no…
leob
- 23
- 4
1
vote
1 answer
Encrypt a file inside an ODS archive
I'm trying to reproduce the LibreOffice encryption of a file inside an ODS (open document spreadsheet) archive. See http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part3.html#__RefHeading__752811_826425813 for technical…
jferard
- 7,835
- 2
- 22
- 35
1
vote
0 answers
Issue with exporting sas output by ods to latex (overleaf
im having some difficulties with running some sas output in my .tex file
\documentclass[10pt]{article}
% Generated by SAS
% http://www.sas.com
\usepackage{sas}
% Set page layout
\geometry{top=1in, left=1in, right=1in,…
Forecaster
- 21
- 3
1
vote
2 answers
SAS: ODS EXCEL (how to name different sheets)
I want to export a table generated by PROC TABULATE. My code goes like this:
ODS EXCEL FILE="myFile.xlsx" (options sheet_name="CRIME TYPE");
PROC TABULATE DATA=myData;
TITLE 'myTitle';
BY crime_type;
CLASS year;
CLASS nation /…
D. Studer
- 1,711
- 1
- 16
- 35
1
vote
0 answers
Does SAS ODS support Excel Array Formulas (CSE-Formulas)?
Does SAS ODS support Excel ArrayFormulas (CSE-Formulas)? If so, what is the correct syntax?
Is there a way to write Excel ArrayFormulas in ODS? To create legacy ArrayFormulas (prior to 2018), you need to press Ctrl+Shift+Enter in Excel. I need to do…
Houssam Haddad
- 13
- 4
1
vote
1 answer
SAS: change the colour and thickness of the reference label in proc gplot
I am trying to plot the different levels of salary in a needle plot and I'd like a reference line. The following code provides this reference line but the line is the same colour as the needles and is too thin. Is there a way to change…
78282219
- 85
- 1
- 8
1
vote
1 answer
proc transreg not outputting curve fit plot
I am using proc transreg to test different transformations in the sashelp.baseball dataset. I request all plots and sometimes I can see a curve fit graph and sometimes I can't. Is there something I am missing if I want to output the regression fit…
78282219
- 85
- 1
- 8
1
vote
0 answers
How to use phpMyAdmin to import ods file for Null value fields with default empty space
I want to use phpMyAdmin to import data from ods file to MySQL / Mariadb table. The table contains some fields like below:
city_desc CHAR(1) NOT NULL DEFAULT ''
It is NOT Null, Default is empty space.
Once import, because the column has no value,…
Marcus
- 21
- 2
1
vote
1 answer
Unable to extract data from postgres table to .ods file, using python
I'm trying to collect output of a postgres query in ods-file using following code. I have created a function read_table that reads the postgres table successfully.
def read_table()
import psycopg2 as ps
import sys
con =None
…
user10330554
- 13
- 4
1
vote
1 answer
Set border and optimal width to a column in a ods file
I trying to find a way to set borders to each cell and the optimal width to each column before creating the ods file [or either after the file has been created - i don't mind].
I'm writing the program in Java and I'm using the jopendocument library…
Maxuel
- 127
- 10
1
vote
0 answers
get hyperlink from ODS file in python?
I need to parse an ODS spreadsheet in Python. No big deal, I can do this:
import pyexcel
book = pyexcel.get_book(file_name="/path/to/my/file.ods")
sheet = book.sheet_by_index(0)
for row in sheet:
print row
Here's the rub. One of the columns…
Chris Curvey
- 9,738
- 10
- 48
- 70
1
vote
1 answer
How to reuse use SAS output in other procedures
How do I use the output variable of one PROC into another PROC.
I'm new to SAS and have spend many hours trying to solve this problem in the program below.
DATA FA2;
SET FA2;
proc iml;
start main;
use FA2;
read all var…
rakesh
- 11
- 2
1
vote
1 answer
Row number column in OpenOffice calc
I have a ods file containing two columns and 3700 rows.
I need to add a column to this file where the column will automatically show the row number, In the way that I get the pdf output, the content of each row is as follows:
1 | first row first…
KavehRS
- 11
- 1
- 3
1
vote
2 answers
How to export from R to a calc ods file in multiple sheets
I try to export three dataframes to a single calc file (ods), but I don't see how to specify the sheet I'm writing into.
I tried the readODS package which has a write_ods function, but in the documentation I see not mention of a sheet…
Malta
- 1,883
- 3
- 17
- 30