topic data step query in SAS Data Science

data step query

rahulks — Tue, 23 Apr 2013 18:28:29 GMT

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?

Re: data step query

PGStats — Tue, 23 Apr 2013 18:36:41 GMT

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.

Re: data step query

rahulks — Tue, 23 Apr 2013 21:44:43 GMT

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.

Re: data step query

PGStats — Tue, 23 Apr 2013 22:48:47 GMT

A small example (input and output data) would help us to understand what you want.