topic Re: CREATE VECTOR in SAS Programming

CREATE VECTOR

AlexeyS — Sat, 29 Aug 2015 07:57:50 GMT

Hello, i want create a vector of all options from vector of strings : i have to "multiply" every cell to other cell

example :

i have a variable of characters

i want to create the next variable

how i can do it?

thank you

Re: CREATE VECTOR

Tom — Sat, 29 Aug 2015 14:09:07 GMT

Normally in SAS you work an datasets not "vectors". So if we create your input as a single variable dataset.

data have ;

length letter $1 ;

input letter @@;

cards;

a b d e

;;;;

Then we can create your new single variable dataset from that using a DO loop and POINT= option on SET statement.

data want ;

length next_variable $2 ;

set have ;

do p=_n_+1 to nobs ;

set have (rename=(letter=next_letter)) nobs=nobs point=p ;

next_variable = cats(letter,next_letter);

output;

end;

keep next_variable ;

run;

Re: CREATE VECTOR

Ksharp — Sun, 30 Aug 2015 03:19:37 GMT

This question seems to be for SQL.

Code: Program

data have ;
length letter $1 ;
  input letter @@;
cards;
a b d e
;;;;
run;
proc sql;
 create table want as
  select cats(a.letter,b.letter) as new_letter
   from have as a,have as b
   where a.letter lt b.letter;
quit;

Xia Keshan

Message was edited by: xia keshan

Re: CREATE VECTOR

LinusH — Sun, 30 Aug 2015 10:40:33 GMT

Xie, agree thar SQL is a nice choice for this. But to comply withe requirement I think you need to change NE to GT.

Re: CREATE VECTOR

Ksharp — Sun, 30 Aug 2015 13:02:27 GMT

Opps. Thanks Linus. Code has been updated. I think ARRAY maybe is a better choice .

Re: CREATE VECTOR

LinusH — Sun, 30 Aug 2015 16:22:54 GMT

If the actual data set is large, yes. But for normal data I think SQL is easier.

Re: CREATE VECTOR

data_null__ — Sun, 30 Aug 2015 21:38:41 GMT

Maybe you want combination. Example straight out of SAS online documentation for LEXCOMB

data _null_; 
   array x[4] $3 ('a' 'b' 'd' 'e');
   n=dim(x);
   k=2; 
   ncomb=comb(n,k);
   do j=1 to ncomb;
      rc=lexcomb(j, k, of x);
      
put j 5. +3 x1-x2 +3 rc=;
      if rc<0 then leave;
      end; 
   run; 


    1   a b    rc=1
    2   a d    rc=2
    3   a e    rc=2
    4   b d    rc=1
    5   b e    rc=2
    6   d e    rc=1

Re: CREATE VECTOR

Ksharp — Mon, 31 Aug 2015 01:05:50 GMT

But if there is not order out there, SQL would NOT work , Like something:

-->

消息编辑者为：xia keshan

Re: CREATE VECTOR

AlexeyS — Mon, 31 Aug 2015 06:09:40 GMT

thank you, that what i need. can you please the meaning of of x

inside lexcomb? and what the meaning rc? thank you

Re: CREATE VECTOR

data_null__ — Mon, 31 Aug 2015 12:05:10 GMT

is a "SAS Variable List" meaning all variables in array x. Lookup LEXCOMB for meaning of "Return Code" for this function. Also lookup SAS Variable Lists.

Re: CREATE VECTOR

Tom — Tue, 08 Sep 2015 15:54:28 GMT

Looks like the new software is not displaying this code properly. It has converted (*) into a bullet instead of asterisk inside of brackets.