Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to calcuate number of females in each case

    Dear All

    I want to calculate the number of females for each case for this dataset.
    I want to know what is the count of females in each case.
    So in summary, I want to know how many females are there in each case.

    For Example, I have used bysort metainstanceid: count if q_102==2 & q_103<50 & q_103>14

    I am not able to arrive at the correct count/numbers.


    ----------------------- copy starting from the next line -----------------------
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input str54 metainstanceid long q_102 int q_103
    "uuid:e957e905-6b3a-4fb2-b2b8-93d6cc4af621" 1  4
    "uuid:4541aab3-a5f4-4633-9f48-dcfb1e472c7f" 1 50
    "uuid:7696945e-4d46-403a-bd5e-6f7785b36997" 1 18
    "uuid:9ca2482e-4201-4430-bf5c-fd8bf033548a" 2  0
    "uuid:29b0cbe8-f603-485b-890b-123a1b8996f4" 2 32
    "uuid:9f230d8d-0fb0-41ed-8aee-1874baa0cb3a" 1 30
    "uuid:c966a8e6-dbe9-4377-92bf-809b038649de" 2 17
    "uuid:5b030a5b-bb6d-4a27-ad10-7c0be911e78b" 2 40
    "uuid:85fd0f93-3c29-4da0-9676-f8d4f70b3ac0" 2  1
    "uuid:00cffdd1-86c1-4f87-bfa1-732ba1dab175" 2 10
    "uuid:beefe2cc-fb82-401b-9dd3-da4e6c0ed42c" 2 48
    "uuid:0ffbbd14-4ad5-475d-8aab-67cffb3014f2" 1 32
    "uuid:1e0151cc-a934-4cd9-9c70-17b21321f8a6" 1 25
    "uuid:b65921ae-81bf-4687-b5a2-644b92dd6d14" 2 26
    "uuid:0e4068e9-2f09-4f58-b9df-3c8005526934" 2 16
    "uuid:7ad01453-fded-4677-ad01-a3bc43a6e6f4" 1 55
    "uuid:7be0b561-b8e5-4d4a-b2de-9565cd6db482" 1 17
    "uuid:ad34c63c-da08-412b-8ee2-2fd88b74d503" 1 65
    "uuid:c1c4f573-31b7-44b4-b2b5-c47d2dade600" 1 33
    "uuid:42c6607d-8f6f-4f17-8fae-61c21f9de38a" 2  4
    "uuid:e24fbcfa-1fd5-464c-b9d8-ad095fb2fe77" 2  0
    "uuid:e4b9394f-985d-424e-9877-ad079a2ca3a3" 2 25
    "uuid:21eec0c3-622b-4b84-9242-8e75e78f9ba1" 2 28
    "uuid:581bf7f1-69e1-49b4-9b8a-a1e7b828fe07" 1 29
    "uuid:72502517-5bd0-4257-82dd-094687d8883e" 1  2
    "uuid:4cdbbc9f-62c3-4b60-a35c-0151aa1c8788" 2  9
    "uuid:dd418b22-4ac5-46ff-813a-f2621f786fcf" 1 50
    "uuid:9704b90b-a51e-412b-99b3-fef491bd9808" 1 30
    "uuid:53f2622d-83c0-4686-801c-318a6d31a17a" 1 59
    "uuid:477e037b-8318-4fa1-af6f-693661c17c31" 2  0
    "uuid:8b5f3251-8ade-445e-a0ee-b74498ecf769" 2 23
    "uuid:d77e228c-a566-49fb-b565-a4ed2893112f" 1 47
    "uuid:9becd96e-ccaa-4d42-856f-2ace5f12d864" 2 15
    "uuid:a83e85b5-5a64-40d5-aa9e-ad3a08dedbe0" 2 70
    "uuid:47a56cec-8cfc-4396-91cf-6ee08d00f4ab" 1 25
    "uuid:4b9c6d3e-a72c-4a00-80d9-c1d59fb637e7" 1 31
    "uuid:bec3d6d8-697f-415a-9c77-1f7ee7d54bb9" 1 30
    "uuid:20aab1f8-e3b7-4596-84e7-9e1ba1cbb067" 1 47
    "uuid:208ee7ec-0745-46dd-9de3-47803074c711" 2  3
    "uuid:2697944a-a64e-413c-8ba0-30403c1ac6b7" 1 28
    "uuid:6d48d4b0-fcba-4da1-b56b-a50ab6236eef" 1 27
    "uuid:4e9fa0a2-3400-426b-8e40-6381398f4fd3" 1 60
    "uuid:408509d0-81c9-4392-8fab-0208aec06e39" 1 25
    "uuid:baec9654-c7a4-4e91-abea-bbc29bcf08f0" 1 40
    "uuid:83ad15de-7511-4972-8407-be7ce26d68af" 2  7
    "uuid:8cde5e10-9ebb-4751-98af-fa45a56ca3ed" 2 11
    "uuid:d116918b-dba9-4253-9dc9-1e52bd5a9a23" 2 45
    "uuid:2254b8aa-5e0d-4e46-95be-04e77b64200c" 1  2
    "uuid:f6df562e-1e9a-4e03-a422-ca012f58e78b" 1 32
    "uuid:57faf3de-2a83-412b-8d6e-01d7fa383a0d" 1  7
    "uuid:3fb62444-ddd5-488c-831f-65afee414e42" 1 58
    "uuid:325bf3e3-3809-4bf8-a805-056777874ad6" 2 90
    "uuid:3f4ed3d5-046a-4cf5-b864-4efcdb1697ce" 2  5
    "uuid:cea733af-8b37-4b2c-87eb-d81ded7f784a" 2 42
    "uuid:d2f68dcc-d766-4b5d-97de-46461112dc8b" 1 30
    "uuid:52c7b469-9e15-4b08-8300-6009fc8ce685" 2 18
    "uuid:fa11ff30-fc33-4480-b29d-2e4ce4a6b6f3" 2 32
    "uuid:60db8a32-f6c4-4d32-962b-c63003858860" 1 48
    "uuid:4c3b01b8-3ca6-45ba-beb4-4d1b3b725597" 2 25
    "uuid:703db9bb-3343-48cf-8dc9-6117f2e5f9fd" 1 50
    "uuid:bc658d16-6d07-4978-b004-ab2f3c8ceaaf" 1  4
    "uuid:2f76cb76-ed7f-4c8c-ad8d-7cd2764f2de4" 1 13
    "uuid:a8c6a792-e9c0-413a-92b6-76e66108fb7f" 2 11
    "uuid:aa21b925-99a7-46cc-af91-feb6abb162ed" 1 65
    "uuid:4d5290a8-fbbd-4b93-8af9-562362c863a5" 2 28
    "uuid:f61c4117-cd8e-480c-83f6-8f020d298a1d" 2 34
    "uuid:647dfd80-ac22-4ffd-b20c-43802f621cdf" 2 70
    "uuid:7556b7d0-35a9-47e1-a999-75ed6e7129ae" 2 19
    "uuid:a4fd475e-6d54-442d-8481-9291664bc88f" 2 10
    "uuid:e20d38b8-a221-45cc-aac8-0296e8d9c970" 1 26
    "uuid:b54449ba-2ca2-40a0-b6de-3ac2366c78b0" 1 22
    "uuid:13a91bb9-a4ef-4133-aef2-5a896ab3bd99" 1 17
    "uuid:abda50b1-9208-4ceb-a15c-dfa77a3de3fd" 2  9
    "uuid:e84e8843-2111-4aa7-b5d2-46f0fd69e181" 2  2
    "uuid:4430d0ef-795d-436b-a631-64f7b70a7c93" 1 30
    "uuid:396874db-2419-4d40-86f0-130bb77d1dc1" 2 62
    "uuid:0eecbbb7-9cd2-431b-8383-916eb93b9bc0" 1 41
    "uuid:9dde46b3-5369-4752-a12b-5b1318ba7ab3" 1 29
    "uuid:b4ed6b3e-343c-4311-aa78-e9e25b6a9866" 1 50
    "uuid:3c05746f-98d2-4f16-9237-1e8b87ccd2ec" 2 40
    "uuid:a8a241cd-1d34-4e74-8431-0e40ffed600b" 1 33
    "uuid:cd18c18f-9065-4095-b841-ea49d8fac820" 1 12
    "uuid:1df709ac-bd9b-4c4f-b85b-1d9f9ab79ed0" 2  3
    "uuid:1d8e9342-0b70-4d33-aa85-854a77d71a73" 1 50
    "uuid:1161c79f-7a38-4358-a958-bd261216ab4f" 1 31
    "uuid:28f44776-87d0-4088-9957-3a69541030e7" 2 33
    "uuid:6190662c-a770-4853-a8ee-0a42bd9b924f" 2 14
    "uuid:350b967a-f45b-41d0-89cf-df3ef6f05729" 1 60
    "uuid:eb8d60ad-9d1d-45f5-8c07-2dba688ce2db" 2 65
    "uuid:2197153f-276b-489d-a504-03dcbf15b1c8" 1  0
    "uuid:b905f275-0b0a-44e7-b736-720c0c6d634b" 1 21
    "uuid:9fbf386d-9dfe-4410-864d-d2f9062a5ea5" 2  6
    "uuid:97cb4057-4632-4725-852c-517d73ce393f" 1 58
    "uuid:f9584595-16e9-4111-a3fb-9f0c972aea60" 1  7
    "uuid:edaf6f39-7967-4d0e-9fff-15f40ace89bf" 1 10
    "uuid:c90fdb3e-6066-4da6-b73c-80e63d15faf6" 1 13
    "uuid:6e48d987-839e-465b-8087-35814c500c1f" 2 49
    "uuid:1ded2411-c65d-4c88-9170-a9978702d6e7" 1 60
    "uuid:c9856c6e-2b6f-4306-8eef-3a706489b8f1" 1  8
    "uuid:5701fef2-0d88-4166-b71e-475cdeba2f3f" 2 32
    end
    label values q_102 gender
    label def gender 1 "Male", modify
    label def gender 2 "Female", modify
    ------------------ copy up to and including the previous line ------------------

    Listed 100 out of 30302 observations
    Use the count() option to list more

    .

    Thank you in advance for help!


    Regards
    Ashish


  • #2
    mataintanceid is unique, so there is not count.

    What is a case?

    here's a general format you can play with.

    Code:
    egen females = count(cond(q_102==2,q_102,.)), by(metainstanceid)

    Comment


    • #3
      Ashish:
      as George pointed out, -maintenanceid- is one wave of data only: Therefore, no -bysort-.
      A tentative code might be:
      Code:
      bysort q_103: gen wanted=1 if q_102==2
      bysort q_103: gen count=sum(wanted)
      Kind regards,
      Carlo
      (Stata 19.0)

      Comment

      Working...
      X