topic Regarding SQL JOINS in SAS Enterprise Guide

Regarding SQL JOINS

saikiran_nemani — Tue, 20 Mar 2018 09:32:28 GMT

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

Re: Regarding SQL JOINS

Kurt_Bremser — Tue, 20 Mar 2018 12:33:51 GMT

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

Re: Regarding SQL JOINS

ballardw — Tue, 20 Mar 2018 16:34:09 GMT

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

Re: Regarding SQL JOINS

PGStats — Wed, 21 Mar 2018 04:13:46 GMT

A simple delete query?

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