Case statement using proc SQL with missing function

[Akshaya_1397]

Proc SQL;
Create table duerw as
Select
Monotonic() as I'd,
Case
When missing('Reputational count'n) then ' '
Else put('Reputational count'n,mmddyy10.)
End as dtdate length10
From processdata;
Quit;

In this above code the reputational code doesnot have value in the input file even thought the case statement doesnot stops at the first case and moves to the second step and gives the error as

Error:Numeric format MMDDYY in put function requires a numeric argument.
Can anyone help me on this error?

[Tom]

The variable is character and the code expected it to be numeric.

Run a PROC CONTENTS on the input dataset, processdata, and check what type of variable you actually have.

What process created the input dataset?

[Kurt_Bremser · Accepted solution]

Maxim 3: Know Your Data.

Run a PROC CONTENTS on processdata and see what it tells you about the variable.

[Akshaya_1397]

Thankyou sir it helped me