FSLG 29 th September 2016 wwwcsoie 1 First steps Moving to A utomation PX file composition Program workflow 2 PXfile First Steps Options for Manual Creation PXMake Statistics Denmark ID: 1012634
Download Presentation The PPT/PDF document "Creating PX Files Paul Rockley" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1. CreatingPX FilesPaul RockleyFSLG - 29th September 2016www.cso.ie1
2. First stepsMoving to AutomationPX file compositionProgram workflow2PX-file
3. First StepsOptions for Manual CreationPX-Make (Statistics Denmark)PX-Edit (Statistics Finland)R SoftwarepxR PackageAdviceStatistics Finland sitehttp://tilastokeskus.fi/tup/pcaxis/lataus_tyokalut_en.htmlwww.cso.ie3
4. Why Automate?Input Errors reducedSpeedReproducibilitywww.cso.ie4
5. PX File - CompositionTwo Parts…HeaderDatawww.cso.ie5
6. www.cso.ie6PX file example used in presentation…MonthLocationSexAge GroupStatistic
7. PX File - HeaderCoding of Variables…www.cso.ie7
8. www.cso.ie8PX File - DataHEADERDATA
9. Program WorkflowSummariseMergeCreate PX filewww.cso.ie9PX
10. Process 1Summarisewww.cso.ie10
11. Process 1 –Summarisewww.cso.ie11
12. Process 2Mergewww.cso.ie12Merge on composite key
13. Process 3Create PX filewww.cso.ie13PXCreate blank PX fileHeader - read in PX header template and replace marker textData - write to file after formatting and confidentiality checks
14. Detail –2) Read in PX header template and replace marker textwww.cso.ie14Process 3 –Create PX file
15. Detail – 3) Write data to PX filewww.cso.ie15Process 3 –Create PX file
16. Detail – 3.1) Formatted Outputwww.cso.ie16Process 3 –Create PX file
17. Detail – 3.2) Confidentialitywww.cso.ieProcess 3 –Create PX file
18. www.cso.ie18PX-file
19. Thank youwww.cso.ie19