Hi, I wanted to ask that I am trying to take mean of different observations done on same date. I have data for 6 months and there are many observations of every date. Now I want to take mean of every date so that data is minimized. If anyone can tell me the code. Thanks ... View more

Hi, I am new to this software. I am trying to run a code but its giving me error that "Libref ALB is not assigned". If anyone can help me in this. How do I assign the Libref? I am trying to run the above code I am attaching the screenshot of error. Following is the code I'm trying to run. data ALB.N; set sample_farwa (keep=_ric date_time Ex_Cntrb_ID price volume bid_price ask_price Exch_Time where=(_ric="ALB.N")); retain ap; retain bp; if Date_Time~=lag(Date_Time) then do; bp=.; ap=.; end; if bid_price=. then bid_price=bp; else bp=bid_price; if ask_price=. then ask_price=ap; else ap=ask_price; z=100*mod(price,0.01); run; ... View more