Format Help

[This widget could not be displayed.]

If one dataset (Test1) and I have variable ‘displaymonth’ with the format DATETIME20.

and

the other dataset (Test2) variable ‘displaymonth’ $8.

How do I go about getting the first dataset (Test1) ‘displaymonth’ to be the same as Test2? So when I merge the 2 they match?

I tried this but doesn't work

Data Test1;
Set Test1;
Applseq=applseq+0;
put displaymonth=$8.;
Run

[Kurt_Bremser]

data test1_int (drop=_displaymonth);
set test1 (rename=(displaymonth=_displaymonth));
displaymonth = put(datepart(_displaymonth),yymmddn8.);
run;

Then use that in your join instead of test1.

[RW9]

Alternatively:

proc sql;
  create table WANT as
  select...
  from   TEST1 A
  full join TEST2 B 
  on      A.DISPLAYMONTH=input(B.DISPLAYMONTH,yymmdd8.);
quit;