I have a matrix (let's call it D) with 20 rows (+ column name) and 2 columns. The matrix has been sorted in a particular way, and I want to read the first of every 4 values in the the first column to another matrix. The following code worked on a small "test" dataset (small enough that I could check the results manually), but is there a reason it could produce wrong results (for example, read a number twice from a particular set of four, but zero times from another set)?
In other words, does anyone see anything wrong with this code? Is there a better way of doing what I have done here?
Use this. It uses the DO function to generate the sequewnce {1, 5, 9,...}:
t_row = do(1, nrow(D), 4);
T = D[t_row, 1];
Have you considered using the var _n_ along with a divisibility function I believe it is called MODZ () ??
Use this. It uses the DO function to generate the sequewnce {1, 5, 9,...}:
t_row = do(1, nrow(D), 4);
T = D[t_row, 1];
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.