Hi there,   i want to use the export funtion while doing regression analyses as follows:       ODS TAGSETS.EXCELXP     file='H:\Bildung_&x._mitAbi.xls'     STYLE=minimal     OPTIONS ( Orientation = 'landscape'     FitToPage = 'yes'     Pages_FitWidth = '1'     Pages_FitHeight = '100' );   It is part of an big analysis macro. Is there a way that i can tell SAS that the "&x." in "file='H:\Bildung_&x._mitAbi.xls'" is actualy a macro variable? Its going to be a realy big number of regression analyses and i realy dont want to name the files manualy.   Best regards, Tom ... View more

Dear SAS-Community,   i have a question for you.   I have data in the structure you can see on the left side. I want it to be summarized by the ID, like you can see on the right side.   ID   COUNT          ID   COUNT_sum 1        3       ->      1         3 1        1       ->      1         4 1       12      ->      1        16 1        0       ->      1        16 1        2       ->      1        18 2        0       ->      2         0 2        4       ->      2         4 2        6       ->      2        10 3        2       ->      3         2 3        1       ->      3         3   Sadly the lag function doesnt work like id like it to, otherwise this should have been the solution:   data count2; set count;     if ID ne lag1 (ID) then Count_sum=count; run;   data count3; set count2;     if ID = lag1 (ID) then Count_sum=lag1(Count_sum)+count; run;   Like i said the lag function doesnt seem to work in an "if then" statement as i want it to, but it should get you an impression of what i want to do with my data. The dataset is pretty big and Spells for one ID can go up to 170. I would be glad about any suggestions how to handle this problem.   Best Wishes! ... View more