Sharing SAS programs between PC, Server and SAS Drug Development - PowerPoint PPT Presentation

Sharing SAS programs between PC, Server and SAS Drug Development Magnus Mengelbier Director PhUSE 2011 1

Topics Introduction ! SAS on PC and server ! SAS Drug Development ! Common attributes ! Sharing conventions ! Process interfaces ! Summary ! PhUSE 2011 2

SAS on PC and Server Treat SAS as an application ! Storage ! Local drive " Network share " “Flexible” environment ! Informal conventions ! Manual administration ! “No” audit trail ! “No” electronic signatures ! IT support ! PhUSE 2011 3

SAS Drug Development SAS in an environment Treat SAS as an application ! ! Storage Storage ! ! Local drive Local drive " " “Network” share Network share " " Inflexible environment “Flexible” environment ! ! “In”-formal conventions Informal conventions ! ! Manual administration Manual administration ! ! Audit trail “No” audit trail ! ! Electronic signatures “No” electronic signatures ! ! “SAS support” IT support ! ! SAS Drug Development SAS on PC and Server PhUSE 2011 4

SAS Drug Development – Inner Workings Web tier # “Repository View” # Process Editor # Data Explorer Repository # Job Scheduler # Advanced Loader # etc SAS servers PhUSE 2011 5

SAS Drug Development – Configuration Parameters ! Initialisation statement PC : Autoexec or %init() macro " Server : Autoexec or %init() macro " SDD : Configuration Parameters " ! Configuration parameters define Input / Output folder(s) " Input / Output data set(s) " Input / Output data set(s) " Input / Output file(s) " Global SAS macro variables " Log location " Base path " PhUSE 2011 6

Configuration Parameters – Interface PhUSE 2011 7

