Cynthia, Thanks for your timely response! I used your data and code, my excel exported two rows of label names. Can you see what I did incorrectly? ODS EXCEL FILE = '/Informatics_Customers/GP/GP/Temp/saj/Sample_ODS_Excel.xlsx'; PROC REPORT DATA=Sample_ODS_Excel; COLUMN ('Name Label' Name) ('Gender Label' Sex ) ('Age Label' Age) ('Height Label' Height) ('Weight Label' Weight); DEFINE Name / Order; DEFINE Sex / DISPLAY; DEFINE Age / DISPLAY; DEFINE Height / DISPLAY; DEFINE Weight / DISPLAY; RUN; ODS EXCEL CLOSE; Name Label Gender Label Age Label Height Label Weight Label Name Label Gender Label Age Label Height Label Weight Label Alfred M 14 69 112.5 Alice F 13 56.5 84 Barbara F 13 65.3 98 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 James M 12 57.3 83 Jane F 12 59.8 84.5 Janet F 12 62.5 112.5 Alphabetic List of Variables and Attributes# Variable Type Len Label 3 Age Num 8 Age Label 4 Height Num 8 Height Label 1 Name Char 25 Name Label 2 Sex Char 1 Gender Label 5 Weight Num 8 Weight Label
... View more