Cynthia,   What is the release of SAS are you running this?   This is what we have. %put &sysvlong 9.04.01M3P062415   I've used the tagset.excelpxp to do this as a workaround and I do not have the same issue. All 30 fields are exported in Excel when using ODS tagset.excelxp.     ... View more

Hi Cynthia,   I've tried the code you provided and it does show all columns. However, when I tried it with a dataset with 2000+ rows then that's the time some of the fields drop off.   Thanks, Barns ... View more

Hi Paige,    I have 30 fields from the dataset but in Excel it only shows 25 fileds. ... View more

Hi,    Here's the Proc report that I used.   ods Excel file="&rpt_location./&report_cadetail." options (absolute_column_width="20,20,40,20,50,20,20,50,20,20,20,20,20,20,25,25,25,25,25,25,25,25,25,30,30,30,30,30,30,30" sheet_name='Detail exceptions' frozen_headers = 'on' autofilter = 'all' sheet_interval = 'none' suppress_bylines='yes' embedded_titles='yes' embedded_footnotes='yes' ); proc report data = report_ca_other_excp style(column)=[tagattr="wrap:yes" cellwidth=1000% vjust=top ] ; options missing=''; title justify= left "CA -  Report"; columns _ALL_; run; ods Excel close; ... View more