The DIM function returns the number of literal elements in an array. It functions against multi-dimensional arrays as well as one-dimensional arrays. 1-dimensional array example DIM(array_name) Multi-dimensional array examples DIM(m_array) -> returns the number of elements in the first dimension of the array DIM5(m_array) -> returns the number of elements in the 5th dimension of […]
Tag: function
SAS DIF function – Comparing previous records
The SAS DIF function is another useful tool for operating on previous records. Lets say you want to know the difference in the last year’s revenue and this year’s revenue. Here is the data: Year Revenue 2001 10,000 2002 30,000 2003 60,000 2004 100,000 data revenue1; set revenue; Rev_increase=dif1(revenue); run; Year Revenue Rev_increase 2001 10,000 […]
Proc FCMP
A long time ago I figured out how to write functions for SAS using SAS/Toolkit. It was not a straightforward process and not very useful. In fact, someone recently asked me about it and I was unable to share much useful info. However, I did find pro…