DATA Step, Macro, Functions and more

proc report

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

proc report

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


Accepted Solutions
Solution
‎11-09-2017 12:03 PM
Super User
Posts: 24,010

Re: proc report

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. 

View solution in original post


All Replies
Solution
‎11-09-2017 12:03 PM
Super User
Posts: 24,010

Re: proc report

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. 

Super User
Super User
Posts: 9,840

Re: proc report

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 70 views
  • 0 likes
  • 3 in conversation