Date:         Wed, 6 May 2009 06:13:06 -0700
Reply-To:     Subha R <rsubha1686@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Subha R <rsubha1686@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Vlookup in SAS
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,
I am a new user to SAS.
I have two data sets say cell A and cell B. Cell A has 10 var and 1800
data points Cell B has 4 var and 33 data points.
Now some variables in  cell  A are categorical say education in 4
categories and i have some weights to it.. now by using proc means i
have saved the sum of each category in Cell B.
Now i am running some transformation for which i need both the data
sheets. But when i use SET statement the output contains only 33
variables(cos my cell B has 33 data points)..
I want it to run  for whole Cell A dataset...
i want some sort of VLOOKUP in excel ...Pls help me....


Regards,
Subha.R