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
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.
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.
"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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.