Hi, I have a problem with scientific notation. My dataset prova has 9 rows and it is so composed: Vincolo bil22 bil23 bil24 BIL031 - BIL031 80147,35 80147,35 80147,35 BIL031 - BIL031 0 0 0 BIL031 - BIL031 0 0 0 BIL031 - BIL031 0 0 0 BIL031 - BIL031 0 0 0 BIL031 - BIL031 -23793,09 -23793,09 -23793,09 BIL031 - BIL031 -9750,34 -9750,34 -9750,34 BIL031 - BIL031 -22784,59 -22784,59 -22784,59 BIL031 - BIL031 -23819,33 -23819,33 -23819,33 Variables bil22, bil23 and bil24 are created with: data prova; set vincolati; bil22=round(bilancio2022,.01); bil23=round(bilancio2023,.01); bil24=round(bilancio2024,.01); run; when I summarize proc sql; CREATE TABLE vinc_tot AS SELECT vincolo, sum(Bil22) as vincsum22, sum(Bil23) as vincsum23, sum(Bil24) as vincsum24 FROM prova GROUP BY vincolo; QUIT; I expect a risult like this: vincolo vincsum22 vincsum23 vincsum24 BIL031 - BIL031 0 0 0 But I obtain this: vincolo vincsum22 vincsum23 vincsum24 BIL031 - BIL031 3.637979E-12 3.637979E-12 3.637979E-12 As if in Bil22, Bil23 and Bil24 (rounded .01 !!! ) there where several decimals. Someone can help me? Thank you Massimo
... View more