Date:         Thu, 28 Feb 2008 15:33:44 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: using SAS to modify excel worksheet?
Comments: To: aaron_dubauskas@yahoo.com
In-Reply-To:  <d2d27e90-f7c1-4c74-8c14-4f045cb6951a@o10g2000hsf.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

/** Create Comments with IDS **/

Data Comments ;
Infile Cards ;
Input @1 ID @3 Comment $20. ;
Cards ;
1 Comment For ID 1
3 Comment For ID 3
5 Comment For ID 5
;
Run ;


/** Create RealData , You Will Need To Import Your Data From Excel**/
Data RealData ;
Do ID = 1 To 10 ;
  Output ;
End ;
Run ;


/** Add Comments To Your Data **/

Proc SQL ;
Create Table Need As
 Select Real.* , Comment.Comment
  From RealData As Real
       Left Join
       Comments As Comment
       On Real.ID = Comment.ID ;
Quit ;


Proc Print
 Data = Need ;
Run ;



Toby Dunn

"Don't bail. The best gold is at the bottom of barrels of crap."
Randy Pausch

"Be prepared. Luck is where preparation meets opportunity."
Randy Pausch


> Date: Thu, 28 Feb 2008 07:15:42 -0800
> From: aaron_dubauskas@YAHOO.COM
> Subject: Re: using SAS to modify excel worksheet?
> To: SAS-L@LISTSERV.UGA.EDU
>
> On Feb 28, 9:48 am, tobyd...@HOTMAIL.COM (toby dunn) wrote:
>> Aaron ,
>>
>> Easy way would be to read the spread sheat into SAS and either do a Join, Merge, or make it a format.
>>
>> Toby Dunn
>>
>> "Don't bail. The best gold is at the bottom of barrels of crap."
>> Randy Pausch
>>
>> "Be prepared. Luck is where preparation meets opportunity."
>> Randy Pausch
>>
>>
>>
>>
>>
>>> Date: Thu, 28 Feb 2008 06:44:30 -0800
>>> From: aaron_dubaus...@YAHOO.COM
>>> Subject: using SAS to modify excel worksheet?
>>> To: SA...@LISTSERV.UGA.EDU
>>
>>> 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
>>
>> _________________________________________________________________
>> Climb to the top of the charts! Play the word scramble challenge with star power.http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlin...- Hide quoted text -
>>
>> - Show quoted text -
>
> Can you elaborate a bit more?

_________________________________________________________________
Shed those extra pounds with MSN and The Biggest Loser!
http://biggestloser.msn.com/