DATA Step, Macro, Functions and more

Complev ( Issue with space / NULL )

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Complev ( Issue with space / NULL )

Hi All,
Please can anyone give me a solution of the following code :

(1-(complev(field1,field2)/max(lengthof(field1),lengthof(field2))*100

With field1 value as 1
With field 2 value as NULL or space or no value in it.

As per my understanding it has to be (1-(1/1))*100 i.e 0 as output, please can anyone confirm if it is right, my colleague tried it and op was shown as 91.66, not sure how it is possible. How does sas work with space or null values while computing? If i have 1 and null complev should be 1 and max length as 1.

Thanks in advance.

Accepted Solutions
Solution
‎02-19-2018 11:55 PM
Super User
Posts: 2,512

Re: Complev ( Issue with space / NULL )

1. The function lengthof is not a SAS function

2. Your parentheses are unbalanced so we can't replicate your calculation

This returns 0:

data _null_;
  FIELD1='1';
  FIELD2=' ';
  DIS=(1-(complev(FIELD1,FIELD2)/max(length(FIELD1),length(FIELD2))))*100 ;
run;

View solution in original post


All Replies
Solution
‎02-19-2018 11:55 PM
Super User
Posts: 2,512

Re: Complev ( Issue with space / NULL )

1. The function lengthof is not a SAS function

2. Your parentheses are unbalanced so we can't replicate your calculation

This returns 0:

data _null_;
  FIELD1='1';
  FIELD2=' ';
  DIS=(1-(complev(FIELD1,FIELD2)/max(length(FIELD1),length(FIELD2))))*100 ;
run;
New Contributor
Posts: 2

Re: Complev ( Issue with space / NULL )

Hi Chris,

Yes thank you for the correction. Thanks for the clarification for output value.

Regards
Sreekar.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 102 views
  • 1 like
  • 2 in conversation