When using the %MAKEWIDE macro code to transform a long form dataset into a wide form dataset, is there a macro code to retain the variable labels? I’ve searched for codes but I can’t find any. When I use %MAKEWIDE command to transform long form dataset into wide form data set, the labels always disappear. Below is the code I use to sort and merge datasets into one complete wide form dataset. Is there a code I can add to ensure the variable labels carryover into the wide form dataset? proc sort data=; by folio visit; run; proc sort data=; by folio visit; run; data /*data*/ merge /* a b c...*/; by folio visit; run; /********************* TRANSFORM ******************************/ %include "J: SAS commands\transpose to wide_macro code.sas"; proc contents data=; run; proc sort data=; by folio; run; %MAKEWIDE ( DATA= data_old, OUT=data_new, ID=folio, VAR=/*variables*/, TIME=visit) ;
... View more