search

deepayan / nhanes-postgres

A docker container for NHANES data inside a PostgreSQL DBMS
0 stars 0 forks source link

_L series has some hiccups - which makes uniform processing hard #10

Open rgentlem opened 7 hours ago

rgentlem commented 7 hours ago

A tibble: 10 × 1 - from the DEMO_L table SDDSRVYR

1 NHANES August 2021-August 2023 public release 2 NHANES August 2021-August 2023 public release 3 NHANES August 2021-August 2023 public release 4 NHANES August 2021-August 2023 public release 5 NHANES August 2021-August 2023 public release 6 NHANES August 2021-August 2023 public release 7 NHANES August 2021-August 2023 public release 8 NHANES August 2021-August 2023 public release 9 NHANE s1 = nhanes("DEMO_J") > s1[1:10, "SDDSRVYR"] # A tibble: 10 × 1 SDDSRVYR 1 NHANES 2017-2018 public release 2 NHANES 2017-2018 public release 3 NHANES 2017-2018 public release 4 NHANES 2017-2018 public release 5 NHANES 2017-2018 public release 6 NHANES 2017-2018 public release 7 NHANES 2017-2018 public release
deepayan commented 6 hours ago

This is from https://wwwn.cdc.gov/Nchs/Nhanes/2021-2022/DEMO_L.htm#SDDSRVYR, so not much we can do. We will need to work around it.

The files are still located under 2021-2022, which can be determined by

> nhanesA:::.get_year_from_nh_table("DEMO_J")
          J 
"2017-2018" 
> nhanesA:::.get_year_from_nh_table("DEMO_L")
          L 
"2021-2022"

Any specific example of how this causes trouble?

rgentlem commented 6 hours ago

just this workflow title: "Examples of workflows enabled by docker"...from the vignettes in phonto you had extracted the years from the SDDSRVYR variable - and that is harder with this change by CDC

On Thu, Nov 14, 2024 at 10:38 AM Deepayan Sarkar @.***> wrote:

This is from https://wwwn.cdc.gov/Nchs/Nhanes/2021-2022/DEMO_L.htm#SDDSRVYR, so not much we can do. We will need to work around it.

The files are still located under 2021-2022, which can be determined by

nhanesA:::.get_year_from_nh_table("DEMO_J") J "2017-2018" nhanesA:::.get_year_from_nh_table("DEMO_L") L "2021-2022"

Any specific example of how this causes trouble?

— Reply to this email directly, view it on GitHub https://github.com/deepayan/nhanes-postgres/issues/10#issuecomment-2476735724, or unsubscribe https://github.com/notifications/unsubscribe-auth/AC7TWA4GJC7ZVZC4VRW3NVL2AS7YNAVCNFSM6AAAAABRZCMPBCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINZWG4ZTKNZSGQ . You are receiving this because you authored the thread.Message ID: @.***>

-- Robert Gentleman @.***