Date: Thu, 29 Aug 2002 15:45:39 -0400
Reply-To: "Nevseta, Floyd G" <Floyd.G.Nevseta@BANKOFAMERICA.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Nevseta, Floyd G" <Floyd.G.Nevseta@BANKOFAMERICA.COM>
Subject: Re: second simlpe question
Content-type: text/plain; charset=iso-8859-1
This does the trick. Try it.
data test;
length new $ 35;
input values $20.;
new = '"' || trim(tranwrd(values, ',', '","')) || '"';
cards;
0201,0101,0401
38289
;
run;
Floyd
-----Original Message-----
From: miranda [mailto:mixiao@UCLA.EDU]
Sent: Thursday, August 29, 2002 2:52 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: second simlpe question
Hi,
I have a simple dataset like below, I would like my new vlaues like this
"0201","0101","0401"
"38289"
;
data test;
input values $20.;
cards;
0201,0101,0401
38289
;
Does anyone know how to translate it?
Thanks.
|