left join sql do not work

[sasphd]

Hello, 

when I run the program below there is no error in the log but the variable EPU is empty "."

proc sql;
 create table test1 as
 select Distinct R.*, B.EPU
 from test as R
 left join  EPU_Data as B on R.sas_date=B.sas_date
order by R.Secid, R.sas_date;
 quit;

[PaigeMiller]

This happens because one (or both) of the following is true:

1. Variable EPU is always missing data set B; or
2. variable SAS_DATE in data set A never matches the values of SAS_DATE in data set B

[sasphd]

thanks for the response.
I have the same data format for sas_date variable and EPU is not missing there is a number for each data?

[PaigeMiller]

---

@sasphd wrote:
I have the same data format for sas_date variable and EPU is not missing there is a number for each data?

---

Not the format ... the actual values of SAS_DATE don't match.

[Kurt_Bremser]

Run this:

data test1,
merge
  test (in=t)
  epu_data (
    in=e
    keep=sas_date epu
  )
;
by sas_date,
if t and e;
run;

and then post the complete log (code and messages) from this step.

[PGStats · Accepted solution]

Maybe you imported the dates from somewhere where they are not represented quite the same as in SAS (e.g. Excel)? Happened to me once. The date numbers were not integers. Try:

left join  EPU_Data as B on round(R.sas_date) = round(B.sas_date)