Hello, I am facing challenge in getting the desired output while exporting character variable using ODS tagsets. Here is the code used: DATA TEST; INPUT PERC $10; CARDS; 2% <0.1% 0.035% ; RUN; ODS _ALL_ CLOSE; ODS TAGSETS.EXCELXP FILE="TEST.XLS"; PROC PRINT DATA = TEST; VAR PERC / STYLE= {TAGATTR= 'FORMAT:@'}; RUN; ODS TAGSETS.EXCELXP CLOSE; SAS ODS Output in Excel: PERC ---- 0.02% <0.1% 0.00035% I would need the output as below (Same as Dataset): PERC ---- 2% <0.1% 0.035% Why would ODS Excel output give 0.02% instead of 2% while it is stored as a character variable in dataset. Can anyone help me in getting the same output in excel as in dataset? Thanks in advance!
... View more