topic Re: create varariables form sas data in SAS Programming

create varariables form sas data

yonib — Wed, 05 Nov 2008 07:20:23 GMT

Hi all,
I have a question

If i have sas data that look like this:
name of table: a
vars: col1 col2

obs name gender

And also i have sas data like :
name of table: b
vars: col1 col2

obs: yoni m
aaa f
bbb m

What i want to do is to take all the the obs from table a and put then as vars on table b .

Does anyone knows how to do it?

thanks in advance

Re: create varariables form sas data

LinusH — Wed, 05 Nov 2008 11:33:15 GMT

You could use macro variables:

data _null_;
set a;
call symput('COL1',col1);
call symput('COL2',col2);
run;

proc datasets lib=work nolist;
modify b;
rename col1=&COL1 col2=&COL2;
quit;

/Linus

Re: create varariables form sas data

yonib — Wed, 05 Nov 2008 20:05:01 GMT

Hi Linus ,
Thanks for help !!