CSPro Users Forum

Dear CSPro Team,

I have repetitive survey entry for some household. Every month or after 10 days we have to survey these households.
For this I have made unique key is HHNo. and Date.
But by external dict I want to retrieve latest household information which is previously filled by the enumerator.
How can I extract information from previously filled household information.

Here I am using MAX(DATE) function but not able to retrieve information.

If there is another way to retrieve information from the household then suggest me how?

It depends on how your data is stored in the external file. Do you have each of the previous interviews stored as a separate case or do you have all the previous interviews stored in the same case?

All are in seperate case

Then use forcase to loop through the cases in the external dictionary and pick the one with the most recent date.

Thanks it works