Hi,   is it possible for me to create an array calling say 150 variables (50 have similar prefix so three with Ax Bx Cx Yx ... Ap Bp Cp Yp... As Bs Cs Ys) and then make a macro within a do group? Then use that %let in the next data step?   Data work.question;       set ABCY;             array ques(*) A: B: C: Y: ;                    do i=1 to dim(ques);                    if ques(i) then do                    %let county=coun(i);  end;  run;   Any help on this or suggested reading for this would be greatly appreciated. Thank you so much for your time! ... View more

Hi,   I created a number of numeric variables (which calculate based on previous variables) and all but one is displaying. I used a putlog statement to see what was happening on the back end and the variable and corresponding observations are being displayed appropriately in the log, BUT are displaying in the results as a missing number. Any suggestions on how to trouble shoot this?   Thank you for any help and your time - ... View more

Hi,   I am working with a SAS dataset and am creating new variables based on previous VARs. I would like to create a new VAR which holds the sums of another column based on the following: 10 obs, #10 of the NewVar=#10 of OldVar #9 of NVar= #9+#10 OVar #8 NVar=#8+#9+#10 OVar .... and so on. So the total sum of the column will actually be Obs 1 of the New Var. Does anyone know how to sum backwards. I have been trying to wrap my head around this without changing the sort of the set or exporting and I would like to be able to do this by calling Vars rather than using the actual numbers to calculate, so I can use this in the future quickly.   Thanks for any help and suggestions you might have!   ... View more

Good afternoon,   I have a VAR which I have applied a format to assigning many observations (100 plus) to a single observation. Think along the lines of- if you live in Washington State you live in the NorthWest. So the trouble I am having is the Northwest is a number 002 and (the short of the long of it is) it is not an option to change the format. Is there a way to apply a second format over the first, after the first has been applied? Is there a different way I should be thinking about this?   Thanks for any help,     ... View more

Hi,   I am merging two data sets and I am creating two Vars based on the first. last. by groups. Everything is merging fine, the newly created Vars and totaling fine, but my output is only displaying the totals or rather the final observation from each by group. I would like all the observations within each by group displayed in addition to the total and I know there is a way to do this but I can not find it in my notes or online anywhere.   My code is pretty basic: Data set; merge one two; by animal name age;   if first.age then do;         totpounds=0; end; totpounds+pounds; if last.age output;   run;   These are dummy Vars but basically that's the idea. Any help would truly be appreciated.   Thank you! ... View more