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
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).
@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.
A simple delete query?
proc sql;
delete from myData
where rebate is missing and NWAC is missing;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.