I am trying to use the value of one variable to reference another variable.
data have;
input one two three value$;
cards;
1 2 3 two
1 2 3 .
1 2 3 one
;
run;
data want;
input one two three;
cards;
1 . 3
1 2 3
. 2 3
;
run;
In row one the variable value = 'two', so I want the variable two to = null. In row value is null so there is no action. In row three value = 'one' so the variable one is changed to null. If anyone can help do this I'd appreciate it. I'm trying to use vvaluex() to do this but not getting there.
Cheers,
data have;
input one two three value$;
cards;
1 2 3 two
1 2 3 .
1 2 3 one
;
run;
data want;
set have;
array t(*) one--three;
do _n_=1 to dim(t);
if vname(t(_n_))=value then call missing(t(_n_));
end;
drop value;
run;
data have;
input one two three value$;
cards;
1 2 3 two
1 2 3 .
1 2 3 one
;
run;
data want;
set have;
array t(*) one--three;
do _n_=1 to dim(t);
if vname(t(_n_))=value then call missing(t(_n_));
end;
drop value;
run;
You may want to check case of your variable name and the value as variable names can be stored in mixed case.
data have; input One two three value $; cards; 1 2 3 two 1 2 3 . 1 2 3 one ; run; data want; set have; array a one two three; do i = 1 to dim(a); if vname(a[i]) = value then a[i]=.; end; drop i value; run;
Does not set the missing value on the third row because the case comparison doesn't match. Better might be:
if upcase( vname(a[i]) ) = upcase( value) then a[i]=.;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.