https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71725#M20719 Hi:<BR /> 99.99 is 5 total characters, including the decimal point. So the format for 99.99 would be 5.2 -- but 100.00 is 6 total characters, including the decimal point. So a format of 5.2 would be incorrect for the SAS format width to use for 100.00 percent. In the same fashion, the dollar amount: $12,345.67 would need at least a width of 10 and the "official" format specification would be: dollar10.2 -- you need 10 as the width because you have 7 numbers and 3 symbols: . , and $.<BR /> <BR /> The clue that you have a format width that's not "wide" enough is that you should see a note in the SAS Log that says something like:<BR /> <B><BR /> NOTE: At least one W.D format was too small for the number to be printed. The decimal may be<BR /> shifted by the "BEST" format.<BR /> <BR /> </B><BR /> <BR /> The format would need to be even larger if you were using a PICTURE format to put a percent sign in the column. Complicating the whole picture is HOW you are exporting to Access (Microsoft Access???) Are you using PROC EXPORT or the LIBNAME engine???<BR /> <BR /> If you fix the format width and your number does not get carried over into Microsoft Access, then you may want to work with Tech Support on this question.<BR /> <BR /> cynthia Sat, 27 Mar 2010 04:00:08 GMT Cynthia_sas 2010-03-27T04:00:08Z https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71724#M20718 I'm trying to export into Access percentages. The percentages were created using proc tabulate (pctSum)<BR /> <BR /> The percentages are formatted using 5.2<BR /> The Access table is showing all the numbers except the value 100.<BR /> How can I fix the problem so SAS exports all the values that are 100 into Access? Fri, 26 Mar 2010 22:49:04 GMT https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71724#M20718 deleted_user 2010-03-26T22:49:04Z https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71725#M20719 Hi:<BR /> 99.99 is 5 total characters, including the decimal point. So the format for 99.99 would be 5.2 -- but 100.00 is 6 total characters, including the decimal point. So a format of 5.2 would be incorrect for the SAS format width to use for 100.00 percent. In the same fashion, the dollar amount: $12,345.67 would need at least a width of 10 and the "official" format specification would be: dollar10.2 -- you need 10 as the width because you have 7 numbers and 3 symbols: . , and $.<BR /> <BR /> The clue that you have a format width that's not "wide" enough is that you should see a note in the SAS Log that says something like:<BR /> <B><BR /> NOTE: At least one W.D format was too small for the number to be printed. The decimal may be<BR /> shifted by the "BEST" format.<BR /> <BR /> </B><BR /> <BR /> The format would need to be even larger if you were using a PICTURE format to put a percent sign in the column. Complicating the whole picture is HOW you are exporting to Access (Microsoft Access???) Are you using PROC EXPORT or the LIBNAME engine???<BR /> <BR /> If you fix the format width and your number does not get carried over into Microsoft Access, then you may want to work with Tech Support on this question.<BR /> <BR /> cynthia Sat, 27 Mar 2010 04:00:08 GMT https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71725#M20719 Cynthia_sas 2010-03-27T04:00:08Z https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71726#M20720 Hi Cynthia:<BR /> <BR /> Changing the format to 6.2 solved the problem!!<BR /> <BR /> Thank you! Mon, 29 Mar 2010 18:07:26 GMT https://communities.sas.com/t5/SAS-Procedures/Exporting-to-Access-cutoff/m-p/71726#M20720 deleted_user 2010-03-29T18:07:26Z