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

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

Programmer: Gilles R. Detillieux

First Created: Oct. 24, 2022

Revisions:
  - Dec. 20, 2022: - adapted to updated "v2" datasets & split crosswalks
  - Jan. 12, 2023: - adapted to most recent "v2" variable names
  - Jan. 18, 2023: - adapted to most recent "v2" format names
  - Mar. 3, 2025: - adapted to 2024 "V2" variable names, acqdt value
  - Jul. 22, 2025: - use get_ircc_pr macro to fetch data

Input datasets:
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 combines the IRCC permanent resident landing
datasets (legacy and current data) and categorizes immigration admission
into four main groups, in a way that makes the newer categories match the
legacy categories.

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

options nocenter;

*** Get a full Canadian immigrant cohort from IRCC landing tables.;
*** Note that while immigration_category4_eng and immigration_class_eng are;
*** legacy landing variables, the macro sets these appropriately for more;
*** recent (2000 onward) landing records, based on application category ID,;
*** and the application_main_category and application_component_desc formats.;

%get_ircc_pr(cohort=Canada, out=landing);

*** report on landing categories;
title 'Landed immigrants in Canada, by admission category and component class';
proc freq data=landing;
   tables landing_dt*immigration_category4_eng landing_dt*immigration_class_eng
          immigration_category4_eng*immigration_class_eng / list missing;
   format landing_dt year4.;
run;

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