DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

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: 17,898

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;

 

View solution in original post


All Replies
Trusted Advisor
Posts: 1,398

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: 17,898

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;

 

Trusted Advisor
Posts: 1,398

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: 17,898

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.
Trusted Advisor
Posts: 1,398

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: 17,898

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: 9,687

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 306 views
  • 2 likes
  • 4 in conversation