Using the Reformat Tool

Discussions about tools to complement CSPro data processing
boikgwadi
Posts: 26
Joined: June 27th, 2014, 2:47 am
Contact:

Using the Reformat Tool

Postby boikgwadi » September 15th, 2016, 5:11 am

Greetings

I created a rooster using a the first ten or so variables and then chucked away the rest meaning I took a rooster dictionary, truncated what I did not want, then edited my rooster from there. I further more re-used the same data sets as I needed the static data for household members.

The challenge is that on some slots where there is supposed to be blanks as nothing would have been entered, I get "dirty data" entered. This is causing quite a huge challenge when I export. How best can I use the Reformat Tool or any other for that matter to clean/ rid of dirty data in the rooster not captured by the clerk.

Gregory Martin
Posts: 1077
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Using the Reformat Tool

Postby Gregory Martin » September 19th, 2016, 4:18 pm

To use the Reformat Data tool, you will need to have an old copy of the dictionary. That is, you must have the dictionary that you used to collect the initial data, the dictionary that you then subsequently modified.

Once you have this dictionary, you will use it, as well as the current dictionary, as inputs to the Reformat Data tool. The tool will format your data so that the old data can be read by the new dictionary.

Leon111
Posts: 10
Joined: February 20th, 2017, 10:55 am

Re: Using the Reformat Tool

Postby Leon111 » July 23rd, 2018, 9:32 am

i also facing challenge on Reformat Data, when i select run it gives error "Stoping cspro and give Bug error" Help

josh
Posts: 1653
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Using the Reformat Tool

Postby josh » July 23rd, 2018, 11:14 am

Please post or send the dictionary and a test data file that exhibit the problem here or send it to cspro@lists.census.gov

Leon111
Posts: 10
Joined: February 20th, 2017, 10:55 am

Re: Using the Reformat Tool

Postby Leon111 » July 24th, 2018, 5:18 am

Thank you, have emailed the Dictionary and test data


Return to “Tools”