topic Re: base sas in SAS Programming

QSUBSTR out of range error

mauri0623 — Thu, 07 Dec 2017 19:46:33 GMT

%if &file2 = I1099TY %then %do;
     %if &i = 2015 and &file2 = I1099TY and %qsubstr(&file3,1,5) = _2015 %then %do;
         %let pfile3 = _2016;
         %let sfile3 = %qsubstr(&file3,6,3);
         %let file3 = %trim(&pfile3&sfile3);

I get a warning stating that the %qsubstr is out of range. &file3 = _201706

EDIT: Note that @Reeza has modified the subject line to be reflective of the question. Please try and use a descriptive subject line in the future.

Re: base sas

Astounding — Thu, 07 Dec 2017 19:33:19 GMT

Yes, focus on this statement:

%let sfile3 = %qsubstr(&file3,6,3);

When &FILE3 is _201706, the sixth character is the second "0". If you start at that point, and attempt to take 3 characters, you will find that you run out of characters. There are only two characters left.

Re: base sas

mauri0623 — Thu, 07 Dec 2017 19:33:58 GMT

Sorry &file3 - _201507

Re: base sas

mauri0623 — Thu, 07 Dec 2017 19:35:08 GMT

So what is the fixing solution?

Re: base sas

Astounding — Thu, 07 Dec 2017 19:36:51 GMT

Well, you don't exactly say what you want to achieve here. If this gives you the right answer, it would be a possible solution:

%let sfile3 = %qsubstr(&file3,6,2);

Re: base sas

art297 — Thu, 07 Dec 2017 19:38:46 GMT

If you want everything from including and to the right of the sixth character just use

%qsubstr(&file3,6)

Art, CEO, AnalystFinder.com

Re: base sas

mauri0623 — Thu, 07 Dec 2017 20:03:16 GMT

Thank you much. This got rid of the warning.