Date:         Thu, 28 Feb 2008 06:44:30 -0800
Reply-To:     aaron_dubauskas@YAHOO.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         aaron_dubauskas@YAHOO.COM
Organization: http://groups.google.com
Subject:      using SAS to modify excel worksheet?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

I am working on a project where I need to look through a column of
account #'s in a file realdata.xls. If an account # that is part of a
list of several hundred is found within that column, I would like to
write comments specific to an account # in the same row of an adjacent
column.

Example of Excel spreadsheet


Column A                                                 Column J
9694584                                                  hold on
account
4095843                                                  account being
charged
3945850

I would obviously have to pre-enter all the comments for each specific
account in any code I write, I am just not sure of the basic code to
do this, or if it is even possible. Any help would be greatly
appreciated.

Aaron