Hi,
I'm having a dataset shown as below and all the variables are characters. I need a output in which TERM variable is having the values of both TERM and WORD. PLease help
Thanks in advance.
INPUT:
TERM WORD
Cold chills
Fever HIgh temperature
Headache dizziness
OUTPUT:
TERM
Cold
chills
fever
high temperature
Headache
dizziness
There are numerous ways to do this and it is fairly easily done, but I have to ask why? This does not make sense to me? 🙂
data have;
length TERM $50 WORD $50;
input TERM$ WORD$;
infile datalines dlm=',';
datalines;
Cold,chills
Fever,HIgh temperature
Headache,dizziness
run;
data want(keep=TERM);
set have;
array vars{*} TERM WORD;
do i=1 to dim(vars);
TERM=vars[i];
output;
end;
run;
its a question asked in interview.
I tried different ways but couldnt get the result.
will try this.
thanks a lot it worked..
Could you please explain how this worked out.
If you are not familiar with arrays, next code is same as @PeterClemmensen's code (but his code is flexible to deal with more than 2 variables):
data want(keep=TERM);
set have;
output; /* original TERM only */
term = word;
output; /* = WORD value */
run;
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.