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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.