Desktop productivity for business analysts and programmers

Regarding SQL JOINS

Reply
Occasional Contributor
Posts: 11

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: 9,593

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,046

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,399

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
  • 136 views
  • 1 like
  • 4 in conversation