/******************************************************************************
Project: Immigration Data Linkage Project (ircc_link)

File: S:\ircc_link\prog\gillesd\concept_samples\birth_region.sas

Programmer: Gilles R. Detillieux

First Created: Aug. 19, 2022

Revisions:
  - Dec. 19, 2022: - adapted to updated "v2" datasets & split crosswalks
  - Jan. 12, 2023: - adapted to most recent "v2" variable names
  - Mar. 5, 2025: - adapted to 2024 "V2" dataset & variable names, acqdt values
  - Jul. 22, 2025: - use get_ircc_pr macro to fetch data

Input datasets:
registry.ircc_crosswalk_1985jan_v2: IRCC linkage dataset, 1985-2023
registry.ircc_legacy_landing_1985jan_v2: IRCC landing data from 1985 to 1999
registry.ircc_landing_2000jan_v2: IRCC landing data from 2000 to 2023

Description: This program finds birth region of immigrants living in Manitoba,
for anyone listed in the IRCC immigration landing datasets and crosswalk.

******************************************************************************/

options nocenter;


*** Get a linked immigrant cohort from IRCC crosswalk and landing tables,;
*** keep one record per valid PHIN. The macro sets the birth region based;
*** on country of birth and the SCCAI_macro_region categorization format.;

%get_ircc_pr(cohort=, out=landing, dup=first);

*** summarize counts of individuals from each birth region;
proc tabulate data=landing;
   class birth_region / order=formatted missing;
   table birth_region, all=''*n='N'*f=comma9. / nocellmerge;
   title 'Landed immigrants in Manitoba, by birth region';
run;

*** a little cleanup;
proc delete data=landing;
run;