topic If condition on multiple variables in SAS Programming

If condition on multiple variables

Scott86 — Fri, 17 Apr 2020 08:16:31 GMT

Hi everyone,

I have a dataset that I transposed and I want to do an if statement across multiple columns. I have attached a dummy version of the dataset (real once is a little more extensive but same concept). I have pasted my code below that I am trying to use but i get an error (pasted below). The column names in the array will be slightly different.

Any help is appreciated.

Thanks everyone

ERROR: Array subscript out of range at line 38 column 22.

data target;
set trans;

array pre {2} $8 m_202001 m_202002;
array post {1} $8 m_202003;
array time_period {3} $8 m_202001 m_202002 m_202003;

do i=1 to dim(time_period);
	if pre[i] = '' and post[i] = '' then target = 1;
    else if pre[i] ne '' and post[i] = '' then target = 2;
	else if pre[i] = '' and post[i] ne '' then target = 3;
	else target = 4;
end;

run;

Re: If condition on multiple variables

WarrenKuhfeld — Fri, 17 Apr 2020 08:33:23 GMT

Your index, i, goes from 1 to 3 and it indexes arrays with 1 or 2 elements. As you see, that does not work.

Re: If condition on multiple variables

Astounding — Fri, 17 Apr 2020 09:07:04 GMT

Because of the errors, it's impossible to determine what you are trying to accomplish. Here's a step you can take to eliminate the errors. But whether it accomplishes the right thing or not ... that's impossible to tell. Perhaps it will:

The current array definitions:

array pre {2} $8 m_202001 m_202002;
array post {1} $8 m_202003;
array time_period {3} $8 m_202001 m_202002 m_202003;

Legally, you could change it to:

array pre {3} $8 m_202001 m_202002 m_202002;
array post {3} $8 m_202003 m_202003 m_202003;
array time_period {3} $8 m_202001 m_202002 m_202003;