How to create a custome data table from another data set.

[beenguyen]

Hi all,

Currently i having and data set as below:

Rank            Date             Value

1                  Jan2000        10%

2                  Jan2000        7%

3                  Jan2000        11%

1                  Feb2000        10%

2                  Feb2000        12%

3                  Feb2000        15%

if i want to print out an data with another format as:

Rank        Date Value

                Jan2000             Feb2000

1              10%                    10%

2              7%                      12%

3              11%                    15%

How can i code in SAS studio to receive the above table format. Thank you in advance and sorry for this kind of new learner question.

Sincerely,

[Reeza]

Do you want a table or output?

If output, look at proc report, if a table, look at proc transpose. I think there's a task in SAS studio.

[beenguyen]

Thank you Reeza, i will try both method to see how it goes.