Configuration Parameters – Structure /******PACMAN****** DO NOT EDIT BELOW THIS LINE ******PACMAN******/ /******PACMAN****** DO NOT EDIT BELOW THIS LINE ******PACMAN******/ /*<?xml version="1.0" encoding="UTF-8"?>*/ /*<process sessionid="1df6db28:131fb34f1e1:4890" sddversion="3.5" cdvoption="N" parseroption="B">*/ /*<?xml version="1.0" encoding="UTF-8"?>*/ /* <parameters>*/ /* <parameter dependsaction="ENABLE" obfuscate="N" label="SAS log" systemtype="&star;LOG&star;" tabname="System Files" baseoption="A" /*<process sessionid="1df6db28:131fb34f1e1:4890" sddversion="3.5" advanced="N" order="1" id="&star;LOG&star;" canlinktobasepath="Y" protect="N" userdefined="S" filetype="LOG"*/ /* processid="P1" required="N" resolution="INPUT" enable="N" type="LOGFILE">*/ /* <parameters>*/ /* </parameter>*/ /* <parameter dependsaction="ENABLE" obfuscate="N" label="SAS output" systemtype="&star;LST&star;" tabname="System Files" baseoption="A" /* <parameter dependsaction="ENABLE" obfuscate="N" label="SAS lo advanced="N" order="2" id="&star;LST&star;" canlinktobasepath="Y" protect="N" userdefined="S" filetype="LST"*/ /* processid="P1" required="N" resolution="INPUT" enable="N" type="LSTFILE">*/ /* processid="P1" required="N" resolution="INPUT" enable="N" ty /* </parameter>*/ /* <parameter dependsaction="ENABLE" obfuscate="N" label="Process parameter values" systemtype="SDDPARMS" tabname="System Files" /* </parameter>*/ baseoption="A" advanced="N" order="3" id="SDDPARMS" canlinktobasepath="Y" protect="N" userdefined="S" filetype="SAS7BDAT"*/ /* processid="P1" required="N" resolution="INPUT" enable="N" type="PARMFILE">*/ /* <parameter dependsaction="ENABLE" obfuscate="N" label="SAS ou /* </parameter>*/ /* <parameter dependsaction="ENABLE" obfuscate="N" label="SAS program" systemtype="&star;PGM&star;" tabname="System Files" baseoption="A" /* processid="P1" required="N" resolution="INPUT" enable="N" ty advanced="N" order="4" id="&star;PGM&star;" canlinktobasepath="Y" protect="N" userdefined="S" filetype="SAS"*/ /* processid="P1" required="N" resolution="INPUT" enable="N" type="PGMFILE">*/ /* </parameter>*/ /* </parameter>*/ /* <parameter obfuscate="N" writefiles="N" label="Folder" tabname="Parameters" baseoption="A" readfiles="Y" advanced="N" id="LIB" /* <parameter dependsaction="ENABLE" obfuscate="N" label="Proces canlinktobasepath="Y" protect="N" expandfiletypes="N" required="Y" resolution="INPUT" enable="Y" type="FOLDER" order="5">*/ /* <fileset setType="2">*/ /* processid="P1" required="N" resolution="INPUT" enable="N" ty /* <sourceContainer system="SDD" source="DOMAIN" displaypath="/SDD/PartnerFolders/Limelogic" displayname="data" id="/SDD/PartnerFolders/ Limelogic/data" itemtype="Container" fileinfoversion="3.0">*/ /* </parameter>*/ /* </sourceContainer>*/ /* <fileInfoList>*/ /* <parameter dependsaction="ENABLE" obfuscate="N" label="SAS pr /* <file system="RELATIVE" source="RELATIVE" displayname="demo.sas7bdat" id="demo.sas7bdat" itemtype="Item" type="sas7bdat" fileinfoversion="3.0">*/ /* processid="P1" required="N" resolution="INPUT" enable="N" ty /* </file>*/ /* </fileInfoList>*/ /* </parameter>*/ /* <filterList>*/ /* <item name="ALL">*/ /* <parameter obfuscate="N" writefiles="N" label="Folder" tabnam /* </item>*/ /* </filterList>*/ /* </fileset>*/ /* <description>*/ /* </description>*/ /* </parameter>*/ /* <parameter canlinktobasepath="Y" dependsaction="ENABLE" baseoption="A" id="OUT" advanced="N" enable="Y" obfuscate="N" tabname="Parameters" resolution="INPUT" protect="N" filetype="TXT" label="Output file" required="Y" type="OUTFILE" order="6">*/ /* </parameter>*/ /* </parameters>*/ /*</process>*/ /**/ /******PACMAN******************************************PACMAN******/ PhUSE 2011 8

Common Attributes ! Initialisation statement PC : Autoexec or %init() macro " Server : Autoexec or %init() macro " SDD : Configuration Parameters " ! A generic perspective Data locations " Input locations and files " Output locations and files " “Input” and “Output” formats " PhUSE 2011 9

Sharing Conventions ! Use existing tools ! “Automatic” ! Natural to environment SAS on PC " SAS on Server " SAS Drug Development " ! and others " ! Flexible to an organisation Sponsor " Contract Research Organisations (CROs) " Third parties " PhUSE 2011 10

Standard for SAS Drug Development ! Initialisation statement ! Define Input / Output folder(s) " Input / Output data set(s) " Input / Output data set(s) " Input / Output file(s) " Global SAS macro variables " Log location " Base path " PhUSE 2011 11

Standard for SAS PC and Server ! Initialisation statement ! Initialisation statement ! Standardise ! Define Libraries Input / Output folder(s) " " Input / Output file(s) Input / Output data set(s) " " Input / Output folder(s) Input / Output data set(s) " " Global SAS macro variables Input / Output file(s) " " Log location Global SAS macro variables " " Root folder Log location " " Base path " Translate PhUSE 2011 12

Standard Macros Function Description meta() Defines context information that is usually defined by a program location within a directory structure library() Defines a SAS library for accessing one or more data sets and format catalogs dataset() Identifies a data set for required input data set, resulting output data set, or both. file() Defines an input file output() Defines an output destination (folder) or a specific output file. define() Defines one or more global macro variables with or without default values. PhUSE 2011 13