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'.
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.
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.