Hi rossu12,
I have put some code below which should answer your query. If anything is not clear let me know.
All the best.
Rafi
* Example dataset based on the information you gave;
DATA original;
DO base= 1 TO 10;
OUTPUT;
END;
RUN;
* Create new variable 'new' based on variable 'base', _N_ is the automatic macro variable which hold the value of observation number that is being processed from
input dataset (original), It can be used to count observation number as well;
DATA newds;
SET original;
new = (base*(_N_+1)) * (base*(_N_));
RUN;
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 use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.