OI PowerPoint Template, Department Of Veterans Affairs

2y ago
60 Views
2 Downloads
1,010.72 KB
24 Pages
Last View : 6d ago
Last Download : 4m ago
Upload by : Philip Renner
Transcription

VINCI SAS/GridEnvironmental FAQs andEnhanced AnalyticsMark EzzoVINCI SAS AdministratorFebruary 23, 20161

Poll Question: SAS UsageETL (Data extraction)Data AnalysisStatistical AnalysisReportingOtherPlease select all that apply222 February 2016

VINCI SAS/Grid Agenda SAS Grid FAQs– Environmental– Linux vs. Windows– Best Practices Advanced Analytics– Enterprise Miner– Enterprise Guide Summary3

SAS/Grid 9.4 Client1. Basic SAS Installation (Client (vhacdwsasrds01) only!)– SAS Base– OleDB for SQL Server Data– No Statistical Packages!2. SAS Grid 9.4 (EG is on vhacdwapp06)––––All SAS Products (Base, Stat, etc.)ODBC for SQL Server Data (We set up your data)No OleDB on the Linux GridBest accessed the EG 7.1 Configuration3. Batch Processing (Either venue via vhacdwdwhsasgsub3b)– User can submit and forget (no need to remain connected)– Allows for SAS checkpoint/restart capability– Uses SAS Grid Manager metadata for centralized control4

Space Considerations SAS Clients have limitations of 100 GB ofProject Space for Consumption in theWindows Environment. SAS Grid has 45 TBs of Space forConsumption. The Grid has a possibilityof 73TBs with an expandable device. This does not mean we sacrifice “goodpractices” with queries, codes andspace!!!522 February 2016

Grid Advantages Multiple Node EnvironmentFail-Over capabilityCentralized Administration (SMC)Vast storage capabilitiesParallel processing for faster resultsLeading infrastructure for Research andCorporate Technology Base/DM SAS will not be further enhancedby SAS Institute622 February 2016

SAS User InterfacesBatch SubmitBase SAS SAS Enterprise Guide722 February 2016

Other Features SAS 9.4 Stored Processes introduces stored process reports andthe STP procedure. A stored process report is a new object typethat contains stored process output that is cached. The outputcan be viewed without re-executing the stored process. PROCSTP enables users to execute a stored process from a SASprogram. PROC STP can be executed in an interactive, batch, orserver SAS session and can even be executed by another storedprocess. Essentially, anyone with a Web Viewer can execute andview the results, without using SAS itself.822 February 2016

Grid Data Transference Lib names and File names WinSCP software Examples922 February 2016

Linux to Windows via Programdata x;infile cards;input pet age;cards;Festus 6Bailey 6Penny 4Cody 18;run;*** Exports results;proc export data work.xoutfile '/smb/vhacdwsasrds01.vha.med.va.gov/ME Share/pets name1.csv'dbms csv replace;putnames yes;run;1022 February 2016

Inefficient Program /* Old way, involving lots of reads (8) and writes (6) to the storage disk. */PROC SORT DATA FACT TABLE ; BY SCRSSN ; RUN ;PROC SORT DATA MASTER.PATIENT DEMOOUT MASTER(KEEP SCRSSN .) ; BY SCRSSN ; RUN ;DATA COMBINE ;MERGE FACT TABLE(IN IN1) MASTER(IN IN2) ;BY SCRSSN ;IF IN1 ;RUN ;PROC SORT DATA COMBINE ; BY STA6A ; RUN ;PROC SORT DATA MASTER.SITE DEMOGRAPHICSOUT SITE INFO(KEEP STA6A .) ; BY STA6A ; RUN ;DATA COMBINE;MERGE COMBINE(IN IN1) SITE INFO(IN IN2) ;BY STA6A ;IF IN1 ;RUN;1122 February 2016

