"I just want to be able to extract carreer paths (longitudinal database) with arrays after. Might be easier to work with columns than rows as everone can have a different number of positions over their carreer."
So
proc sql;
create table career_path as
select *
from your_first_table
where employee_id = 1 order by appointment_date; quit;
is not the career path of employee 1?
... View more
