BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sreekar
Calcite | Level 5
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.
1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

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

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

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;
Sreekar
Calcite | Level 5
Hi Chris,

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

Regards
Sreekar.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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