Folks,
I currently have a dataset with 400 variables for 1,000,000 indivduals. I've been given a list of totals for certain variables however, the names are different to what's in my dataset.
Therefore, I would like to sum each of my variables in order to create a total for each variable, so going from 1,000,000 plus cases to just 1 for each varaible, with the 1 being the sum of all cases.
Each of the variables in my dataset have different names, but also there are character variables in it also.
Would anyone be able to suggest a work around for what I wish to do, or perhaps a simpler method to what I've proposed?
Kind regards,
Sean