Converting date for one variable for all file in one folder

[Phil_NZ]

Hi @qoit 

It works, finally. Just one more cocern.

So based on this code

 %if &&bdate_type&i.=C %then
    %do;
      if length(&var2del)=5 and upcase(&var2del) ne 'NA' then
       SASDATE = input(&var2del,32.)+'30DEC1899'd;
else SASDATE= input(&var2del,anydtdte32.);
%end;

it means that if &&bdate_type&i.=C and upcase(&var2del) = 'NA', the code

SASDATE= input(&var2del,anydtdte32.)

will generate a missing observation and the log will perform

Missing values were generated as a result of performing an operation on missing values.

when you process 

		format SASDATE yymmdd10.;

		if not missing(sasdate) and year(SASDATE) ne 2021 then
			fir_age = log(1+(2020-year(SASDATE)));

Am I correct?

I just want to make sure that such a log is not an error in this situation.

[qoit]

It is not an error. The character variable BDATE which you are trying to convert to numeric has missing values. This should suppress it :
input(&var2del,?? anydtdte32.)

[Phil_NZ]

Hi @qoit 

Thank you for your prompt reply.

I did change as you suggest, but it still exit the note "Missing values were generated as a result of performing an operation on missing values."

I mean, the character variable BDATE does not have missing values, it is just because the code 

SASDATE= input(&var2del,anydtdte32.)

will force the BDATE which has value "NA" will receive the "."

And then, the code 

		format SASDATE yymmdd10.;

		if not missing(sasdate) and year(SASDATE) ne 2021 then
			fir_age = log(1+(2020-year(SASDATE)));

will cause the note" Missing values were generated as a result of performing an operation on missing values."

It is my explanation, does it make sense or I am in another fallacy?

Warmest regards.

[qoit]

My apologies, it does make complete sense. Yes, I did notice the NA values. Since the NA can't be converted to numeric values, SAS leaves a note in the log that such values will just be assigned a "." (missing numeric value).
And, yes, ?? will not work as it is to suppress warning and errors. ?? will reset the _ERROR_ variable to 0.

[Phil_NZ]

Hi @qoit 

Thank you for such an interesting discussion! I get it now.

Many thanks and have a good day.