topic use IML in the proc sql in SAS/IML Software and Matrix Computations

use IML in the proc sql

Wes — Sat, 28 May 2011 08:48:39 GMT

i have dataset as following

now i have a question about usin IML in proc sql as the code below

in the code, RollGibbs is the code using IML dsIn is the data read

i can not understand why do this procedure?

please help me~plz

data zachary;
input id x;
cards;
1 4
1 2
1 3
2 3
2 4
2 5
2 4
3 5
3 8
;

%macro zachary(n);
%do i=1 %to &n;
proc sql noprint;
create table set&i as
select id,%RollGibbs(dsIn); as mean_x
from zachary
where id=&i
group by id;
quit;
%end;
%mend;
%zachary(3);

Re: use IML in the proc sql

Rick_SAS — Mon, 30 May 2011 19:37:26 GMT

I don't understand what the SQL code is trying to do. Is this some kind of resampling? Please describe in words what you are trying to accomplish, or provide the macro function that you are calling so that we can run it ourselves.

If this is a resampling problem, I would do it all in SAS/IML without bothering with SQL. For example, I'd read in the ID variable, use the UNIQUE function to get the numbers {1,2,3}, and then use RANDGEN to generate random numbers in the range 1:3. I can't tell yet how you are using the X variable.