LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (December 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 16 Dec 2004 12:39:25 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: SQL Question

Scott wrote: > Hi, > > I want to print the concatenation of a bunch of numeric variables > using SQL. > > Test Data: > > data one; > length x1-x10 8; > array x{*} x1-x10; > do i=1 to dim(x); > x{i}=i; > end; > run; > > Desired Output: > > i x > --------------------------- > 11 1 2 3 4 5 6 7 8 9 10 > > Can this be easily done in SQL, perhaps with some sort of nested > query?

* version 9 catx() function works like a charm; * however, data step array syntax [of...] is not understood by SQL :( ;

data one; length x1-x10 8; array x{*} x1-x10; do i=1 to dim(x); x{i}=i; end; mush = catx (' ', of x1-x10); run;

proc sql; create table two as select i, mush, catx (' ', x1,x2,x3,x4,x5,x6,x7,x8,x9,x10) as dude from one ; quit;

-- Richard A. DeVenezia http://www.devenezia.com/


Back to: Top of message | Previous page | Main SAS-L page