HI all,
this is my data set and i want to using NULLIF fundtion on its MED column
am i typing anything wrongs cause the log is keep warming me this :
PROC SQL;
UPDATE ClaimCoverageData2
SET MED= NULLIF (MED,0);
RUN;
ERROR: Function NULLIF could not be located.
ERROR: MED, a numeric column, can only be updated with a numeric expression.
| AH | 201801 | 2016 | 201712 | 1000.00 | 0 | 0 | 0 | 0 | 0 | 1000.00 | 128.10 | 0 | 0 | 0 | 0.000 | 0 | 128.10 |
| AH | 201801 | 2017 | 201705 | 39000.00 | 0 | 0 | 0 | 0 | 0 | 39000.00 | 4995.93 | 0 | 0 | 0 | 0.000 | 0 | 4995.93 |
| AH | 201801 | 2017 | 201706 | 39600.00 | 0 | 0 | 0 | 0 | 0 | 39600.00 | 5072.80 | 0 | 0 | 0 | 0.000 | 0 | 5072.80 |
| AH | 201801 | 2017 | 201710 | 3569.00 | 0 | 0 | 0 | 0 | 0 | 3569.00 | 457.19 | 0 | 0 | 0 | 0.000 | 0 | 457.19 |
| AH | 201801 | 2017 | 201711 | 10000.00 | 0 | 0 | 0 | 300 | 0 | 10300.00 | 1281.02 | 0 | 0 | 0 | 38.435 | 0 | 1319.45 |
| AH | 201801 | 2017 | 201712 | 44300.00 | 0 | 0 | 0 | 0 | 0 | 44300.00 | 5674.87 | 0 | 0 | 0 | 0.000 | 0 | 5674.87 |
| AH | 201801 | 2017 | 201801 | 13300.00 | 0 | 0 | 0 | 0 | 0 | 13300.00 | 1703.75 | 0 | 0 | 0 | 0.000 | 0 | 1703.75 |
| AH | 201802 | 2015 | 201610 | 4500.00 | 0 | 0 | 0 | 0 | 0 | 4500.00 | 575.26 | 0 | 0 | 0 | 0.000 | 0 | 575.26 |
| AH | 201802 | 2017 | 201705 | 10500.00 | 0 | 0 | 0 | 0 | 0 | 10500.00 | 1342.28 | 0 | 0 | 0 | 0.000 | 0 | 1342.28 |
| AH | 201802 | 2017 | 201710 | 19000.00 | 0 | 0 | 0 | 0 | 0 | 19000.00 | 2428.88 | 0 | 0 | 0 | 0.000 | 0 | 2428.88 |
| AH | 201802 | 2017 | 201711 | 0.00 | 0 | 0 | 0 | 4000 | 0 | 4000.00 | 0.00 | 0 | 0 | 0 | 511.341 | 0 | 511.34 |
| AH | 201802 | 2017 | 201712 | 8250.00 | 0 | 0 | 0 | 0 | 0 | 8250.00 | 1054.65 | 0 | 0 | 0 | 0.000 | 0 | 1054.65 |
| AH | 201802 | 2017 | 201801 | 56610.00 | 0 | 0 | 0 | 300 | 0 | 56910.00 | 7236.78 | 0 | 0 | 0 | 38.357 | 0 | 7275.14 |
| AH | 201802 | 2017 | 201802 | 500.00 | 0 | 0 | 0 | 0 | 0 | 500.00 | 63.92 | 0 | 0 | 0 | 0.000 | 0 | 63.92 |
| AH | 201802 | 2018 | 201801 | 3000.00 | 0 | 0 | 0 | 0 | 0 | 3000.00 | 383.51 | 0 | 0 | 0 | 0.000 | 0 | 383.51 |
| AH | 201803 | 2016 | 201705 | 0.00 | 0 | 0 | 0 | 4000 | 0 | 4000.00 | 0.00 | 0 | 0 | 0 | 511.430 | 0 | 511.43 |
| AH | 201803 | 2017 | 201705 | 40500.00 | 0 | 0 | 0 | 0 | 0 | 40500.00 | 5178.25 | 0 | 0 | 0 | 0.000 | 0 | 5178.25 |
| AH | 201803 | 2017 | 201706 | -4000.00 | 0 | 0 | 0 | 0 | 0 | -4000.00 | -511.43 | 0 | 0 | 0 | 0.000 | 0 | -511.43 |
| AH | 201803 | 2017 | 201710 | 8000.00 | 0 | 0 | 0 | 0 | 0 | 8000.00 | 1022.86 | 0 | 0 | 0 | 0.000 | 0 | 1022.86 |
| AH | 201803 | 2017 | 201711 | 2000.00 | 0 | 0 | 0 | 0 | 0 | 2000.00 | 255.72 | 0 | 0 | 0 | 0.000 | 0 | 255.72 |
| AH | 201803 | 2017 | 201801 | -50.00 | 0 | 0 | 0 | 0 | 0 | -50.00 | -6.40 | 0 | 0 | 0 | 0.000 | 0 | -6.40 |
| AH | 201803 | 2017 | 201802 | 8640.00 | 0 | 0 | 0 | 300 | 0 | 8940.00 | 1104.72 | 0 | 0 | 0 | 38.358 | 0 | 1143.08 |
| AH | 201803 | 2017 | 201803 | 12250.00 | 0 | 0 | 0 | 0 | 0 | 12250.00 | 1566.27 | 0 | 0 | 0 | 0.000 | 0 | 1566.27 |
| AH | 201803 | 2018 | 201803 | 500.00 | 0 | 0 | 0 | 0 | 0 | 500.00 | 63.92 | 0 | 0 | 0 | 0.000 | 0 | 63.92 |
| AH | 201804 | 2015 | 201607 | -459.00 | 0 | 0 | 0 | 0 | 0 | -459.00 | -58.57 | 0 | 0 | 0 | 0.000 | 0 | -58.57 |
| AH | 201804 | 2015 | 201610 | 42000.00 | 0 | 0 | 0 | 0 | 0 | 42000.00 | 5359.61 | 0 | 0 | 0 | 0.000 | 0 | 5359.61 |
| AH | 201804 | 2016 | 201702 | 1250.00 | 0 | 0 | 0 | 0 | 0 | 1250.00 | 159.51 | 0 | 0 | 0 | 0.000 | 0 | 159.51 |
| AH | 201804 | 2017 | 201705 | 46500.00 | 0 | 0 | 0 | 0 | 0 | 46500.00 | 5933.87 | 0 | 0 | 0 | 0.000 | 0 | 5933.87 |
| AH | 201804 | 2017 | 201802 | 2400.00 | 0 | 0 | 0 | 0 | 0 | 2400.00 | 306.26 | 0 | 0 | 0 | 0.000 | 0 | 306.26 |
| AH | 201804 | 2017 | 201803 | 19200.00 | 0 | 0 | 0 | 0 | 0 | 19200.00 | 2450.12 | 0 | 0 | 0 | 0.000 | 0 | 2450.12 |
| AH | 201804 | 2017 | 201804 | 16600.00 | 0 | 0 | 0 | 0 | 0 | 16600.00 | 2118.33 | 0 | 0 | 0 | 0.000 | 0 | 2118.33 |
| AH | 201804 | 2018 | 201803 | 2300.00 | 0 | 0 | 0 | 0 | 0 | 2300.00 | 293.51 | 0 | 0 | 0 | 0.000 | 0 | 293.51 |
| AH | 201804 | 2018 | 201804 | 100.00 | 0 | 0 | 0 | 0 | 0 | 100.00 | 12.76 | 0 | 0 | 0 | 0.000 | 0 | 12.76 |
| AH | 201805 | 2015 | 201610 | 500.00 | 0 | 0 | 0 | 0 | 0 | 500.00 | 63.71 | 0 | 0 | 0 | 0.000 | 0 | 63.71 |
| AH | 201805 | 2016 | 201612 | 5000.00 | 0 | 0 | 0 | 0 | 0 | 5000.00 | 637.01 | 0 | 0 | 0 | 0.000 | 0 | 637.01 |
| AH | 201805 | 2016 | 201702 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0 | 0 | 0 | 0.000 | 0 | 0.00 |
| AH | 201805 | 2016 | 201705 | 0.00 | 0 | 0 | 0 | -4000 | 0 | -4000.00 | 0.00 | 0 | 0 | 0 | -509.598 | 0 | -509.60 |
| AH | 201805 | 2017 | 201705 | 13500.00 | 0 | 0 | 0 | 0 | 0 | 13500.00 | 1719.91 | 0 | 0 | 0 | 0.000 | 0 | 1719.91 |
| AH | 201805 | 2017 | 201803 | 78050.00 | 0 | 0 | 0 | 0 | 0 | 78050.00 | 9943.66 | 0 | 0 | 0 | 0.000 | 0 | 9943.66 |
| AH | 201805 | 2017 | 201804 | 36479.15 | 0 | 0 | 0 | 100 | 0 | 36579.15 | 4647.48 | 0 | 0 | 0 | 12.738 | 0 | 4660.21 |
| AH | 201805 | 2017 | 201805 | 3450.00 | 0 | 0 | 0 | 0 | 0 | 3450.00 | 439.53 | 0 | 0 | 0 | 0.000 | 0 | 439.53 |
| AH | 201805 | 2018 | 201803 | 1500.00 | 0 | 0 | 0 | 0 | 0 | 1500.00 | 191.11 | 0 | 0 | 0 | 0.000 | 0 | 191.11 |
| AH | 201805 | 2018 | 201804 | 19840.00 | 0 | 0 | 0 | 0 | 0 | 19840.00 | 2527.62 | 0 | 0 | 0 | 0.000 | 0 | 2527.62 |
| AH | 201805 | 2018 | 201805 | 1450.00 | 0 | 0 | 0 | 0 | 0 | 1450.00 | 184.73 | 0 | 0 | 0 | 0.000 | 0 | 184.73 |
| AH | 201806 | 2016 | 201610 | 4860.37 | 0 | 0 | 0 | 0 | 0 | 4860.37 | 619.16 | 0 | 0 | 0 | 0.000 | 0 | 619.16 |
| AH | 201806 | 2017 | 201705 | 40500.00 | 0 | 0 | 0 | 0 | 0 | 40500.00 | 5159.30 | 0 | 0 | 0 | 0.000 | 0 | 5159.30 |
| AH | 201806 | 2017 | 201706 | 10800.00 | 0 | 0 | 0 | 0 | 0 | 10800.00 | 1375.81 | 0 | 0 | 0 | 0.000 | 0 | 1375.81 |
| AH | 201806 | 2017 | 201801 | 2200.00 | 0 | 0 | 0 | 0 | 0 | 2200.00 | 280.25 | 0 | 0 | 0 | 0.000 | 0 | 280.25 |
| AH | 201806 | 2017 | 201803 | 6000.00 | 0 | 0 | 0 | 0 | 0 | 6000.00 | 764.34 | 0 | 0 | 0 | 0.000 | 0 | 764.34 |
| AH | 201806 | 2017 | 201804 | 18218.00 | 0 | 0 | 0 | 0 | 0 | 18218.00 | 2320.80 | 0 | 0 | 0 | 0.000 | 0 | 2320.80 |
| AH | 201806 | 2017 | 201805 | 8057.00 | 0 | 0 | 0 | 0 | 0 | 8057.00 | 1026.39 | 0 | 0 | 0 | 0.000 | 0 | 1026.39 |
| AH | 201806 | 2017 | 201806 | 0.00 | 0 | 0 | 0 | 200 | 0 | 200.00 | 0.00 | 0 | 0 | 0 | 25.475 | 0 | 25.48 |
| AH | 201806 | 2018 | 201804 | 2900.00 | 0 | 0 | 0 | 0 | 0 | 2900.00 | 369.43 | 0 | 0 | 0 | 0.000 | 0 | 369.43 |
| AH | 201806 | 2018 | 201805 | 11000.00 | 0 | 0 | 0 | 0 | 0 | 11000.00 | 1401.30 | 0 | 0 | 0 | 0.000 | 0 | 1401.30 |
| AH | 201806 | 2018 | 201806 | 3000.00 | 0 | 0 | 0 | 0 | 0 | 3000.00 | 382.17 | 0 | 0 | 0 | 0.000 | 0 | 382.17 |
