Tabulate large quantity of data

[deleted_user]

Hi, i am newbies to SAS software. I have a question on whether how to do the dataset procedures for below?

A/c month year amt
123 1 2006 100
123 2 2006 100
123 3 2006 100
123 4 2006 100
456 2 2006 100
456 5 2006 100

How to tabulate the data above into such a way as below?

Year 2006
A/c 1 2 3 4 5 (Month)
123 100 100 100 100
456 100 100

[deleted_user]

I would recommend going on a basic SAS course. See SAS training web site.