topic case when understanding in SAS Programming

case when understanding

Babloo — Tue, 27 Feb 2018 20:50:04 GMT

Appreciate if some of you help me understand the meaning of the following case when statement.

case when upcase(DOMAIN)='NL' then '6131300'n 
     else '6231300'n 
end  as COMMISSION_AMT format=nlnum18.5

Re: case when understanding

LinusH — Tue, 27 Feb 2018 10:24:18 GMT

You are not stating what it is you don't understand, but my guess the

'6131300'n

stuff. It seem that you have source colunms with those names, hence the use of the n literal. Otherwise it would be interpreted as a string.

Re: case when understanding

Babloo — Tue, 27 Feb 2018 10:29:02 GMT

yes, we've a source columns as follows. Could you please tell me what that case when statement will do?

'6131300'n

Re: case when understanding

Kurt_Bremser — Tue, 27 Feb 2018 10:34:39 GMT

It either assigns the value of '6131300'n or '6231300'n (you should really get rid of such extremely stupid variable names three days before yesterday) to the newly created variable, depending on the condition.

Re: case when understanding

RW9 — Tue, 27 Feb 2018 11:04:28 GMT

The n after the string means the string is a named literal. Named literals are used when dealing with poor data sources (such as Excell) where variable names are not compliant with SAS standards. So in the case given variables cannot start with a number or special character, hence 6 is not a valid first character of a variable name. To access these variables, the named literal is given and SAS internally converts this (or uses it) to access that data.

Whilst this is available and can be used to bring data into the SAS system, once it is in the SAS system it is highly recommended to give them SAS conformant variable names to remove this need for named literals.

Re: case when understanding

Tom — Tue, 27 Feb 2018 20:53:57 GMT

Create a variable named COMMISSION_AMT whose value depends on the value of DOMAIN. When DOMAIN has the value 'NL' then use the value from the '6131300'n variable otherwise use the value from the '6231300'n variable. Attach the display FORMAT of NLNUM18.5 to the new variable.