proc report

[draroda]

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

[Reeza · Accepted solution]

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. 

[RW9]

"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.