xcen > it dear forumers, I'm running version 9.2 and need to draw with sgplot a bar-line plot where the line is accounted for by the first axis. the two plots have very different scales. I don't need actually to have a second axis for the bars as I would add the datalabel above each bar. I learned through this forum that it is not possible by coding within the sgplot itself but I was wondering if there is any solutions involving GTL. Even a solution with sgpanel would be probably fine. any suggestions is greatly appreciated ... View more

Hi, I have a variable, pattern, that is a sequence of 12 zeroes and/or ones. These indicate the presence or absence of a condition in twelve months. what I would like to do is to flag different kinds of pattern according to whether there is an uninterrupted subsequence of ones filled with only zeroes. for instance I want to flag with 'b' any sequence of 1 followed by only zeroes like: 100000000000 110000000000 111000000000 and so on. with 'f' any sequence of final zeroes like 000000000001 000000000011 000000000111 .... with 'm' a sequence of ones in the middle like: 000001000000 000001100000 000011100000 ..... and with 'o' all other sequences, all zeroes or any mixed sequence of 0 and 1 like: 110001000000 111100000111 101011100100 .... Any suggestion for a as simple solution as possible? thank you very much in advance ... View more

xcen > it dear all, I have a dataset with several monthly occurrences for each individual. since I want to regress x(t) on x(t-1) and x(t-12) I have to create these lagged variables for each individual. the code that I'am using is: proc sort data=ds; by code date; run; proc panel data=ds; id code date; lag x(1 12) / out=ds1; run; (I might use proc expand instead of proc panel) however since there may be missing observations not for every individual the series is uninterrupted. for instance in the following example  for individual a  the months of january and july 2007 are missing. in this case I would like the lagged value for x is missing for february 2007 and august 2007 code date x x_1 a dec06 1 . a feb07 2 . a mar07 3 2 a apr07 4 3 a may07 5 4 a jun07 6 5 a aug07 7 . a sep07 8 7 a oct07 9 8 a nov07 10 9 a dec07 11 10 a jan08 12 11 the code above instead fills in the value with the previous observation within the same code regardless of the date. should I merge the data with the list of uninterrpted dates in a way to obtain beforehand the missing for the lacking observation or is there any way to get the results? by the way I'm working with hundred of thousands of observation and proc panel takes a while to get the results, so I'm looking possibly for a more efficient solution. I would appreciate any suggestions. thank you very much in advance ... View more