topic Re: Case statement using proc SQL with missing function in SAS Programming

Case statement using proc SQL with missing function

Akshaya_1397 — Thu, 25 Aug 2022 15:32:52 GMT

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?

Re: Case statement using proc SQL with missing function

Tom — Thu, 25 Aug 2022 15:39:34 GMT

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?

Re: Case statement using proc SQL with missing function

Kurt_Bremser — Thu, 25 Aug 2022 17:21:19 GMT

Maxim 3: Know Your Data.

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

Re: Case statement using proc SQL with missing function

Akshaya_1397 — Fri, 26 Aug 2022 02:30:54 GMT

Thankyou sir it helped me