LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2005, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 22 Jan 2005 15:40:06 +0800
Reply-To:   Littleinfo <littleinfo@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Littleinfo <littleinfo@GMAIL.COM>
Organization:   IMS Netvigator
Subject:   How to generate a report like this...

Dear all SAS-experts,

I've a table similar to Table 1 and would like to generate a report/table similar to Table 2. How can I do that in SAS if I've only got SAS/BASE?

Table 1 id segment indicator amount sales 10002 A @ 1,000 111 10003 B @ 20,000 333 10004 C 1 500,000 222 10005 D @ 555 444 10006 C 1 487,878 555 10007 D @ 5,555 666 10008 A @ 7,877 555 10009 C 1 45,556 666 10010 A @ 2,222 222 10011 B @ 12,345 111 10012 C @ 8,855 111 10013 D @ 7,777 333 10014 B 1 47,777 555 10015 A @ 5,588 444 10016 C @ 45 666

Table 2 Sales Segment Segment and with Indicator=1 A B C D A B C D 111 @ @ @ @ @ @ @ @ 222 @ @ @ @ @ @ @ @ 333 @ @ @ @ @ @ @ @ 444 @ @ @ @ @ @ @ @ 555 @ @ @ @ @ @ @ @ 666 @ @ @ @ @ @ @ @

Thanks in advances!

Best regards littleinfo


Back to: Top of message | Previous page | Main SAS-L page