Hi All,   Can someone help me with a below query. I have a dataset with 4 variables. ID AVG SALES YEAR. I want to create flag variable which shows consecutive increase of sale of 30 or greater for 3 consecutive months from AVG='PRE' for respective id. I have created below sample and indicated the records which needs to be flagged    hEID AVG SALES YEAR/MONTH FLAG 01            99     2008/1                 98     2008/2                 96     2008/3                 99     2008/4                 94     2008/5        PRE 97.2   2008/6               107      2008/7               110      2008/8               160     2008/8               133    2008/9               135    2008/10          Y               112    2008/11               108    2008 /12               02          100 2008/1               101 2008/2               102 2008/3               103 2008/4               104 2008/5       PRE 102 2008/6               90 2008/7              101 2008 /8             100 2008/9             135 2008/10             140 2008/11             145 2008/12        Y               Thanks in advance. Rakesh           ... View more

Hi All,   Can someone help me with the code or procedure for calculation of Geometric LS mean.   Best regards Rakesh ... View more

Hi All,   Can some one help me below issue.   I am able to open all data sets except for two data sets in my library. All are upcased dataset names and cannot be changed. Any thoughts on how to open dataset in library. I am able open the datasets in the location but not using libname.     ... View more