Hi,   I have a problem with my y-axis in a sgplot. My code is:   proc sgplot data=mydata; vline informed / response=asked stat=mean limitstat=clm LEGENDLABEL = 'Average [95% CLM]' MARKERS LINEATTRS = (THICKNESS = 2); run; Can I set the y-axis to a fixed interval? The highest value is 12.5 now, but I would like the y-axis to go up to 20 (despite I do not have any observations here but it is to compare this graph with another one so the y-axis is similar). I tried both the "yaxis min=0 max=20" and "yaxis values=(0 to 20 by 1)".   Thanks.  ... View more

Hi,   I'm having trouble creating a new variable.  Imagine this fictive dataset:    ID     X     Y     Z 1     23     3     1 2     12     2     0 3     10     3     0 1     80     6     1 2     09     2     0 1     78     7     1 4     14     6     0 5     67     9     1 6     12     5     1 1     89     4     0   I want to create a new variable named 'count' that counts how many times the same ID number appears. Besides that, the new variable 'count' should only count those ID numbers with the variable Z = 1. So in this dataset the variable 'Count' would look like:   ID     X     Y     Z     COUNT 1     23     3     1     3 2     12     2     0     0 3     10     3     0     0 1     80     6     1     3 2     09     2     0     0 1     78     7     1     3 4     14     6     0     0 5     67     9     1     1 6     12     5     1     1 1     89     4     0     3   Thanks!    ... View more