SAS EG lagcalculation issue, not calculating las as t - t-1 -


can 1 resolve issue there:

data want;  set have;  mac;   if first.mac do; daydif=0; kmdif=0; end;         else do;           daydif = date - lag(date); /* calculate difference between 2 dates */           kmdiff = kms - lag(kms);       end; run;

and got result (0 in first line . in second):

mac          date   kms           daydif    kmdif sp0001      10dec07 1885462.00000   0        0 sp0001      12dec07 1885462.00000   .        . sp0001      30apr09 1885462.00000   505      0 sp0001      15jul09 1886577.00000   76       1115 sp0001      16jul09 1887667.00000   1        1090 sp0001      17jul09 1889181.00000   1        1514 sp0001      17jul09 1888825.00000   0       -356  . .

(here when machine changed, lag taken t - (t-2) , not t - (t-1) ) why???? wrong in code ??

   machine  date    kms          daydif kmdif    sp0001   01oct14 2898108.00000   1   1059    sp0001   02oct14 2899148.00000   1   1040    hp0001   03oct14 2900334.00000   1   1186    hp0002   17jan08 926384.00000    0   0    hp0002   18jan08 926384.00000    -2450   -1973950    hp0002   28apr09 1237332.00000   466 310948    hp0002   29apr09 1238599.00000   1   1267

the values lag() function not taken previous observation (a common misconception).. they stored in memory every time function executed (see documentation).

in example, when machine changes, lag function not executed due conditional logic (if first.mac / else) - "t-2" value result previous iteration. try following:

data want;   set have;   mac;   if first.mac do;      daydif=lag(date); /* executing lag subsequent iteration */     daydif=0;      kmdif=0;    end;    else do;     daydif = date - lag(date); /* calculate difference between 2 dates */     kmdiff = kms - lag(kms);   end; run;

Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl>
Read more

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

using jqueryui splitter or resizable functions want create layout allows unlimited amount of columns added , columns need resizable. so fiddle: https://jsfiddle.net/f3glh3mw/ but in fiddle html contains out of nested sets instead of inline. limits possibilities above fiddle can have equal widths 2,4,8,16,32 etc columns. in between shows crooked can see in fiddle. when researching came on question: jquery ui , splitter if @ top answer shows structure like: <div class="wrap"> <div class="resizable resizable1"></div> <div class="resizable resizable2"></div> </div> full fiddle: http://jsfiddle.net/8qztj/86/ which structure want javascript hardcoded 2 resizable items. so here question: how modify last fiddle works amount of .resizable divs. or know of plugin can this. thanks helping! so far found plugin: http://www.bacubacu.com/colresizable/ which says , close functionality want. in
Read more

javascript - IE9 error '$'is not defined -

Image
<!--[if lte ie 9]><html class="lte9"><![endif]--><!--[if gt ie 9]><html><![endif]--> <!--[if !ie]><!--> <html> <!--<![endif]--> blah blah <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <script src="{{ asset('js/mypage.js') }}" type="text/javascript"></script> </body> </html> when load page, ie9 brings error '$' not defined . how can solve error? +++ mypage.js $(function(){ //when load page, //ie9 tag not moving. $(window).load(function() { $('div.mask').hide(); }); // when click , willshow show. //for not ie 9 if (!$('html').hasclass('lte9')) { var = $('ul.about > li > span.activebtn');
Read more