topic Re: How To Create 20 Table Column wise in SAS ??? in SAS Programming

How To Create 20 Table Column wise in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 06:16:42 GMT

I want a output dataset have 20 tables like below come column wise..


1                    2                    3              4      5        6          7        8     ................................. 20

1*1=1             2*1=2                                                                                                             20*1=20

1*2=2             2*2=4                                                                                                              20*2=40

...                   ........

..                    .......

1*10=10          2*10=20                                                                                                         20*10=200


Like this i want output have 20 tables..

Please anyone write programme for this question ...   !!!!!!!

Re: How To Create 20 Table Column wise in SAS ???

PeterClemmensen — Thu, 27 Feb 2020 06:28:50 GMT

Like this?

data have(drop=i j);
   array c {20};
   do i = 1 to 10;
      do j = 1 to 20;
         c [j] = i*j;
      end;
   output;
   end;
run;

Re: How To Create 20 Table Column wise in SAS ???

andreas_lds — Thu, 27 Feb 2020 06:29:33 GMT

The words "dataset" and "table" are often used synonymous, so your request

@Mohan_Reddy wrote:

I want a output dataset have 20 tables like below come column wise..

does not make any sense.

Re: How To Create 20 Table Column wise in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 06:35:27 GMT

Almost correct....But in output we get after multiplication values only....we want 1*1=1 2*1=2 3*1=3 4*1=4 . .............20*1=20

1*2=2 2*2=4 3*2=6 4*2=8 .............. 20*2=40

...........................................................................

1*10=10 2*10=20 3*10=30 4*10=40 ..........20*10=200

Like this before multiplication format also come into output...i hope you understand my question....!!!

Re: How To Create 20 Table Column wise in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 06:50:49 GMT

Almost but output dataset have only after multiplication values.....
But we want before multiplication format also like
1*1=1 2*1=2 3*1=3 ...................20*1=20
.............................................................
1*10=10 2*10=20 3*10=.................20*10=200

like this we want output...so please help in a programme

Re: How To Create 20 Table Column wise in SAS ???

PeterClemmensen — Thu, 27 Feb 2020 07:02:46 GMT

I fail to see why, but there you go

data have(drop=i j);
   array c {20} $;
   do i = 1 to 10;
      do j = 1 to 20;
         c [j] = cats(j, '*', i, '=', i*j);
      end;
   output;
   end;
run;

Re: How To Create 20 Table Column wise in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 06:59:18 GMT

Almost ok but output dataset have only after multiplication values.....
But we want before multiplication format also like
1*1=1 2*1=2 3*1=3 ...................20*1=20
.............................................................
1*10=10 2*10=20 3*10=.................20*10=200

like this we want output...so please help in a programme

Re: How To Create 20 Table Column wise in SAS ???

PeterClemmensen — Thu, 27 Feb 2020 07:03:14 GMT

Please run my code above. Does exactly what you ask.

Re: How To Create 20 Table Column wise in SAS ???

Mohan_Reddy — Thu, 27 Feb 2020 07:07:38 GMT

Thankyou for your help....but in output we get values like 1*1=1 1*2=2 1*3=3..........................1*20=20

10*1=10 10*2=20 10*3=30.............. 10*20=200

but we want values in correct order like 1*1=1 2*1 3*1=3 ................................20*1=20

1*10=10 2*10=20 3*10=30....................20*10=200 Like this order wise we get table..please have a look on problem just modify that..how we get tables in order type...

Re: How To Create 20 Table Column wise in SAS ???

PeterClemmensen — Thu, 27 Feb 2020 07:09:12 GMT

Ok, I just changed the values around. Please try again.

How To Create 20 Tables in SAS ???

Mohan_Reddy — Fri, 28 Feb 2020 04:28:44 GMT

I want output dataset have 20 Tables like below.. in Horizontal wise

1            2          3    4    5    6   7  8  9     ........................             20
--          ---        --    --   --   --- -- -- ---   .......................              --
1*1=1       2*1=2                                                                         20*1=20
1*2=2       2*2=4                                                                         20*2=40
1*3=3       2*3=6                                                                         20*3=60
.......    ........                                                                      ..........
.......    ........                                                                      ..........
.......    ........                                                                      ..........
1*10=10    2*10=20                                                                       20*10=200

Like this i want 20 Tables in output dataset....

If anyone know how to get this please write a programme in SAS !!!

Re: How To Create 20 Tables in SAS ???

Kurt_Bremser — Fri, 28 Feb 2020 07:46:07 GMT

I moved this question back into the original thread with the same question. Pleade do not clutter the forum with unnecessary double posts, study the answers already given.

Re: How To Create 20 Table Column wise in SAS ???

Mohan_Reddy — Mon, 02 Mar 2020 04:03:24 GMT

I want output dataset have 20 Tables like below.. in Horizontal wise

1 2 3 4 5 6 7 8 9 ........................ 20
-- --- -- -- -- --- -- -- --- ....................... --
1*1=1 2*1=2 20*1=20
1*2=2 2*2=4 20*2=40
1*3=3 2*3=6 20*3=60
....... ........ ..........
....... ........ ..........
....... ........ ..........
1*10=10 2*10=20 20*10=200

Like this i want 20 Tables in output dataset....

If anyone know how to get this please write a programme in SAS !!!