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.
lineno = 'Line Number'
age = 'Age'
svcdat_sas = 'Date'
poscod = 'Place of Service'
lstnam = ' Last Name'
fstnam = ' First Name'
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?