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>
Subject: Vlookup in SAS
Content-Type: text/plain; charset=ISO-8859-1
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....