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 (February 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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/


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