1 / 7

Applying SAS Parallel-Processing Feature

Applying SAS Parallel-Processing Feature. Berwick Chan, berwick.chan@kp.org Kaiser Permanente Vaccine Study Center NCAL Division of Research For BASAS May 2014 meeting. SAS Step-by-Step Sequential Processing Flow. Execution Time. SAS starts. Task 1. X seconds. Task 2. y seconds.

nathaniel-carney
Download Presentation

Applying SAS Parallel-Processing Feature

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Applying SAS Parallel-Processing Feature Berwick Chan, berwick.chan@kp.org Kaiser Permanente Vaccine Study Center NCAL Division of Research For BASAS May 2014 meeting

  2. SAS Step-by-Step Sequential Processing Flow Execution Time SAS starts Task 1 X seconds Task 2 y seconds Total: (x+y) seconds SAS ends Applying SAS Paralle Processing Feature - B. Chan

  3. SAS Parallel Processing Flow Execution Time SAS starts Task1 Task 2 SAS starts SAS starts Task 2 y sec Task 1 SAS ends x sec SAS ends Total exec time: max(x,y) sec SAS ends Applying SAS Paralle Processing Feature - B. Chan

  4. Ideal Tasks For Parallel Processing • Independent tasks that run on the same server. For example, sorting 2+ huge SAS tables • Independent tasks that run on different servers. For example, reading Oracle/DB2/Teradata tables simultaneously • Linking standalone SAS programs together with a set of user-defined condition. (Production job setting) Applying SAS Paralle Processing Feature - B. Chan

  5. SAS Code Samples • Basic MP-Connect program structure • Sorting two tables concurrently • Sending two passthrusql to different servers concurrently Applying SAS Paralle Processing Feature - B. Chan

  6. More SAS Code Samples Linking/Running independent SAS programs with controls such as: • Be able to communicate among independent programs • Be able to check status of individual program • Be able to define logic to determine program flow on the fly, for example, if anyone of the independent programs yields non zero return code then abort the entire program Applying SAS Paralle Processing Feature - B. Chan

  7. More About MP-Connect • Useful links: http://support.sas.com/onlinedoc/913/getDoc/en/connref.hlp/connrefwhatsnew900.htm http://support.sas.com/rnd/scalability/tricks/connect.html http://www2.sas.com/proceedings/sugi28/279-28.pdf Applying SAS Paralle Processing Feature - B. Chan

More Related