Hi, this time i would like to calculate mean value from different variables (their highest value). Please, suggest a solution. data have; input ID age1 age2 age3 age4 age5 ; cards;1 1 3 6 9 2 2 6 2 3 4 4 3 7 2 9 0 0; run; the mean should be calculated from 9, 6 and 9 Thank You   ... View more

Hi, I have two datasets saved in sasuser library. Both are mostly different, however some of variables have the same names but they mean something different. Please, let me know how to merge them with automatic new variables names in one of datasets (for repeated variables names). My code at the moment is:   data a(rename=(E3=E33)); /*(here is the try for renaming one of known repeated names of variable) set sasuser.datA(rename=(E3=E3num E3num=E33 F1=F111 UW1=UW11)); E3 = put(E3num, 7.);   run; data datBA; merge sasuser.datB datA; by id; run; if age_group = '55 - 59 y' then delete; Moreover, the log says as well that an error occur when i try to delete some observations "ERROR 180-322: Statement is not valid or it is used out of proper order". Can you see any issues in my code? Thank you in advance for any response. ... View more

Hi there, So in my dataset I have variable ID which is repeated (only in name of it) for each participant. So for example ID=A-0-0082, it is repeated in rows due to fact that participant changed a (variable)job. So one row is A-0-0082 with job X and second row the same participant again A-0-0082 with job X, the next three rows are for next participant with id B-0-0011 with jobs X,Y,Z etc. So what i want to do is to select only rows from id (A-W-0-10-0-9999) <--- format of ID (A-W is a range, same for first number 0-10 range, same with third "value" 0-9999, what creates for example B-2-0012) with for example job X note: that i want to read all the rest variables like age, gender etc in new datasets. First time I have a such data and I don't know even how to start. Please, help me? is it even possible? I can't paste you dataset or code, sorry for that. ... View more