topic Var Arrays in SAS Programming

Var Arrays

mick_g — Thu, 30 Jun 2011 21:33:24 GMT

I have a list of cities that I want to put into an array from a data set:

data test_array;

set city;

array a(*) city;

do i = 1 to dim(a);

put a(i) = city;

end;

run;

proc print no obs data=test;

run;

code above does not work

I would like the out put to look like this instead of ...

Baltimore Washington Hanover

Var Arrays

mick_g — Thu, 30 Jun 2011 21:41:29 GMT

sorry output to look like this

Baltimore Washington Hanover

instead of this

baltimore

washington

hanover

Var Arrays

Reeza — Thu, 30 Jun 2011 21:48:11 GMT

For the entire dataset?

You can do a proc transpose, but I'm guessing there's some other criteria as well?

Var Arrays

rtritz — Thu, 30 Jun 2011 23:36:30 GMT

Hello Mick_g,

Here is some code to get you started on transforming data from long to wide.

data city (keep = city);

set sashelp.zipcode (firstobs=2000 obs=2010);

run;

data test_array (drop = i city);

array a

$25. cty1-cty11;

do i = 1 to dim(a);

set city;

a(i) = city;

end;

run;

Rich

Var Arrays

Ksharp — Fri, 01 Jul 2011 05:41:36 GMT

using @ and / operator.

data _null_;
 set sashelp.class;
  put name @;
 if mod(_n_,3)=0 then put /;
run;





Alfred Alice Barbara

Carol Henry James

Jane Janet Jeffrey

John Joyce Judy

Louise Mary Philip

Robert Ronald Thomas

Ksharp