Date: Fri, 11 May 2012 11:22:40 -0400
Reply-To: Ya Huang <ya.huang@AMYLIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ya Huang <ya.huang@AMYLIN.COM>
Subject: Re: Need helps for creating table columns from a string
If the goal is to create an empty dataset with the charaters
in the string to be the variable names:
(A ))),B,%str(B ))),C,%str(C )));
retain &b .;
NOTE: The data set WORK.X has 0 observations and 4 variables.
NOTE: DATA statement used (Total process time):
On Fri, 11 May 2012 11:16:58 -0400, Ya Huang <ya.huang@AMYLIN.COM> wrote:
>When the possible charater in the string is known and limited,
>you can do it brute force way:
>2 %let a=ACBD;
>3 %put %sysfunc(tranwrd(%sysfunc(tranwrd(%sysfunc(tranwrd(&a,A,%str
>(A ))),B,%str(B ))),C,%str(C )));
>A C B D
>It's an ugly one-liner, but copy/paste is not a big deal for any
>editor now :-)
>On Fri, 11 May 2012 10:27:07 +0100, Yu Chang
>>I have the following string:
>>How to create a table like this:
>>(The table columns are come from the specified string)
>>A |B |C |D |E |F |G |
>>Thanks for your help.
>>If you are not the intended recipient, employee or agent responsible for
>delivering the message to the intended recipient, you are hereby notified
>that any dissemination or copying of this communication and its
>attachments is strictly prohibited.
>>If you have received this communication and its attachments in error,
>please return the original message and attachments to the sender using the
>reply facility on e-mail.
>>Internet communications are not secure and therefore Cambridge Assessment
>(the brand name for the University of Cambridge Local Examinations
>Syndicate, the constituent elements of which are CIE, ESOL and OCR [Oxford
>Cambridge and RSA Examinations is a Company Limited by Guarantee
>Registered in England. Registered office: 1 Hills Road, Cambridge CB1
>2EU. Company number: 3484466]) does not accept legal responsibility for
>the contents of this message.
>>Any views or opinions presented are solely those of the author and do not
>necessarily represent those of Cambridge Assessment unless otherwise
>>The information contained in this email may be subject to public
>disclosure under the Freedom of Information Act 2000. Unless the
>information is legally exempt from disclosure, the confidentiality of this
>email and your reply cannot be guaranteed.