topic Re: SAS array subscript out of range in New SAS User

SAS array subscript out of range

Gablz — Sun, 17 Oct 2021 12:46:53 GMT

We have the following problem. We want SAS to put the same value that is inside the last beruf variable that contains info into the next one if the control variables Übergänge and BERUFG_A_1 match. There are beruf1 to beruf 21 so 21 variables. If we use this code it says array subscript out of range.

LIBNAME WB66 'D:\WB66';
RUN;

DATA WB66.erwzus_1013; SET WB66.erwzus_1013;

array beruf (1:21) $ beruf1-character-beruf21;

do i = 1 to dim(beruf);
if Übergänge = 2 and BERUFG_A_1=1 and i = index then beruf{i} = beruf{i-1};
end;

RUN;

Re: SAS array subscript out of range

Tom — Sun, 17 Oct 2021 15:00:22 GMT

The messages in the log should show the value of I used when the error happened.

It should be happening when I=1 since you have beruf{i-1} in your code.

Change your DO loop starting from 1 to 2 if you want to do that.

do i = 2 to dim(beruf);

Re: SAS array subscript out of range

andreas_lds — Mon, 18 Oct 2021 05:27:14 GMT

Please post the complete log using "insert code", also note that "DATA WB66.erwzus_1013; SET WB66.erwzus_1013;" is always a very bad idea, if something went wrong in the step, you have to re-create WB66.erwzus_1013.

Re: SAS array subscript out of range

Gablz — Mon, 18 Oct 2021 11:52:07 GMT

Thank you! It works now 😄

Re: SAS array subscript out of range

Gablz — Tue, 19 Oct 2021 19:30:38 GMT

Hey 🙂
Thanks for your reply. I tried DATA WB66.erwzus_1013; SET WB66.erwzusneu; but it doesnt make a new file. Do you know what i could use instead? Or do i have to create an empty file first?

Re: SAS array subscript out of range

PaigeMiller — Tue, 19 Oct 2021 19:41:11 GMT

I tried DATA WB66.erwzus_1013; SET WB66.erwzusneu; but it doesnt make a new file.

Was there already a existing file named WB66.erwzus_1013??

Re: SAS array subscript out of range

Gablz — Tue, 19 Oct 2021 19:41:09 GMT

Yes there was and it will always get replaced

Re: SAS array subscript out of range

PaigeMiller — Tue, 19 Oct 2021 19:42:38 GMT

@Gablz wrote:
Yes there was and it will always get replaced

That's what your code is telling SAS to do. If you want a new file to be created, you need to use a file name that doesn't exist. For example:

DATA WB66.erwzus_1013new; 
SET WB66.erwzusneu;

Re: SAS array subscript out of range

Gablz — Tue, 19 Oct 2021 19:46:39 GMT

But i also want the program to use Data from an existing file so i want him to take the information out of WB66.erwzus_1013. If i do it that way SAS tells me the file doesnt exist

Re: SAS array subscript out of range

Gablz — Tue, 19 Oct 2021 19:48:59 GMT

Maybe thats a little bit confusing but there already is WB66.erwzus_1013 with information that i want to work with and i want the program to make a new file and he should put everything that i change into that file like a copy but with the changes

Re: SAS array subscript out of range

Tom — Tue, 19 Oct 2021 19:57:25 GMT

@Gablz wrote:
Maybe thats a little bit confusing but there already is WB66.erwzus_1013 with information that i want to work with and i want the program to make a new file and he should put everything that i change into that file like a copy but with the changes

The names of dataset(s) listed in the DATA statement are the target names. The names of dataset(s) listed in the SET statement are the source datasets.

The comment that triggered the discussion was that you should be very careful about using the same name in both places because if there is a problem then your source dataset might be lost.

Instead get in the habit of making a new dataset to and only read from the original dataset. The new dataset will have all of the data from the old datasets with any changes made to it in this data step.

data new;
  set old;
  *** more statements that manipulate the data ** ;
run;

Re: SAS array subscript out of range

Gablz — Tue, 19 Oct 2021 19:59:01 GMT

Oh okay i thought there was a command for that thank you 🙂

Re: SAS array subscript out of range

PaigeMiller — Tue, 19 Oct 2021 20:02:05 GMT

@Gablz wrote:
But i also want the program to use Data from an existing file so i want him to take the information out of WB66.erwzus_1013. If i do it that way SAS tells me the file doesnt exist

I think this is what you want

DATA WB66.erwzus_1013new; 
SET WB66.erwzus_1013;