Hello Guys   I have three column called "starring date" "ending date" "open price", now I need create a new column call " close price", that close price should be the "open price " of the "ending date". For example, I want get the close price of "ending date"= 05/17/2015, I need find the "05/17/2015" in column "starring date"=05/17/2015 first, and then let "close price" = "open price" of "starring price " which is "05/17/2015'. This problem like "looking up" vertical. If you have any ideal please let me know, thank you.   ... View more

Hi guys  I have a variable called "_datadate" that include all Friday from May 2015 to May 2017, I want to output all Friday which is 3rd Friday in the month, I use this code "  DATA AAPL_TEsT1; set AAPL_test; week =intck('_datadate',intnx('month',date,0),date)+1; run; " But it not work.   I need some suggestions for this issue. Thank you. ... View more

I'm looking for a function that can tell me what week in the month a given data date is from.  I have weekly data that spans for two years. The data begins from the third week of May 2015. Now, there are some unbalanced structures of duplicate data. What I want to do is to keep all of the duplicate dates four weeks following the third week of May.    However, there are instances in which four weeks ahead of that initial date will end in the same month. I want to account for this by creating an exception where, if this is true, it will use five weeks ahead instead of the usual four.    I know I can use an if statement to accomplish this, but I am unsure how to do this. I posted my SAS data file. The variable I need to deal with in this file is called _datadate. The problem happens in the following example: 10/02/2015  four weeks later: 10/30/2015 This displays my problem. It shouldn't land in the same month. I would want it to go to 11/06/2015.   Thank you and have a good day.   ... View more

Let's suppose I have 100 values in my data set. If I want to drop the three highest values, as well as the three lowest values, what code would best accomplish this? ... View more

I have two variables: return A and return B. On my graph, I need one line to describe the data from return A, and a second line to describe the data from return B. These two lines should be on one single graph, not two.  I want to compare return A and return B by the week their data is from. (data date is on the x axis)   How can I use a Proc Plot function to accomplish the above criteria? If there is another function that can help me achieve this purpose, that is also acceptable.   Thank you and have a good day. ... View more