Thank you for the elaborate explanation @Patrick , from your explanation, it seems better to use SAS code to export table to excel file when you have format to be conformed. Hi @Tom , The database is Microsoft SQL Server. The table didnt exist in the remote database. As you said, i just register the table using SAS to remote database. So when SAS created the table, it will used 21.2 as the format of SQL table. when the data got loaded to the table, the value will got truncated. ... View more

Hi @Patrick thanks for the reply, your answer enlighten me about how informat used. I want to ask more question if possible, We also write table to text file, but we are using data step data _null_; set LIB.Table; attrib Date length=8 format = date9.; attrib ID length=$30 format = $30; attrib amount length=8 format = 21.2 file "......../textfile.txt"; put Date ID amount ; run; (1)If informat didnt change the internal value, the value printed got rounded in this step?(i always thought the moment i changed the informat, the internal value will changed, your explanation really saved me). (2)And if i use "send to" excel file option in EG what statement it used? and will it print the internal value or formatted value?. (3)When i copy the table to SQL table, will the internal value or formatted value that got printed to SQL table? Thank you. ... View more

I would love to use BEST32 as format, but the user want the format to be 21.2 in the report. And creating this backup table is the last step of current flow. So report creation is done before this step. ... View more

Thank you for your reply @Kurt_Bremser , The input has varying decimals, Amount 5691329.442412 3213422.9 141215788276.73 As this value is needed for report, we specified the format and informat to 21.2. After we state the format and informat, the display in SAS will be Amount 5691329.44 3213422.90 141215788276.73 But if i export the table to excel using EG, the value will be the same as input Amount 5691329.442412 3213422.9 141215788276.73 We also create a Microsoft SQL table for history or backup table using Data Integration. And if i export the Backup table to excel using EG, the value in excel will be Amount 5691329.44 3213422.90 141215788276.73 On top of that, i sum the amount of source SAS table and backup SQL table, there is small gap about 0.2 between them. ... View more