I have an issue with generating tables using the count, a sample of the function
count(qhsec03 where qh112 = 2 and qh113_age in 10:18);
qhsec03 is a section in my application
qh113_age is the age of the individual
qh112 is the sex of the individual
both qh113_age and qh112 are in the qhsec01 section
Also qhsec01 and qhsec03 are all rosters in the application
Using the count function across sections
Re: Using the count function across sections
Telimore,
Your question is not very clear but if I got it, you need to setup a relationship for the two rosters.
While at the dictionary mode, go to edit menu and click on 'Relations' and proceed from there. You can also check on relations documentation.
Mutua
Your question is not very clear but if I got it, you need to setup a relationship for the two rosters.
While at the dictionary mode, go to edit menu and click on 'Relations' and proceed from there. You can also check on relations documentation.
Mutua
-
- Posts: 1796
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Using the count function across sections
Because both qhsec01 and qhsec03 are multiply occurring records, you have to link them somehow so that CSPro knows how to connect the two. You can connect a singly occurring record with a multiply occurring record, but you cannot automatically link two multiply occurring records. To do that, as Mutua mentions, you have to use dictionary relations. You can learn more about them here: http://csprousers.org/forum/viewtopic.php?f=5&t=605