Date:         Wed, 3 Feb 2010 15:36:15 -0600
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Excel formattting
Comments: To: SAS User <sasuser2010@googlemail.com>
In-Reply-To:  <177c044c-3274-4206-b09b-2a4774b87e5e@r19g2000yqb.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Look into PROC REPORT, that will do the subtotaling that you're looking for.

Otherwise you might want to give more information to the list as to how
you're getting things into excel.

-Joe

On Wed, Feb 3, 2010 at 11:16 AM, SAS User <sasuser2010@googlemail.com>wrote:

> Hi
>
> Is this the right group to post a question about formatting an Excel
> spreadsheet?
>
> I have two questions...
>
> 1. I am looking for some simple examples because I am a SAS novice on
> how to manipulate excel sheet formatting. How can I adjust the
> background colour for a colum of data.
>
> 2. Also in my original data set my data is like this where col3 is a
> sum of col2 by col1
>
> col1   col2 col3
> AAA  1      4
> AAA  1      4
> AAA  2      4
> BBB  1      5
> BBB  3      5
> BBB  1      5
>
> I would like this data to appear in my spreadsheet like this
>
> AAA  1
> AAA  1
> AAA  2
>         --
>         4
>
> BBB  1
> BBB  3
> BBB  1
>         --
>         5
>
> ..but I am not sure if I need to do something with source dataset or
> in excel after it has been imported?
>
> Could I have some advice please?
>
> Thanks
>