Combining CLA data tables (i.e. CLA_Data_Supplied and CLA_2022)

[cfvarnish]

Question / Problem statement

Hi all, I am working with the CLA social care data and am trying to combine two of the data tables from SQL in R (specifically CLA_Data_Supplied which contains data up to 2021 and CLA_2022). After combining using rbind on shared columns, I'm finding a lot of rows in 2021 and 2022 where the first episode start date does not match the period of care start date for a child's first episode in a period of care. I find none of these cases post-2003 when running this check on the CLA_Data_Supplied dataset alone, so this appears to be due to combining the tables. Has anyone encountered this before or has a recommended approach for joining these tables? Maybe there is a quirk in the 2022 return that I am missing? Any advice would be much appreciated! Thank you

Compliance checklist

• I confirm I have not entered any information from within the ONS SRS (or only information that has been cleared for release by the ONS SRS output checking team).
• I confirm I have asked only one question in the textbox above.
• I confirm I have checked for similar questions amongst existing Q&As.

[klharron]

Hello, and apologies for the delay in getting back to you while I asked the team. I believe you have been in contact with Matt Jay about this issue. Did you find a solution?