I need to put observations in five dataset into one dataset. I usually use macro and loop, each time with data step setting two dataset. I think this way is not efficient. Does anyone have a better solution to merge five dataset in one piece of code? The variables sometime do not have the same name. But they are the same thing. It is basically just putting observations in different dataset into the same dataset. Thanks! ... View more

I tried using proc univariate to calculate quantiles. I did 25, 50 and 75. But now I need 1/3 quantile and 2/3 quantile. What should I specify in the option to do this? Thanks. ... View more

I have variables asset, year. I want to rank asset by year, that is to rank asset within each year. There is no tie in the asset. I want to have four groups of equal sizes based upon the rank of asset.  I used proc rank procedure. I used groups=4 option. But in the result, the number of obs in each group is not equal. Why are they not equal? How to do this correctly?Thanks. ... View more

 I have a table of strings. I need to extract useful info from this table. There are tons of Chinese characters in this table. I want to remove these Chinese characters. What can I use? Thanks. ... View more

We have a panel data (longitudinal data) that every subject in it has different begin dates and end dates. We want to make a plot such that the times series for each individual can be visualized in a single plot. So we have each plot for each individual. And Each individual has several time series in the plot. The problem is that we want to add some notes about the individual's basic information right under the main title of the plot. We also want to add notes of the begin dates and end dates of every time series in it. Then the plot looks messy... Some individuals have tens of time series and others have only four or five. And we need to add notes to each time series in the plot. Or we want a way that this information can be read at some notes in the plot...Can anyone provide me with a clue of solving this problem? Thanks a lot. ... View more