topic Re: CASE function SAS DI studio in SAS Programming

CASE function SAS DI studio

ashna — Thu, 11 Oct 2018 18:23:29 GMT

Hi all,

I have variable that gets Numeric value most of the time but in certain conditions it can have character value. So I assigned Character to the variable while reading in the data from input file.

I used put function to this variable before I load data into Teradata table it works perfectly if I don't have any character value....if I have any character value that it gives me error.

Let say variable called Customer_name

Customer_name

3456

5678

9800

New

while mapping data in before step of teradata loader I used Put function as follows

 put(Customer_name, 12.)

This put function works perfectly if I don't have New in column. If I have New the following error occurs.

ERROR: Numeric format F in PUT function requires a numeric argument.... ERROR: Numeric format F in PUT function requires a numeric argument.... ERROR: Numeric format F in PUT function requires a numeric argument.

If change put function to

put(Customer_name, $12.)

it works perfect for along with New in column Customer_name but doesn't work without New in column.

Can some one help me with this

Re: CASE function SAS DI studio

ChrisNZ — Thu, 11 Oct 2018 22:06:37 GMT

Try this:

cat(Customer_name)

Don't forget to set the length.

Re: CASE function SAS DI studio

LinusH — Fri, 12 Oct 2018 06:16:04 GMT

@ChrisNZ I think that OP wants to get rid of chars, not being able to store them...?
As your post title say, use case with lets say ANYALPHA() function, if FALSE then INPUT() to the numerical target, else set MISSING.

Re: CASE function SAS DI studio

ashna — Mon, 15 Oct 2018 15:04:57 GMT

I tried to implement your suggestion,

case when anyalpha(customer_acct) then "." else customer_acct end

It works perfectly if I have New as value in customer_acct variable.

But if I don't have New as value in customer_acct variable it gives me following error

ERROR: Function ANYALPHA requires a character expression as argument 1.... ERROR: Result of WHEN clause 2 is not the same data type as the preceding results.

How to e-solve this?

Re: CASE function SAS DI studio

LinusH — Mon, 15 Oct 2018 20:17:51 GMT

Take a look at the generated code for the whole step. I recall there's a weakness here where you can't change the data type for a column, even if you are using a SQL SELECT. Try to use a different name on the source or the target column.

Re: CASE function SAS DI studio

ashna — Mon, 15 Oct 2018 21:09:58 GMT

Thanks,

Used Cat function as suggested by @ChrisNZ. That worked.