If there is a condition,in which we have to take only those observations which are present in the same variable of different dataset, how we will write the query?
Something like this :
proc sql;
create table A_and_B as
select * from A
union all corresponding
select * from B;
quit;
selects only variables in table A and B which have the same name and type. Other variables not in common are dropped.
PG
thnx for the reply, but this query will not help me...
actually I works for the bank, and I have to put a query in a dataset which implies that, if account number is in accounts then table, then only account number will be added to the table on which I am applying my query.
A small example (input and output data) would help us to understand what you want.
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.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.