CSPro Users Forum

Hello,

Is there a way to deconcatenate a csdbe into a per case csdbe?

Example

I have a csdbe containing 100cases and i want it to be 1 csdbe file per case id.
Im currently using skip case but it is time consuming, is there a way to automate or make it faster?

Thanks

Take a look at the setoutput function: https://www.csprousers.org/help/CSPro/s ... ction.html

In a batch application, you could change the output filename per case. Something like:

Thanks for this.

Additional question:

How can i automate it into 10case per csdb? and if possible random selection.

Thanks again.

There's no way to determine the size of the output file while you're writing it. (Actually, you could close the file, check the size, and then reopen it.) Once thing you could do is try to approximate the number of cases in ten megabytes. Something like this:
You could also work with random selection. For example this would roughly divide all your cases into 20 files:

I have an error on case_counter saying is not a declared variable.

or did i miss something out?

Thanks again.

You would have to declare the variable. It should be a global variable, as you only want to reset it to zero as indicated in the code block Greg posted; i.e., you wouldn't want it local to a dictionary variable PROC where it would be getting reset to zero each time it was executed.

Yup, tried some global variable. but still cant figure it out.


// in the level preproc or postproc
if inc(case_counter) >= number_cases_per_10_mb then <-- in this if i use a variable(example CITY) then if CITY = 1, i dont get it how this code count
the cases which is >= number_cases_per_10_mb.
// setoutput to new file
case_counter = 0;
endif;

please enlighten me. thanks

First, apologies for taking so long to respond, I missed your post.

Second, you wrote above: How can i automate it into 10case per csdb? and if possible random selection.

So my understanding is you want to write 10 cases to each output file. Randomizing is a bit harder. See attached for what I've done to support these requests. If you're still having problems, please zip up your application so we can see what you're doing.

Sherrell

Hi It's working , thank you so mcuh.

Just a follow-up question,

total_cases = countcases(POP_DICT);
how_many_files = total_cases / 10;

I want to set the number in the total cases is it possible? Thanks
Example:
I only want 200 cases out of 1000.
so it wil be 200/10 .

Tried some random stuff but it always count the original countcases.

Thanks

>Hi It's working , thank you so mcuh.

great!

>I want to set the number in the total cases is it possible? Thanks
>I only want 200 cases out of 1000.

I'm not quite sure what you want to do. Meaning, you only want 200 out of the 1,000 cases to be exported, i.e., a 20% sample of your total cases?

If so, then you only need to make a a few adjustments. See attached for revised pgm.

Sherrell