topic Re: Format Help in SAS Programming

Format Help

anonymous_user — Thu, 25 Aug 2016 12:39:50 GMT

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 — Thu, 25 Aug 2016 12:47:58 GMT

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 — Thu, 25 Aug 2016 13:58:49 GMT

Alternatively:

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