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

Solved
Occasional Contributor
Posts: 9

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

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

Thanks,

David

Accepted Solutions
Solution
‎08-28-2016 11:03 AM
Super User
Posts: 23,758

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

And only because DO OVER is deprecated:

``````const = 3;

array num _NUMERIC_;

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

All Replies
Posts: 1,837

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

[ Edited ]

it is possible:

const = 3;

array num _NUMERIC_;

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

Solution
‎08-28-2016 11:03 AM
Super User
Posts: 23,758

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

And only because DO OVER is deprecated:

``````const = 3;

array num _NUMERIC_;

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

Posts: 1,837

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

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 ?

Super User
Posts: 23,758

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

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.
Posts: 1,837

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

Reeza, Thanks a lot.

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

Super User
Posts: 23,758

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

Shmuel wrote:

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

👍🏽🙂

Super User
Posts: 10,784

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

It is IML thing. IML code is special for vector operation .
☑ This topic is solved.