Darrin Foltz 1 Source XKCD Identified a time consuming redundancy 857 Monthly 328 Companies in the survey August had 228 RCRs 70 RCRs preAugust were created by hand Question box included a manually entered list of errors identified by STEPs ID: 586070
Download Presentation The PPT/PDF document "RCR generator: A new STEPS/DQRS relation..." 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.
Slide1
RCR generator: A new STEPS/DQRS relationship
Darrin Foltz
1
Source: XKCDSlide2
Identified a time consuming redundancy
857 Monthly:
328 Companies in the survey.
August had 228 RCR’s (~70%).RCRs pre-August were created by hand, Question box included a manually entered list of errors identified by STEPs.STEPs provides basic error language
2
Example RCRSlide3
General Idea
Use the language already generated in STEPs to create RCRs for all companies with errors
Append the DQRS RCR database with new entries through SAS
3
Steps company screen: Steps Error: Slide4
Lucky me…
857_EditRejects table already existed
4
A series of concatenations, table joins, duplicate removals, and more…Slide5
Where to go from here…
Short Term goals
Improve Steps Error language
Formatting
SpacingAlphabetical/numerical organization Long Term goals
Other Surveys (Annual-176 & 191 Storage)Validation RCR creationCreate a table that self updates with HDD information, market share, reported values, state aggregate changes and then transpose those values into a formatted text string.
Validation RCRSlide6
6
Pre-formatting
Post-formatting
Examples of new language