Hello, I have two excel files that I am importing below: #1 Total Balance Target Balance $473,480,802 $450,109,462 $427,654,020 #2 Total Balance Target Balance $436,301,145 $0 $340,967,812 $0 $293,301,145 $0 When, I import both and set together, SAS will translate the Null values in #1 to be 0, so my final table will be: Total Balance Target Balance $436,301,145 $0 $340,967,812 $0 $293,301,145 $0 $473,480,802 $0 $450,109,462 $0 $427,654,020 $0 However, I want the null values to remain intact. I want NULL Target balances in row 4, 5, 6. Anyone have any tips on how to keep the NULL values intact when I do the proc Import?
... View more