Date:         Wed, 26 Nov 2003 10:31:09 -0800
Reply-To:     Todd A Goselin <tgoselin@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Todd A Goselin <tgoselin@YAHOO.COM>
Subject:      Vlookup feature in SAS?
Content-Type: text/plain; charset=us-ascii

Hello,

I have a dataset that looks like:

2003 0.03 0.0375

2004 0.00 0.02

2005 0.00 0.02

2006 0.00 0.02

2007 0.00 0.02

2008 0.00 0.02

2009 0.00 0.02

2010 0.00 0.02

2011 0.00 0.02

2012 0.00 0.02

2013 0.00 0.02;

All I want to do is use something like the Microsoft Excell Vlookup function that uses a keyword (in this case a Year, and get the next columns data.

Does anyone have an idea what to do? It looks like SAS does not have a vlookup feature.

My goal is to have something scan the table above and get the second column for a specific year.

Thanks,

Todd



---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now