I need help in deleting a row, please. The output of the code is producing 2 lines. All the other variables are the same. How can I delete the column with the blank:
The output I want is:
I am using the following code:
proc sql;
create table Month
as select a.*,
b.finmonth,
case when a.goodcnt+a.badcnt = 0 and b.finmonth = 202103 then '0'
when a.goodcnt+a.badcnt = 1 and b.finmonth = 202103 then '1'
when a.goodcnt+a.badcnt = 2 and b.finmonth = 202103 then '2'
when a.goodcnt+a.badcnt = 3 and b.finmonth = 202103 then '3'
when a.goodcnt+a.badcnt = 4 and b.finmonth = 202103 then '4'
when a.goodcnt+a.badcnt = 5 and b.finmonth = 202103 then '5'
when a.goodcnt+a.badcnt = 6 and b.finmonth = 202103 then '6'
when a.goodcnt+a.badcnt = 7 and b.finmonth = 202103 then '7'
when a.goodcnt+a.badcnt = 8 and b.finmonth = 202103 then '8'
when a.goodcnt+a.badcnt = 9 and b.finmonth = 202103 then '9'
when a.goodcnt+a.badcnt = 10 and b.finmonth = 202103 then '10'
when a.goodcnt+a.badcnt > 10 and b.finmonth = 202103 then '>10'
end as 'No of Bureau Accounts'n
from Current_Month as a left join totaldata8 as b
on a.accountnumber =b.accountnumber
and a.branchcode =b.branchcode
and a.subaccountnumber=b.subaccountnumber;
quit;