there are these columns in a table: acct_number cust_id and pin.
there are millions of records.
but I would like to select only those which have the following combination:
acct_nbr cust_id pin
1234 111 Abc
2345 111 pqr
i.e if a cust_id has different acct_nbr and differt pin.
proc sql;
select * from have
group by cust_id
having count(distinct acct_nbr)>1 and count(distinct pin)>1;
quit;
Thaks Stat:
the above table have , I need to join with another table.
the other table has cust_id and flag. and flag has values like M,L,P and blank
I would like to get only those values where first record is M and second is a blank.
The output looks like:
acct_nbr cust_id pin flag
1234 111 Abc M
2345 111 pqr
SASPhile,
Take the second table and find all the ID's with flag M and the ID is in Have to create table 'secondM'. Then go back to the second table and capture all the rows that have an ID in 'secondM' creating table 'secondZ'. All the ID's in 'secondZ' are matched to your criteria. Then join the Have and Second tables where ID's match and ID's are in 'secondZ'.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.