Sas date format concatenating

I have two datatset Input12 and input18. Below is the code.

New12 dataset have variable score_date in format yymmn6.

   data new12;     set input12;     run;  

Now adding new variable score_date in dataset new18

%let score_date=201807;  data new18;  set input18;  format score_date yymmn6.;  run;  

After concatenating the dataset new 12 and new18 the date format is not in yymmn6.

 data new;   set new12 new18;   run;  

This is giving informat date for new12 and blank for new18 in new

 data new;   set new18 new12;   run;   

This is giving correct date format for new18 and blank for new12 in new.

Is there any reason for improper format after concatenating.

https://stackoverflow.com/questions/66019075/sas-date-format-concatenating February 03, 2021 at 07:28AM