Opening Pinnacle 21 Community
For Mac: Open your "Applications" folder and double click on "Pinnacle 21 Community".
Using Pinnacle 21 Validator
Specify the "Source Data" by browsing to a data file or a folder containing your data files.
Select your format: "SAS Transport (XPORT)" or "Delimited Text." If you selected "Delimited," you can specify a Delimiter and a Qualifier. The default delimiter is a "|" (vertical pipe).
Specify the "Configuration." You can choose from the listed options that come packaged with the Validator or browse to your own.
Optionally specify the "Define.xml". If you have a define.xml file associated with your data, providing it to the program will help provide more relevant checks.
Choose your preferred report format. You can select Excel or CSV. Note that the Excel format is limited to displaying the first 65535 error messages, but the Validator will check all of your data even if you exceed this amount. You can ignore certain error messages by clicking the Report Settings link and selecting the desired message filters.
Press the Validate button.
Once the validation is complete, you can view a detailed report by clicking the Open Report button.
Using P21's Define.xml Generator
Specify the "Source Data" by browsing to a data file or a folder containing your data files.
Specify the "Configuration." You can choose from the listed options that come packaged with the Validator or browse to your own.
Click the Create button.
Once the creation is complete, you can view the excel spec by clicking the Open Spec button.
Import Define.xml - specify a define.xml to create an excel spec from it.
Click the Create button.
Once the creation is complete, you can view the excel spec by clicking the Open Spec button.
Please note you cannot specify both Source Data and a define.xml at the same time.
Generate Define - specify the "Excel Spec" by browsing to your excel file.
Click the Generate button.
Once the creation is complete, you can view the Define.xml by clicking the Open Define.xml button.
Using P21's Data Converter
Specify the "Source Format" of your data from the dropdown menu.
Specify the "Source Data" by browsing to a data file or a folder containing your data files.
Specify the "Output Format" from the dropdown menu.
Specify the "Output Path" where you would like your converted data files to be placed.
If you are converting into Dataset-XML you must supply the define.xml with your data or associate your data to a standard config. Associating a config will create a template define.xml with the metadata about your datasets and variables. The define.xml will be placed in your output path.
Click the Convert button.
Once the conversion is complete, you can navigate to the output path and open your new files or select Open Folder.
Using P21's ClinicalTrials.gov Miner
Specify the "Report Type" from the dropdown menu.
Insert your "Search Query" by typing it in or copy-pasting it from the clintrial.gov url. Include the text string after the "?" from the query which you create on that website. e.g. https://clinicaltrials.gov/ct2/results?term=%22heart+attack%22&Search=Search turns into: term=%22heart+attack%22&Search=Search.
If you are searching for outcomes, you can optionally specify a categories file which will arrange your data according to specific characteristics. E.g. Use a csv with 2 columns:
SEARCH_TERM | DISPLAY_CATEGORY |
ABNORMALITY CRITERIA | ABNORMALITY CRITERIA |
ADVERSE EVENT | AE Incidence |
After you complete your search, click the Mine button. Once the search process is complete you can view the excel sheet by clicking the Open Report button.