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
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.
Thanks, Reeza
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.