Introduction
Solutions
Conclusions
SAS Formats vs. Excel Formats
SAS Formats vs. Excel Formats
SAS format Excel format Excel format name
$8. @ Text
8.2 0.00 Number, 2 decimal places
z8.2 00000.00 (none)
percent8.2 0.00% Percentage, 2 decimal places
mmddyy8. mm/dd/yy Date, type “03/14/01”
comma12.2 #,##0.00 Number, 2 decimal places, with ...
We need to translate SAS formats into Excel formats!
Nate Derby & Colleen McGahan Organizing SAS Files 10 / 24