use IML in the proc sql

Wes — Sat, 28 May 2011 08:49:03 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

SPR — Mon, 30 May 2011 18:16:46 GMT

Hello Wes,

This code contains formal error:
select id,%RollGibbs(dsIn); as mean_x
It is necessary to run %RollGibbs(dsIn) in separate datastep and then combine output
with zahary.

Sincerely,
SPR

topic Re: use IML in the proc sql in SAS Procedures

use IML in the proc sql

Re: use IML in the proc sql