Desktop productivity for business analysts and programmers

Regarding SQL JOINS

Reply
Contributor
Posts: 23

Regarding SQL JOINS

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

Super User
Posts: 10,571

Re: Regarding SQL JOINS

Posted in reply to saikiran_nemani

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).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 13,941

Re: Regarding SQL JOINS

Posted in reply to saikiran_nemani

@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.

Esteemed Advisor
Posts: 5,625

Re: Regarding SQL JOINS

Posted in reply to saikiran_nemani

A simple delete query?

 

proc sql;
delete from myData
where rebate is missing and NWAC is missing;
quit;
PG
Ask a Question
Discussion stats
  • 3 replies
  • 152 views
  • 1 like
  • 4 in conversation