topic Re: Is there a way to divide and entire row by a constant? in SAS Programming

Is there a way to divide and entire row by a constant?

drichmo1 — Sun, 28 Aug 2016 12:38:38 GMT

Hi I was wondering if there is a way to divide a row by a constant, for example, by 3?

Thanks,

David

Re: Is there a way to divide and entire row by a constant?

Shmuel — Sun, 28 Aug 2016 13:14:31 GMT

it is possible:

const = 3;

array num _NUMERIC_;

do over num; num = num / const; end;

Re: Is there a way to divide and entire row by a constant?

Reeza — Sun, 28 Aug 2016 13:14:01 GMT

And only because DO OVER is deprecated:

const = 3;

array num _NUMERIC_;

do i=1 to dim(num);
    num = num / const; 
end;

Re: Is there a way to divide and entire row by a constant?

Shmuel — Sun, 28 Aug 2016 18:21:23 GMT

Reeza, may I ask what do you mean by "deprecated" ?

I have tested the code, as wriiten originally with DO OVER and it worked without any syntax and even not a anote in the log.

As mutch as I know, DO OVER and DO ... FROM ... TO ... can't be used in same data step.

Is that the reason ?

Re: Is there a way to divide and entire row by a constant?

Reeza — Sun, 28 Aug 2016 18:57:38 GMT

No longer recommended.

For example - I can't find any reference to Do Over in 9.3/9.4 documentation.

It's still supported as legacy code.

Wow...this apparently was from V7 which is in 2000.

http://support.sas.com/techsup/notes/v8/1/780.html

Beginning with SAS OnlineDoc, Version 7-1, documentation for implicitly subscripted arrays and any related topics (e.g. DO OVER) has been removed. As noted in SAS Language: Reference, Version 6, First Edition, p. 297, implicit arrays are supported only for compatibility with previous releases of the SAS System. These obsolete features have been removed from the documentation to discourage their use in new program development.

Re: Is there a way to divide and entire row by a constant?

Shmuel — Sun, 28 Aug 2016 19:14:01 GMT

Reeza, Thanks a lot.

I'm still using SAS OnLine Doc. of 9.2 version and beeing in age of 70 explains it.

Re: Is there a way to divide and entire row by a constant?

Reeza — Sun, 28 Aug 2016 20:34:19 GMT

@Shmuel wrote:

I'm still using SAS OnLine Doc. of 9.2 version and beeing in age of 70 explains it.

👍🏽🙂

Re: Is there a way to divide and entire row by a constant?

Ksharp — Mon, 29 Aug 2016 01:42:11 GMT

It is IML thing. IML code is special for vector operation .