Hello, thank you for your solution, can you tell me what I am doing wrong? I lose the negative sign for negative values? Thank you!! I attached a screen shot of the results. PROC SQL; CREATE TABLE WORK.OTP_PBT_AND_TAX_GRP AS SELECT t1.Source, t1.'Total Total Pre-Tax Book Income'n, t1.'Total Tax Provision'n, /* PTBI */ (INPUT(COMPRESS(t1.'Total Total Pre-Tax Book Income'n, ' . ' , 'kd'),BEST32.)) FORMAT=BEST32. AS PTBI, /* PTBI1 */ (INPUT(t1.'Total Total Pre-Tax Book Income'n, BESTcomma32.)) AS PTBI1 FROM WORK.TRNSTRANSPOSED_0000 t1; QUIT;
... View more