Hi, I want to do a factor analysis (PCA) with VARIMAX rotation and KAISER normalization, but cannot figure out specify PROC FACTOR options to obtain this Staffan ... View more

I need to convert a SAS-data set with two sort keys to a new set where key 1 define rows and key 2 define columns in the new set as exemplified below (as can be done with the pivot function in Excel) Input: Key1 Key2 Data T1 AA 23 T2 AA 24 T3 AA 21 T1 BB 19 T2 BB 25 T1 CC 43 T3 CC 43 needed output: Key1 AA BB CC T1 23 19 43 T2 24 25 T3 21 43 ... View more