![]() ![]() If you supply a path it will list the data sets there. If you supply the protocol number it will list all data sets in the trial’s PRODUCTION SAS library, which is given by the pfprotdata tool. If you supply no parameter, the tool will try to list all data sets in the Current Working Directory. It can be either a protocol number or a directory path. USAGE: pftranstables This means that you can supply one parameter (which is optional). The data is always pulled from Oracle on demand.ġ0 pftranstables DESCRIPTION: A Linux shell script that lists data sets within a trial’s SAS library. The datestamps associated with these views are not the date the view was last refreshed, it is the date the view was created. You cannot archive these data sets with the Linux “cp” command. ![]() These data sets are VIEWS, which means they do not contain any data, only the instructions SAS needs to get the data from Oracle. These are only for historical purposes and have the exact same data sets as the main directory. Access can be requested by ingĨ pfprotdata DESCRIPTION: A Linux shell script that lists the directories holding the SAS files for a trial USAGE: pfprotdata DEMOĩ pfprotdata NOTES You may see subdirectories of a trial’s SAS library named v9 and v9/linux. For biostatisticians access must be granted on behalf of the person needing access by the lead statistician for the disease group. Please use the new SAS interface, which is the topic of this training.Īll of the tools run on the Biostatistics Linux servers and use the EDC Repository Database.ħ Initial Setup The following lines must be added to the user’s “.cshrc” file (located in your home directory): setenv PATH $:/homes/inform/prod/shellscripts source /usr/skel/oracle.cfg The settings will be in effect for all future Linux sessions Each user must be granted access to pull data on a per-protocol basis. Due to resource constraints this system will be decommissioned in 2017. were deprecated in 2009 but have continued to run for some protocols. If ever needed, contactĤ Who to Contact For anything related to the SAS interface, contact Danny Quinn at For the following issues contact the Office of Data Quality (ODQ) at Questions about data cleaning or data requests Assistance with issuing queries to the study team Missing Forms Reports For access to the Inform front-end and other query tools, contact Marina Nillni.ĥ A note about the old SAS interface (pfgetdata)ĭue to infrastructure issues the %pfgetdata macro and associated shell scripts: pfcprots, pfctables, pfxatts, etc. This is the database used for the SAS interface which means data that is entered is not available until the next day. Oracle databases maintained by DFCI/Partners IS Data Path: Data entry -> Transactional Database -> EDC Repository Database The Transactional Database is populated immediately upon Data Entry, but is not used for the SAS interface The EDC Repository Database is refreshed from the Transactional Database once per day. Inform is used for all DF/HCC Clinical trials where CRF data is required. Presentation on theme: "Inform (the electronic data capture system (eDC)) SAS Interface"- Presentation transcript:ġ Inform (the electronic data capture system (eDC)) SAS InterfaceĢ What is EDC? Electonic Data Capture – web based system to collect Case Report Form (CRF) data DFCI licensed “Inform” EDC beginning in 2004 from Phase Forward Incorporated, which was acquired by Oracle Corporation in 2010.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |