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

beenguyen — Thu, 18 Aug 2016 03:30:23 GMT

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,

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

Reeza — Thu, 18 Aug 2016 04:21:15 GMT

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 — Thu, 18 Aug 2016 09:06:42 GMT

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