Date: Thu, 21 Dec 2006 11:22:52 -0600
Reply-To: Yu Zhang <zhangyu05@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Yu Zhang <zhangyu05@GMAIL.COM>
Subject: Re: Linking 2 datasets
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
What I will do is to create a format using second dataset.
retain fmtname 'fname' type 'n';
proc format library=work cntlin=fmt;
place this code before any of your report procedures. then still use the
siteid in your report statements, like define, class with option
On 12/21/06, webonomic <firstname.lastname@example.org> wrote:
> I have 2 datasets:
> SiteID Q1 Q2
> 1 2.3 11002
> 2 4.7 39209
> 1 1.2 20983
> 3 2.2 40989
> 2 0.2 23492
> 4 0.7 10983
> 4 0.9 77549
> 3 2.1 29403
> 3 3.0 84302
> SiteID Name
> 1 Elmo
> 2 Ernie
> 3 Bert
> 4 Oscar
> (My real datasets have more observations and more variables.)
> Table 2 is only really used for Reporting purposes. Ie. to make
> reports more readable, I want to use the Name rather than the SiteID.
> What I usually do is create a Name variable in Dataset1 permanently and
> work with this permanent dataset. It works, but if the Name ever
> changes, I have re-run some programs to update the dataset. This does
> not seem ideal. I don't like hardcoding it into the dataset, nor would
> I want to create this variable everytime I want to do data analysis.
> So when I do Proc Tabulate or Proc Report and other procs on Dataset1,
> what methods are available to pull in the Name from Dataset2?
> Should I continue doing it the way I am used to? How do other people
> solve this?