Date:         Fri, 15 Dec 2006 15:24:57 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: reorganizing dataset
In-Reply-To:  <200612142221.kBEJpKFx000596@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

siddharth_jain@MERCK.COM wrote back:
>
>Business changed the required last moment and now the database has to look
>like the new one. I have SAS 8.2 so I cant use catx(). Pls guide.
>
>
>Thanks in advance,
>Siddharth

I still think that you - as the programmer who has to do the hard
work here - ought to think in terms of a database design that is
*useful*, followed by data presentation that looks the way people
want to see it.  After all, how often do you have several people
who want to see the sme data, but in several different display
structures?  A good database design is the key to doing this in
an effective manner.

Now then.  Without SAS 9, all you have to do is use the standard
SAS operator to concatenate strings:  the double pipe  || .
As in the code you have already seen, you will need to convert
numbers to strings first, and then concatenate them.  If your
ID3 is a character variable, then use the code you have already seen,
without the PUT() functionality.

But I don't think you should do this in your primary database.
It will make further work on your variables ID1, ID2, ID3
that much harder.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Share your latest news with your friends with the Windows Live Spaces
friends module.
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk