Hello, I would like some help in subtracting multiple variables in an observation from another.   GEO   YEAR   SEX   Total   AG_1  ....... AG_100 0199   2015    1         3543    32 ..............564 0101   2015    1         9764    42...............454 6099   2015    1         1356    87...............457          0199   2016    2         9878    77 ..............564 0101   2016    2         6565    65...............454 6099   2016    2         1111    22...............457       0199   2017    3         7865    11 ..............564 0101   2017    3         2343    22...............454 6099   2017    3         5376    83...............457         For each year and each sex, I would like to subtract the Total and AG_1 to AG_100 variables from the GEO 0199 and 0101. I would also like to set all 6099 Total and AG_1...AG_100 variables to 0 after.   Any help would be greatly appreciated. Many thanks!   ... View more

Hello,   I have 20 different files (over 100 thousand records each), in each file, I want to generate a randomly generated number ID, and make sure that there are no duplicates across the years. My solution is to generate the random numbers for first file, then put those in a master list, then generate random numbers for the second file, check the master list to ensure those numbers don't already exist, if they do, replace, and add all the random numbers to the master list, then generate random numbers for the 3rd file and so on...   Is there an easy way of programming this? Are there procedures that are meant for this kind of process?   Thank you 🙂     ... View more