Forecasting using SAS Forecast Server, SAS/ETS, and more

How to use condition to build a new form from excel

Reply
Occasional Contributor
Posts: 7

How to use condition to build a new form from excel

Hello

    Plese see attachments, we have several option contracts in our excel doucument, how can I do to use SAS to build a new form from excel, which contract is 

datadate          expriation

11/01/2013      11/08/2013

11/08/2013      11/16/2013

11/15/2013      11/22/2013

11/22/2013      11/29/2013

 

Super User
Posts: 6,936

Re: How to use condition to build a new form from excel

SAS works with SAS datasets. Please post your example dataset as a data step using the macro from https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

Excel files do not convey structural information about SAS datasets, and they can carry malware, so they are blocked on many corporate firewalls for security reasons.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 7

Re: How to use condition to build a new form from excel

Here is our sas bdat

Attachment
Super User
Posts: 6,936

Re: How to use condition to build a new form from excel

So you want to extract 4 lines of data from your dataset. What is the functional rule for extracting/building those lines?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 7

Re: How to use condition to build a new form from excel

I want to select the contract weely which begin at 11/01/2013,  such as begin at (varible name datadate) 11/01/2013, expriate at 11/08/2013, and then datadate=11/08/2013, expriation date is 11/16/2013, since 11/16/2013 is holiday, market not opened at that day, so next contract is from 11/15/2013 to 11/22/2013. Finaly, we pick up all the contrcat which  

datadate          expriation

11/01/2013      11/08/2013

11/08/2013      11/16/2013

11/15/2013      11/22/2013

11/22/2013      11/29/2013

 I think we can use lag function to do that, but I don't know how to coding it.

Ask a Question
Discussion stats
  • 4 replies
  • 123 views
  • 0 likes
  • 2 in conversation