About Petersi

Petersi · ‎09-25-2013

On Z/OS I can browse the file and I can see that it has wrapped. When I download the file and open it in Excel it wraps as well. When I shorten the list of columns it does not wrap. That is why I am wondering if there is a record lenght parameter with PROC Report, or maybe a restriction with CSV files.

Petersi · ‎09-25-2013

Hi - I am using ODS CSV to output on mainframe. Even before I download the file to view in Excel I can browse it to see that the title row has wrapped around

Petersi · ‎09-25-2013

Hi - I am creating a CSV file with Proc Report. There are over 200 columns and no matter what LRECL I specify the report keeps wrapping around. Can you tell me if there is a setting on maximum record lenght within the procdure itself?

Petersi · ‎02-01-2013

Thanks! I am surprised that there is not an easy option for the DEFINE statement for this. Using compute blocks seems a bit clunky...

Petersi · ‎02-01-2013

Hi - when you specify a column as either 'Order' or 'Group', is there an option on the DEFINE statement to have the values repeat for every line, instead of once at the start of the group?

Petersi · ‎12-13-2010

Can anyone tell me if it is possible with ODS to pass paramters for the properties tab in Excel, for example Subject, Author, Manager, etc.

Petersi · ‎09-18-2009

I'm not sure if this helps, but I recently had to write a program to identify all the chart objects in a workbook. You can find out a lot about a workbook using the topics dde triplet: filename xltopics dde'excel|system!topics' lrecl=32000; data _null_; length topic $ 1000; infile xltopics pad dsd notab dlm='09'x; input topic $ @@; put topic=; run; A good reference is Excel Exposed: Using Dynamic Data Exchange to Extract Metadata from MS Excel Workbooks by Koen Vyverman. You can find it and more of his papers at http://www.sas-consultant.com/professional/papers.html

Petersi · ‎07-27-2009

Thanks Bill! I've been reading Stephen Few's book Information Dashboard Design, and I am now fully converted to the view that pie charts are limited in their usefulness. Unfortunately it is proving difficult to convince clients of this.

Petersi · ‎07-22-2009

For Pie and Donut charts, when using the DETAIL=variable option, is there a way to modify the height of the text that is printed on the inner circle slices? I have one detail slice that is too narrow for the detail variable value, and it is being forced out of the pie chart with an arrow. I'd like to decrease the font size and keep the value inside the pie. There seems to be options to modify the text for the label in the Donut hole, but I can't find anything that will allow me to modify the detail text.

Petersi · ‎03-19-2009

Yes, I think I would agree with Paige, but I need the table packaged with the graph output in a .ps file. I think I would still need Annotate to attach the PROC REPORT output in there.

Petersi · ‎03-19-2009

Thanks. I was actually just starting to put this together with Annotation, but was hoping there would be a simple option that would take care of this automatically.

Petersi · ‎03-18-2009

Is there an option in PROC GPLOT or on the PLOT statement that will produce a table of plotted values below the graph, similar to the 'Add a Data Table' option when creating a chart in Excel?

Petersi · ‎10-15-2007

Thanks Cynthia!

Petersi · ‎10-15-2007

When I use a BREAK statement on a group variable, the SUMMARIZE option will create a total for all columns. How do I suppress the summarization of certain columns (such as date values)? I don't want to use a compute block because that will create one row spanning the entire report. I need the selected summarized values to line up under the appropriate column in excel.

Petersi · ‎09-10-2007

Is there a way to create a bolded outline of a group of cells using a style statement without having each individual cell's internal borders affected? For example, I could have a group of cells in a spreadsheet from A1 to B2. I want a bolded outline around the group, but not on the inside of the group.

Online Status	Offline
Date Last Visited	‎10-31-2020 12:35 PM

Re: Maximum Record Length for Proc Report and ODS/CSV

Re: Maximum Record Length for Proc Report and ODS/CSV

Maximum Record Length for Proc Report and ODS/CSV

Re: PROC REPORT Order variables

PROC REPORT Order variables

Passing Properties Parameters to Excel with ODS

Re: Refreshing a series of pivot tables

Re: GCHART Pie and modifying DETAIL text

GCHART Pie and modifying DETAIL text

Re: Add a data table to a plot in PROC GPLOT

Re: Maximum Record Length for Proc Report and ODS/CSV

Re: Maximum Record Length for Proc Report and ODS/CSV

Maximum Record Length for Proc Report and ODS/CSV

Re: PROC REPORT Order variables

PROC REPORT Order variables

Passing Properties Parameters to Excel with ODS

Re: Refreshing a series of pivot tables

Re: GCHART Pie and modifying DETAIL text

GCHART Pie and modifying DETAIL text

Re: Add a data table to a plot in PROC GPLOT

Re: Add a data table to a plot in PROC GPLOT

Add a data table to a plot in PROC GPLOT

Re: Customized Summary Lines in PROC REPORT

Customized Summary Lines in PROC REPORT

ODS PROC Report outlining a group of cells

SAS Analytics Explorers