Efficient Programming /* Hash object approach, 3 tables read into memory but only one write action. */DATA COMBINE(DROP : );/* Initialize the exterior demographic fields to the PDV with pseudo SET statement */IF 0 THEN SET MASTER.PATIENT DEMO(KEEP SCRSSN .)MASTER.SITE DEMOGRAPHICS(KEEP STA6A .) ;IF N 1 THEN DO; /* define the hash object(s) once, on the first iteration *//* this 1st hash object contains info on the patient demographics */DECLARE HASH PAT INFO(DATASET:'MASTER.PATIENT DEMO(KEEP SCRSSN .' , HASHEXP:12 ) ;PAT INFO.DEFINEKEY('SCRSSN'); PAT INFO.DEFINEDATA(ALL:'Y'); PAT INFO.DEFINEDONE();/* this 2nd hash object contains info on the site demographics */DECLARE HASH SITE INFO(DATASET:'MASTER.SITE DEMOGRAPHICS(KEEP STA6A .)') ;SITE INFO.DEFINEKEY('STA6A'); SITE INFO.DEFINEDATA(ALL:'Y'); SITE INFO.DEFINEDONE();END;SET WORK.FACT TABLE ; /* this is our cohort file, will read thru all these records */RC1 PAT INFO.FIND(); /* find the matching SCRSSN record from the unique key and pull into PDV */RC2 SITE INFO.FIND(); /* find the matching STA6A record from the unique key and pull into PDV */RUN;1222 February 2016

SQL Pass-Through via Wizard% eg conditional dropds(GRIDWORK.QUERY FOR ANTIBIOTIC);PROC SQL;CONNECT TO SQLSVR as con1(READBUFF 5000 INSERTBUFF 3000 DEFER YES AUTOCOMMIT NOCURSOR TYPE FORWARD ONLYUTILCONN TRANSIENT YES Datasrc CDWWork cdwa01 authdomain DefaultAuth);CREATE TABLE GRIDWORK.QUERY FOR ANTIBIOTIC ASSELECT *FROM CONNECTION TO con1 (SELECT ticIEN,t1.AntibioticDisplayCommentFROM Dim.Antibiotic t1WHERE t1.Sta3n 680);DISCONNECT FROM con1;QUIT;1322 February 2016

SQL Pass-Through self-construction% eg conditional dropds(GRIDWORK.QUERY FOR ANTIBIOTIC);PROC SQL;CONNECT TO SQLSVR as con1(&sql optimal Datasrc CDWWork cdwa01 authdomain DefaultAuth);CREATE TABLE GRIDWORK.QUERY FOR ANTIBIOTIC ASSELECT *FROM CONNECTION TO con1 (SELECT ticIEN,t1.AntibioticDisplayCommentFROM Dim.Antibiotic t1WHERE t1.Sta3n 680);DISCONNECT FROM con1;QUIT;Quick Demo1422 February 2016

SAS EG 7.1 Standard for coding and Grid AccessEnhanced and automatic featuresEasy to Configure and UseWizards for many tasksAble to develop SQL Pass-ThroughQueries (recommended for the DB) Live Demonstration!1522 February 2016

Parallel ProcessIn EG, via the Analyze Program feature, youhave the ability to adapt a program forParallel Processing. This allows much ofthe program to run simultaneously inmultiple jobs slots. This is much faster andmore efficient that a Linear Program utilizingone job slot.1622 February 2016

Parallel ProcessConsiderations: There are costs to parallel processing sothe more complex the program/data thegreater the benefit. Small programs do not have the need You may have to do a few modifications,depending upon the original program(libnames, etc.) Can greatly reduce processing time! Runs in both EG and GSUB (batch) Example22 February 201617

SAS Command-Line Grid Submission Utility Standalone utility that will allow user to– submit SAS program to grid for processing– display status of user’s jobs on the grid– retrieve output from user’s jobs to local directory1822 February 2016

Advantages User can submit and forget (Batch Jobs)– no need to remain connected to process job User can view job output while job is running Allows for SAS checkpoint/restart capability Uses SAS Grid Manager metadata for centralizedcontrol NOTE - requires shared file system between clientand grid1922 February 2016

