Prev: proc sql where clause with macro variable problem with index
Next: FYI: SAS 9.2 install on Ubuntu
From: rangoon rangoon on 17 Jun 2010 08:53
Hi All,

i would appreciate your help with regard to the following.

i have dataset that has multiple variables. i want to split the words
in each variable and put in different variables with a suffx.
lets say variables are X Y Z.
new variables for each variable: x1 -xn y1 -yn z1 - zn

below is an example with one variable(X)

Note: each variable has multiple records with different number of
words.

data have;
input x $ 1- 30;
datalines;
one two three four
new old
james hardley kent cathy samy
;;;
run;

data want;
x1 x2 x3 x4 x5;
one two three four
new old
james hardley kent cathy samy


Thanks.
Regards,
Rang
 | 
Pages: 1
Prev: proc sql where clause with macro variable problem with index
Next: FYI: SAS 9.2 install on Ubuntu