The SAS Output Delivery System and reporting techniques

Need column header bold

Reply
Frequent Contributor
Posts: 90

Need column header bold

Hi

I need to get the column header name in bold on the report. And other issue am having an dataset name as age , while opened as the sas dataset I can able view with labels.When am exporting an same dataset to the excel , I didn’t get the labels.

Example:
data age;
set mkk;
label
lineno = 'Line Number'
age = 'Age'
svcdat_sas = 'Date'
poscod = 'Place of Service'
lstnam = ' Last Name'
fstnam = ' First Name'
;
run;

proc export data=age
outfile= "NY\current\c.xls"
dbms=EXCEL replace;
sheet=Age;
run;

I tried with the proc report , I couldn’t make it .Please can you provide me an example to make the header bold and that should reflect while exporting to excel.

Thanks in Advance.
SAS Super FREQ
Posts: 8,743

Re: Need column header bold

Hi:
PROC EXPORT only exports DATA -- there are no fonts or formatting (such as bold) when you use PROC EXPORT. SAS is exporting data to data -- if you go into an Excel sheet and start typing, there is no additional formatting, unless you add it. When you use PROC EXPORT, it is as though you typed into the cells without any other formatting.

You said you tried PROC REPORT. If you used ODS CSV with PROC REPORT, then again, there is no formatting in a CSV file -- but you would have been able to get labels. On the other hand, if you used ODS HTML, ODS MSOFFICE2K or ODS TAGSETS.EXCELXP with PROC REPORT, then you should have seen formatting and labels in the output.

What ODS destination did you use with PROC REPORT?

cynthia
Super Contributor
Posts: 273

Re: Need column header bold

Proc export has a label option but

Bolding is a matter of ODS

Andre
Ask a Question
Discussion stats
  • 2 replies
  • 707 views
  • 0 likes
  • 3 in conversation