Submitting a Job sasgsub –gridsubmitpgm sas pgm – other parameters stored in configuration file -GRIDWORK shared file dir metadata connection parameters -GRIDAPPSERVER app server name [-GRIDLICENSEFILE license file pathname ] [-GRIDFILESIN file list ] [-GRIDJOBNAME job name ] [-GRIDJOBOPTS job options ] [-GRIDRESTARTOK] [-GRIDSASOPTS sas options for job ] [-GRIDWORKLOAD workload values ] [-GRIDWORKREM remote shared file dir ]2022 February 2016

Example OutputJob ID: 6772Job directory: "/CNT/sasgsub/gridwork/sascnn1/SASGSUB-2009-0317 14.09.52.847 testPgm"Job log file: "/CNT/sasgsub/gridwork/sascnn1/SASGSUB-2009-0317 14.09.52.847 testPgm/testPgm.log“2122 February 2016

SAS Gsub Example Here is the command we will be using for batch processing on theGrid: sasgsub s/Program.sas It breaks down as follows:sasgsub is the command-GRIDSUBMITPGM is the option to submit a program/data/prod/admin/VHASLCEZZOM/Programs/is the directory wherethe program is locatedProgram.sas is the program you wish to runLive Demo!2222 February 2016

SAS Enterprise Miner SAS/EM is the state of the art Data Miningand Modeling Software. Text Miner is not coming!!! Friendly User interfaces allows lessprogramming and more analysis. Access via IE through this link: erpriseMinerJWS/Status Quick Demo2322 February 2016

Good Gridding!Thank you for attending.Please contact VINCI SAS Administrators:VINCI SAS AdminsVINCISASAdmins@va.govwith any questions or comments.2422 February 2016

Feb 23, 2016 · OI PowerPoint Template, Department of Veterans Affairs Author: Department of Veterans Affairs, Veterans Health Administration, Office of Information Subject: OI PowerPoint Template Keywords: OI PowerPoint Template Created Date: 2/22/2016 2:01:17 PM

Related Documents:

PowerPoint Guide POWERPOINT TEMPLATE The PowerPoint can be found in the Information section, and under the Event Details after you login to your PheedLoop account. It is mandatory that you use the PowerPoint template that we have provided. We have designed a Coatings full PowerPoint template, different from just the cover page in previous years.

One way to design a poster in PowerPoint is to add your own information to a PowerPoint poster slide that’s already been created (called a template). Another way is to design your own PowerPoint template. This tutorial uses a template. Posters are made up of elements that include text boxes, tables, graphs, images and design

ADA Training Module: Standard Plans 2018 Questions? 84. Title: State of Minnesota Sample PowerPoint Template Author: MN.IT Services Communications Subject: PowerPoint Template Keywords: PowerPoint, Template Created Date:

Initiate a Template-Based Hire – Casual AUPE Hourly (Project) Step 2: Access Template Selection 1. Click the Look up Select Template button (magnifying glass) next to the Select Template field. The Look up Select Template window is displayed. Step 3: Select Template The template

P-245 - Term Contract Template for Gen. Services P-250 - Purchase Order Template P-520 - Equipment Lease Template P-530 - Equipment Maintenance Template P-600 - Professional Services Template P-601 – Professional Services Template (Individuals) P-606 - Chapter 6 Professional Services Template P-650 – Prof. Services Amendment Template

PowerPoint TM Tutorial PowerPoint TM is an exciting tool that assists in effectively presenting a summation of important ideas to an audience. PowerPoint TM can often be intimidating to one who has never used the program. In reality, PowerPoint TM can be as simple or involved as the creator’s imagination, but at its foundation PowerPoint TM is nothing more than giving life to an outline.

Professional) title for PowerPoint since the last 9 years. His Indezine.com site attracts nearly two million page views each month and has thousands of free PowerPoint templates and other goodies for visitors to download. Geetesh runs another PowerPoint related site at ppted. com—this site provides designer PowerPoint templates.

Alfredo López Austin Hombre-Dios: religión y política en el mundo náhuatl: México Universidad Nacional Autónoma de México, Instituto de Investigaciones Históricas : 2014 209 p. (Serie Cultura Náhuatl. Monografías, 15) Cuadros, ilustraciones ISBN 978-968-36-0934-2 Formato: PDF : Publicado en línea: 27 febrero 2015 Disponible en: