Write and run SAS programs in your web browser

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

Reply
New Contributor
Posts: 2

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

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,

Grand Advisor
Posts: 17,327

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

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.

New Contributor
Posts: 2

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 190 views
  • 0 likes
  • 2 in conversation