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!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.