Hello.  I have multiple datasets whose name has the following format: data_yyyymm.  For example, the names of the datasets are data_202211, data_202212, data_202301, and so on.  They all have same variables with year and month indicators in each dataset. I want to append these data so that I would have one master dataset that have all these datasets. I was thinking of using the following commands to work:   data masterdataset; set data_202211; do i = 202212  to 202307;       some kinds of commands for append end; run; I was not sure how I could make this code work so that I can have one master dataset.  Could anyone give me some suggestion? Thank you in advance for your time and help! ... View more

Hello everyone. I have a numeric variable of date of birth expressed in format of yyyymmdd (i.e. 19880731). I was wondering how I could calculate the age in, for example, 2023-01-01. I was thinking of converting the date of birth into some continuous number and get difference and divide by 365.25. However, I was not sure how I could convert the date of birth into a continuous value. I would really appreciate if anyone could give me some suggestion.   Thank you very much! ... View more

Hello everyone. I have panel data, and I have some individuals who have multiple observations in the same year. What I want to do is that I want to keep the last observation of those individuals with multiple observations in the same year. Visually, I want something like this… (I thought this would show better what I wanna do) Id   data   year  ->  Id   data   year 1     2    2009            1     3    2009 1     3    2009            1     2    2010 1     2    2010            2     1    2009 2     1    2009           2     3    2010 2     2    2010 2     3    2010   I was trying to use command like:   "Data …. ;   Set ….;  by ID year;   if last.ID; run;", but this would only leave last observation of the individual of the last year (assuming that I sorted by ID and year) and erase the previous year. I was wondering if you have a suggestion or idea to this issue..   Thank you very much for your help! ... View more