Hi,
Many thanks Helen and Olivier. I used Helen's instruction for Enterprise Guide, and it did work for that simple table (I use only the guide at this moment and do not understand programming code yet).
I was actually struggling to create a table which is bit more complicated than the table that I provided before.
Is there a way to to create two rows of heading in SAS table outputs (as one can create in Excel)? I would like to convert Table 1 below to Table 2, for example.
I would like to have two rows of heading in Table 2, for example, one with No.1., No. 2, etc. And another row, under each of these No.1, No.2, with headings of dates (such as 1 Jan, 2Jan, 3Jan, etc). And my data will have columns of US$ for each of days (1Jan, 2Jan..) under No1, No.2, against time period.
Table1 (From this table)
ID Date Time(AM) US$
No. 1 1-Jan-06 9 200
No. 1 1-Jan-06 10 300
No. 1 1-Jan-06 11 450
No. 1 2-Jan-06 9 150
No. 1 2-Jan-06 10 160
No. 1 2-Jan-06 11 200
No. 1 3-Jan-06 9 144
No. 1 3-Jan-06 10 122
No. 1 3-Jan-06 11 500
No. 2 1-Jan-06 9 235
No. 2 1-Jan-06 10 214
No. 2 1-Jan-06 11 145
No. 2 2-Jan-06 9 254
No. 2 2-Jan-06 10 789
No. 2 2-Jan-06 11 100
No. 2 3-Jan-06 9 500
No. 2 3-Jan-06 10 650
No. 2 3-Jan-06 11 450
Table 2 (to this table)
Time(AM) No.1 No. 1 No. 1 No. 2 No. 2 No. 2
1-Jan-06 2-Jan-06 3-Jan-06 1-Jan-06 2-Jan-06 3-Jan-06
9 200 150 144 235 254 500
10 300 160 122 214 789 650
11 450 200 500 145 100 450
If one could create a unique column headings by picking names from from two columns. For example, to create a variable name 'No.1 1Jan', 'No1 2Jan' by combining No.1 and dates. Does it make sense?
Many thanks.
... View more