topic insert data set into 2-dimensional array in SAS Programming

insert data set into 2-dimensional array

tom12122 — Sun, 13 May 2012 18:59:35 GMT

Is there a possibility to easily insert data set into 2-dimensional array?

The data set can have variable column count and names.

Is there a way to reference columns by position instead by column name in data step?

Re: insert data set into 2-dimensional array

data_null__ — Mon, 14 May 2012 01:15:41 GMT

I would consider loading the data set into a hash object. Perhaps with an iterator so you can treat it like and array using the iterator methods FIRST NEXT and the rest.

Re: insert data set into 2-dimensional array

Ksharp — Mon, 14 May 2012 07:05:54 GMT

"Is there a possibility to easily insert data set into 2-dimensional array?"

Yes. EASY. but you only can hold one type variables, that means numeric or character .

data class;

set sashelp.class;

keep _numeric_;

run;

%let dsid=%sysfunc(open(class,i));

%let nobs=%sysfunc(attrn(&dsid,nobs));

%let nvar=%sysfunc(attrn(&dsid,nvar));

%let dsid=%sysfunc(close(&dsid));

data _null_;

set class end=last;

array a{&nvar] _numeric_;

array _a{&nobs,&nvar} _temporary_;

do j=1 to dim(a);

_a{_n_,j}=a{j};

end;

if last then do;

do m=1 to &nobs;

do n=1 to &nvar;

put _a{m,n}= ;

end;

run;

"The data set can have variable column count and names.

Is there a way to reference columns by position instead by column name in data step?"

Yes. There is a function to get it. Check it at SAS Documentation.

Ksharp