Full table details not available when I am using the distinct statement.

[Sandeep77]

Hi Experts,

My coding is running successfully. I have tried to get the confirmed email information and then I am looking for distinct email accounts. But when I see the distinct email account it is giving just the account number. I want the full table of distinct accounts just like in the first code (confirmed email). Can you please suggest what should I change in my code?

proc sql;
create table confirmed_email as
select a.*,
b.emailaddress,
b.confirmeddate
from work.Live_phone_numbers as a
inner join p2scflow.emailaddress as b on a.Account_number = b.debt_code
where b.confirmeddate is not missing;
quit;

proc sql;
create table distinct_email_accounts as
select distinct
Account_number
from work.confirmed_email;
quit;

[PaigeMiller]

---

@Sandeep77 wrote:

Hi Experts,

My coding is running successfully. I have tried to get the confirmed email information and then I am looking for distinct email accounts. But when I see the distinct email account it is giving just the account number. I want the full table of distinct accounts just like in the first code (confirmed email). Can you please suggest what should I change in my code?

...

proc sql;
create table distinct_email_accounts as
select distinct
Account_number
from work.confirmed_email;
quit;

---

You asked for only Account_number variable in data set distinct_email_accounts. If you want other variables in this data set, you have to put those variable names in the code after select distinct