Crosstab

Clas

New Member
#1
Hi.

Is it complicated to create crosstab ?

INPUT:

ID StartDate Type Value

123 1852-02-02 Birthdate 1852-02-02
123 1871-05-05 MarrDate 1871-05-05
123 1874-12-12 MarrDate 1874-12-12
123 1874-12-12 Occupation 5



Crosstab to Longitudinal dataset:
ID ----------StartDate ------BirthDate ----------MarrDate -----Occupation
123 ---------1852-02-02 ---- 1852-02-02
123 ---------1871-05-05 ---------------------- 1871-05-05
123 ---------1874-12-12 ---------------------- 1874-12-12 ----- 5


Is it possible to build this dynamic if INPUT structure is standardized, Type contains columnnames and Value the value ?
(To find columnnames: Group on Type)

Thanks in advance !