Hello,
I'm getting teh folloiwng error: Invalid third argument to function SUBSTR
The variable cdcode is text and 14 characters long.
Here's my code:
data new;
set old;
length co $2 dist $5 sch $7;
co=substr(cdcode, 1,2);
dist=substr(cdcode, 3,7);
sch=substr(cdcode,8,14);
run;
Can you help me understand why I'm getting this message?
Thanks!
RTFM. Your code should read
sch=substr(cdcode,8,7); |
Thank you! Is it because it's the last part of the cdcode that it's 7 instead of 14?
from the reference manual
"Interaction:If length is zero, a negative value, or larger than the length of the expression that remains in string after position, SAS extracts the remainder of the expression. SAS also sets _ERROR_ to 1 and prints a note to the log indicating that the length argument is invalid."
Thank you!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.