topic Re: proc report in SAS Programming

proc report

draroda — Thu, 09 Nov 2017 16:53:09 GMT

Hi Team,

We need output in .CSV format and for same , i am using ODS csvall .But doing so, i am not getting desired output with respect to alignment of values and header using style(header) and style(column) and also some of the colours which i have adjustedwith use of call define .

Can you help me if this is the default behaviour or is there any way to do so for csv output.

Regards,

Rajesh

Re: proc report

Reeza — Thu, 09 Nov 2017 16:57:12 GMT

Using PROC REPORT to generate a CSV file doesn't make sense. Can you explain your requirement more?

CSV don't have columns, they're a text file with comma delimiters.

Re: proc report

RW9 — Thu, 09 Nov 2017 17:00:38 GMT

"We need output in .CSV format and for same"

and

"lignment of values and header using style(header) and style(column) and also some of the colours which i have adjustedwith use of call define"

Are two mutually exclusive things. CSV is a plain text file format, data is present separated by a comma. There is no style information.

What I suspect you are doing is opening this in Excel. CSV is not, and I repeat not Excel. Excel contains a CSV read module that will take the text file, and parse data into columns based on the comma. It sill will not have any style.

You need to decide what you really want, a plain text highly useful CSV file for transport of data around, or a fully functioning Excel file with very little in the way of data usability. The first is for data transfer, the second for people to look at and you get the second by using ods tagsets.excelxp or ods excel and output using proc report.