Dear all,   I am trying to create a histogram (with kernel and mean and std. deviation measurements) for a number of variables over time. So that we have percent on y=axis and years on x-axis. Plus I need to make sure that in the title of each histogam I have the description of each variable. Does anyone know how to do it?   For example, the data should look like this:   Variable     Description                  2005      2006       2007 X1              Current Asset 1           0.07        0.01       0.90 X2              Current Asset 2           0.86       0.2          0.03 X3              Current Asset 3           0.45      0.4           0.5   Thank you ... View more

I am trying to create a loop across variables in PROC SQL, but my code does not work. I know how to do it manually:   proc freq data=sashelp.class nlevels; tables name age sex; title 'Number of distinct values for each variable'; run; /* Using PROC SQL to count the number of levels for a variable. */ 　 　 proc sql; create table new1 as select count(distinct(name)) as namecount, count(distinct(age)) as agecount, count(distinct(sex)) as sexcount from sashelp.class; quit;   But I am trying to come up with the way to use the loop across variables, such as:   % let list = age height weight ;   data sql.count_test; set sashelp.class; array var_list(*) &list;   do i=1 to dim(var_list); variable=var_list(i); output; end;   proc sql; create table new2 as select count(distint(variable)) as variable_count from sql.count_test; quit;   Now, how the program should be modified if we also have a date component?   Thank you for your help! ... View more

Dear all, I have the following data:   Year         GVKEY        CDL          Date                 Exposure 2005            1                 5             02-12-2005           10 2005            2                 2              02-12-2005           10 2005            3                 1              02-12-2005           55   2006            1                 4              02-12-2006            20 2006             2                3              02-12-2006            40 2006            2                 3              02-11-2006            40 2006            2                 1              02-12-2006             10   I need to know the total and average exposure per year. But if the GVKEY = CDL, I only want to report one exposure for the latest date observed. That is, for 2006, it should be on 02-12-2006. So my final output should look like this:   Year         GVKEY        CDL          Date                 Exposure 2005            1                 5              02-12-2005           10 2005            2                 2              02-12-2005           10 2005            3                 1              02-12-2005           55   2006            1                 4              02-12-2006            20 2006            2                3              02-12-2006            40 2006            2                 1              02-12-2006            10   So I am not sure how to write this code. Of course, dates can vary. But this is an idea. And then I need to calculate total exposure and average exposure per each year.   Does anyone know how the code would look like? Thank you for your help.   Yelena ... View more