topic OUTPUT in New SAS User

OUTPUT

kngu022 — Sun, 16 Feb 2020 03:23:03 GMT

DATA work(KEEP = i s1 s2 n);
ARRAY a(*) x1-x5;
DO i = 1 to DIM(a);
a(i) = i**2;
END;
s1 = sum(x1-x3);
s2 = SUM(of x1-x3);
n = _N_;
RUN; 
PROC PRINT DATA=work;
RUN;

I have the code above. When I. put it in SAS and the result comes out like in the picture. Can anyone help me to understand this code and how it works please?

Thanks

Re: OUTPUT

Tom — Sun, 16 Feb 2020 03:31:25 GMT

What do think it is doing? What does each statement do? There are only 9, counting the RUN.

Re: OUTPUT

Kurt_Bremser — Sun, 16 Feb 2020 08:50:17 GMT

The code illustrates the difference of using x1-x3 as a formula (in the first sum() call) or as a list of variables (in the second sum() call) when the prefix "of" is used.

Re: OUTPUT

ed_sas_member — Sun, 16 Feb 2020 12:06:20 GMT

Hi @kngu022

If you execute the code step by step:

In a dataset named 'work' (also in the library named work ...) you initialize an array, which is a group of variables: the array name is a, it contains numeric variables x1, x2, x3, x4 and x5. As 5 variables have been referenced, the 'dimension' of the array is 5. You can now call 'x1' 'a(1)' and 'x2' 'a(2)', ... which is very practical in do loops. As these variables are new, the value is missing.

ARRAY a(*) x1-x5;

Then you use a do loop to compute the values of x1, x2, ... x5. The loop iterate from 1 to 5, which is the dimension of the array:
- i=1 -> a(1), which is x1 is equal to 1**2 so 1
- i=2 -> a(2), which is x2 is equal to 2**2 so 4
- ...
- At the end i = 6

DO i=1 to DIM(a);
	a(i)=i**2;
END;

Then you compute the sum of variables x1 minus x3 -> 1 - 9 = -8. This is completely different of the sum of variables x1, x2 and x3 -> 1 + 4 + 9 = 14. The keyword of is very important here.

s1=sum(x1-x3);

s2=SUM(of x1-x3);

And then, you put in the variable 'n' the iteration number. Here, it is the first observation, so _n_ = 1.

n=_N_;

Finally, you keep only the following variables in the data step (KEEP=i s1 s2 n) : i s1 s2 n

Re: OUTPUT

kngu022 — Sun, 16 Feb 2020 21:44:20 GMT

@ed_sas_member Thanks very much. Your direction is so so clear and easy to follow up.

Re: OUTPUT

ed_sas_member — Mon, 17 Feb 2020 08:05:35 GMT

Hi @kngu022

You're welcome!