How to create in a single column values in to diff tables..?

deleted_user — Mon, 01 Oct 2007 12:27:10 GMT

i have data table like this with brand_cd field
Brand_cd
12
13
14

i want output like this(Different tables)

Brand_cd1(one table)
12
Brand_cd2(second table)
13
Brand_cd3(third table)
14

Re: How to create in a single column values in to diff tables..?

Anitha_SAS — Thu, 04 Oct 2007 10:18:13 GMT

Example:

/* sample data set with 3 observations */
data a;
Brand_cd=12;output;
Brand_cd=13;output;
Brand_cd=14;output;
run;

/*macro to output line into new table*/
%macro test(currTable,index);
data &currTable;
set a(firstobs=&index obs=&index);
output;
run;
%mend test;

/* invoke the macro */
%test(Brand_cd1,1);
%test(Brand_cd2,2);
%test(Brand_cd3,3);

topic How to create in a single column values in to diff tables..? in ODS and Base Reporting

How to create in a single column values in to diff tables..?

Re: How to create in a single column values in to diff tables..?