Invalid argument to function ...

Reply
Occasional Contributor
Posts: 8

Invalid argument to function ...

Hi,

 

I have got the following information in the log:

NOTE: Invalid argument to function YRDIF at line 21 column 18.

NOTE: Invalid second argument to function SUBSTR at line 26 column 9.

NOTE: Invalid second argument to function SUBSTR at line 27 column 9.

The lines 21 to 27 ar as below:

21 age_at_131015 = yrdif(birth_date, '13oct2015'd, 'act/act');

22 if age_at_131015 <5 then age_grp="0-4";

23 else if age_at_131015 <15 then age_grp="5-14";

24 else age_group="15+";

25 if substr(Indigenous_status, 1, 1)="A" or substr(Indigenous_status, 1, 1)="T" then Indig=1;

26 else if substr(compress(Indigenous_status), 1, 4)="NOTA" then Indig=2;

27 else if substr(compress(Indigenous_status), 1, 4)="NOTS" then Indig=9;

 

What I did wrong?

 

Thanks.

 

qinghe

Super User
Posts: 19,194

Re: Invalid argument to function ...

Most likely you forgot to account for missing values. 

Birth_date is probably missing, and indigineous status is less than 4 characters, or missing, so trying to take a substring of length 4 isn't possible.

 

If you look closer at your log, it will show sample data points and you can verify the value of birth_date and/or indigineous status to verify my guess.

Occasional Contributor
Posts: 8

Re: Invalid argument to function ...

Thanks, Reeza

Ask a Question
Discussion stats
  • 2 replies
  • 545 views
  • 0 likes
  • 2 in conversation