Array - how to get variable name, not value of variable

ucdcrush — Tue, 18 Dec 2012 18:01:30 GMT

Hi all, I am trying to use an array with a loop to automate a process of marking rows for keeping.

I have a variable called "table" which contains output from a proc freq crosstab, so it contains variable names, e.g. "sex-1*county" "race-1*county".

Those same variables (sex-1 and race-1) are also variables in that same table, i.e.

---

table sex-1 race-1

sex1*county . .
sex1*county 1 .

race1*county . 1
race1*county . .

---

data attempt;

set mytable;

array vlist sex-1 race-1;

do i = 1 to dim(vlist);

if index(table,vlist{i}) then

if vlist{i}=1, keepme=1;

end;

drop i;

run;

The problem with this is that when I search using INDEX, I believe SAS is using the value of the variable for that row, and not the variable name itself. Sorry for the long winded question, is there a way to return the array element as a text representation of the variable name, rather than the value of that variable in that row?

Thanks.

Re: Array - how to get variable name, not value of variable

Reeza — Tue, 18 Dec 2012 18:10:29 GMT

use the vname function.

vname(vlist(i));

Re: Array - how to get variable name, not value of variable

ucdcrush — Tue, 18 Dec 2012 18:15:23 GMT

So simple - Thank you!

topic Array - how to get variable name, not value of variable in SAS Programming

Array - how to get variable name, not value of variable

Re: Array - how to get variable name, not value of variable

Re: Array - how to get variable name, not value of variable