CSPro Users Forum

I'm not sure if you're really posting about CSPro, but if so, you can do something like:

function string RemoveTrailingCommas( string text)

// convert commas to spaces
do numeric ctr = length ( strip (text)) while ctr >= 1 and text[ctr: 1 ] = ',' by - 1
text[ctr: 1 ] = ' ' ;
enddo ...

You can also look at: viewtopic.php?t=3183

There is no way to do this directly using CSPro. If you want to automate this process, you will have to parse the dictionary .dcf file yourself and output the data you are interested in.

For example, here is a shell of a JavaScript program that writes out some information about a dictionary. The ...

Also take a look at the ways you can export data from Data Viewer: https://www.csprousers.org/help/DataVie ... xport.html

You can write directly to an Excel file (one worksheet per record), or to Stata (one file per record, which you can then join within Stata).

You can use the Concatenate Data tool to combine cases from multiple data sources (files):

https://www.csprousers.org/help/CSConca ... _data.html

The format of the inputs does not matter, so you can concatenate CSPro DB cases along with JSON cases.

It looks like your files are corrupt. If you want, you can send them to cspro@lists.census.gov, or post them here, and we can see if there is any recoverable data.

Are you talking about "records" or "cases"? I'm assuming that you mean that you are receiving files that have no cases. If so, you can use logic to determine if there are any cases:

setfile (DICT_NAME, "file1.csdbe|password=1234" );

if countcases (DICT_NAME) > 0 then
// do something with the ...

The CSPro form designer does not allow you to create a roster that has multiply-occurring items. The only way to implement this is to use a repeating form, which you do by selecting the "Don't Roster" option when dragging the record onto the form:

https://www.csprousers.org/help/CSPro/drag_option ...

If you are trying to do this in CSPro, you'll have to manipulate the data file using CSPro's file functions. First, you need to come up with a way to determine what lines are questionnaire records vs. person records. Perhaps the length of the record will tell you, or perhaps the order of the records ...

Unfortunately, at the moment there is no way to increase the gap between value labels. We will consider adding modifications to the UI in a future release.