topic program execution in SAS Programming

program execution

SAS_inquisitive — Tue, 13 Sep 2016 20:52:52 GMT

I wonder how this program executes?

data want;
	set have1;
	by var1 var2;

	do n = 1 to nobs;
		do m = 1 to mobs;
			set have2 point = n nobs = nobs;
			set have3 point = m nobs = mobs;

			output;
		end;
	end;
run;

Re: program execution

Tom — Tue, 13 Sep 2016 21:18:11 GMT

I would recommend making three datasets with just a few observations each and see for yourself. Try putting a PUT statement before the OUTPUT statement. That is especially useful for looking at the values of M, N and _N_ which will not be in the WANT dataset.

Re: program execution

Kurt_Bremser — Wed, 14 Sep 2016 05:52:35 GMT

This seems to do a complete cartesian join over all three datasets, in a very complicated and inefficient manner. Would need some test data to verify that.