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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.