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?
Content-Type: text/plain; charset="iso-8859-1"
/** Create Comments with IDS **/
Data Comments ;
Infile Cards ;
Input @1 ID @3 Comment $20. ;
1 Comment For ID 1
3 Comment For ID 3
5 Comment For ID 5
/** Create RealData , You Will Need To Import Your Data From Excel**/
Data RealData ;
Do ID = 1 To 10 ;
/** Add Comments To Your Data **/
Proc SQL ;
Create Table Need As
Select Real.* , Comment.Comment
From RealData As Real
Comments As Comment
On Real.ID = Comment.ID ;
Data = Need ;
"Don't bail. The best gold is at the bottom of barrels of crap."
"Be prepared. Luck is where preparation meets opportunity."
> 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
>>> Example of Excel spreadsheet
>>> Column A Column J
>>> 9694584 hold on
>>> 4095843 account being
>>> 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
>> 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!