SAS Global Forum Workshop Presentation

1、Separating the Interface from the Engine: Creating Custom Add-in Tasks for SAS Enterprise GuidePeter EberhardtFernwood Consulting Group Inc.AgendaIntroductionDemoRequirementsGetting StartedInterfacesExamplesWrap-upIntroductionHistory of SAS and open environmentWhat is a custom add-inHow does an add-

2、in compare to a SPIntroductionPre v8Multi-PlatformStand aloneIntroductionv8IOMOpened SASIntroductionv9StudiosDI, Cube StudioJava clientIntroductionEnterprise Guide 4.1.NET applicationIntegration into MS Office“SAS is too hard to use”Drag-and-Drop InterfaceProject orientedSAS Tasks encapsulate underl

3、ying PROC syntaxProcess flows link Tasks and DataIntroductionSAS EnterpriseGuideSASon WindowsSASon MainframeSASon UNIXCodeResultsIntroductionAn Enterprise Guide project can be thought of as a basket, or container:HealthcareTo which you assign a nameIn which you place data source(s)Within which you d

4、efine tasksIntroductionInterfaces Part 1EG Custom Add-in TasksFriendly front-end to a existing SAS programmesAccess SAS and non-SAS resourcesPackage SAS PROCS not part of EGIntroductionInterfacesSAS Stored ProcessSAS programme that is centrally managedTwo componentsMetadataprogrammeRuns on a serverS

5、imple user interfaceAgendaIntroductionDemoRequirementsGetting StartedInterfacesExamplesWrap-upAgendaIntroductionDemoRequirementsGetting StartedInterfacesExamplesWrap-upRequirementsFundamentalsVisual Studio.NET Framework v1.1EG 4.1A problem or solutionRequirementsImplement InterfacesMain Entry: inter

6、facePronunciation: in-t&r-fAs Function: noun 1 : a surface forming a common boundary of two bodies, spaces, or phases 2 a : the place at which independent and often unrelated systems meet and act on or communicate with each other b : the means by which interaction or communication is achieved at an

7、interface - interfacial /in-t&r-fA-sh&l/ adjective Main Entry: interactionPronunciation: in-t&r-ak-sh&n Function: noun : mutual or reciprocal action or influence - interactional /-shn&l, -sh&-n&l/ adjective RequirementsInterfaces Part 2Separates the name of a method from its implementationContract b

8、etween your programme and SASAgendaIntroductionDemoRequirementsGetting StartedInterfacesExamplesWrap-upGetting StartedProject templatesAvailable from the SAS siteAdds a new project type to Visual StudioCreates a project with the required interfacesGetting StartedRules to Remember in Visual StudioThe

9、 project name and directoryWhen you create the new projectRename the default files and classesCustomTask1, CustomTaskForm1Change the properties of the add-in referenceChange the strings in ISASTaskDescriptionSearch for PLACEHOLDERGetting StartedDemoDemo creating a project1New projectDemo creating a

10、project12Project TypeSAS EG 4 AddIn (from SAS template)Project Name and Location3Demo creating a project1Default File Names need to be changedDemo creating a project1Names in the project need to be changedDemo creating a project1ReferencesLocal Copy property set to FALSE2Demo creating a project1Proj

11、ect PropertiesDemo creating a project1Configuration Propertiesset Debug Mode to ProgramNOTE: click Apply after changing the Debug Mode to un-grey the Start Program propertyDemo creating a project1Configuration PropertiesNavigate to your EG executableDemo creating a project1Change the descriptions in

12、 the source codeDemo creating a project1Strings are changedDemo creating a project1Build the projectDemo creating a project1Success!AgendaIntroductionDemoRequirementsGetting StartedInterfacesExamplesWrap-upInterfacesSeparates the name of a method from its implementationContract between your programm

13、e and SASInterfacesYou agree you will implementISASTaskAddinISASTaskDescriptionISASTaskYou can implement if you wantISASTaskSubmitSinkISASTaskDataSinkInterfacesISASTaskAddinThis connects the application (i.e. Enterprise Guide) to your Add-in. It provides basic information back to EG.EG will not reco

14、gnize your add-in if you do not implement this interface.The template automatically creates all the members of the interface for you.InterfacesISASTaskDescriptionThis interface is used by the application to determine basic task information which is not dependent on the task state. ISASTaskDescriptio

15、n2is an optional extension of this interface with a few additional properties for advanced features.Implement one or the otherInterfaces - ISASTaskPublic PropertiesLabelThe label of an instance of the task as it appears in the project.Both a “property set” and a “property get” have to be implemented

16、OutputDataCountThe number of output datasets the task expects to create.Only a “property get” has to be implementedInterfacesISASTaskThis interface is used by the application to control the runtime state of the add-inInterfacesISASTask2Extends ISASTask with additional properties and methodsImplement

17、 SASTask OR SASTask2InterfacesPropertiesISASTaskAddinISASTaskDescriptionISASTaskYou can implement if you wantISASTaskSubmitSinkISASTaskDataSinkInterfacesISASTaskSubmitSink Supplies notifications to the add-in that the input data has changed, or that it needs to take some action regarding output data

18、 that it intends to create. InterfacesISASTaskDataSink Supplies notifications to the add-in that the input data has changed, or that it needs to take some action regarding output data that it intends to create. InterfacesSAS agrees to implementISASTaskConsumerISASTaskDataISASTaskDataAccessorISASTask

19、DataDataColumnSAS agrees it might implementISASTaskSubmitISASTaskUtilitiesInterfacesISASTaskConsumerProvides information about what the application supports and access to other supported interfaces. Also provides access to options specific to the particular instance of the add-in.The implementation

20、of this interface by a host application is required, although not all properties and methods are required to be supported. InterfacesISASTaskDataThese interfaces allow the task to obtain information about the active data. Different host applications might not be able to provide values for some of th

21、ese methods.InterfacesISASTaskDataAccessorThese methods allow the task to access the data values in a specific data object.InterfacesISASTaskDataColumnProvides information about a single column in a data sourceInterfacesSAS agrees to implementISASTaskConsumerISASTaskDataISASTaskDataAccessorISASTaskD

22、ataDataColumnSAS agrees it might implementISASTaskSubmitISASTaskUtilitiesInterfacesISASTaskSubmitThis interfaces allow the task to submit SAS code from within the task.InterfacesISASTaskUtilitiesThis interfaces allow the task to surface some utility functionality to the task.InterfacesExamplesRecapDownload the Templates from SASCreate the initial projectChange the default name