Regarding SQL JOINS

[saikiran_nemani]

I have the Following Variables Names as Below :

S.No   Lead_No   Billing_Reference  Quota_Type         Id          Sub_status   Rebate  NWAC 

1        43618215        838389                  CHB          a0d2000        Installed     Space    Space

2        43618215        838389                  CHB          a0d2000        Installed       587       610

For Every Record We are Getting One blank Value for Rebate & NWAC and We need to eliminate in Proc Sql

[Kurt_Bremser]

Do you want those instances deleted from the dataset, or do you want to set values according to a rule?

If the second, please post the rule(s).

[ballardw]

---

@saikiran_nemani wrote:

I have the Following Variables Names as Below :

S.No   Lead_No   Billing_Reference  Quota_Type         Id          Sub_status   Rebate  NWAC 

1        43618215        838389                  CHB          a0d2000        Installed     Space    Space

2        43618215        838389                  CHB          a0d2000        Installed       587       610

For Every Record We are Getting One blank Value for Rebate & NWAC and We need to eliminate in Proc Sql

---

Perhaps sharing the code that is generating the output and descriptions, if not example data, from the sets used in the join would help.

[PGStats]

A simple delete query?

proc sql;
delete from myData
where rebate is missing and NWAC is missing;
quit;