Help Please

MagD — Thu, 03 Jun 2021 15:26:43 GMT

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;

Re: Help Please

Reeza — Thu, 03 Jun 2021 16:38:48 GMT

Do you want to delete that column or that row?
You get multiple records because one of your data sets has multiple records for that observation based on the accountnumber, branchcode and subaccount number. So if you shouldn't have duplicates you may want to verify your input data set or you may need to update your join condition to account for something else. It's usually the latter in my experience.

Re: Help Please

MagD — Thu, 03 Jun 2021 18:50:21 GMT

Hey Reeza,

I used your suggestion of updating my join condition. It worked!
Thank you for your input. I appreciate it.

topic Re: Help Please in New SAS User

Help Please

Re: Help Please

Re: Help Please