BookmarkSubscribeRSS Feed
beenguyen
Calcite | Level 5

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,

2 REPLIES 2
Reeza
Super User

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
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 811 views
  • 0 likes
  • 2 in conversation