Hi there, I have data like this: ID   V1  V2  V3  ...... V20 01   A1  B2  C3  ...... 02  O1  P2  Q3  ...... 03  X1  Y2  Z3  ......     ...... and need to convert it into something like this: ID  TheVar 01  A1 01  B2 01  C3 ...... 02  O1 02  P2 02  Q3 ...... 03  X1 03  Y2 03  Z3 ......   Is there an efficient way to do that?  Thank you! Jason ... View more

Can somebody explain what the following statement does?   %mBuildLookupTab1(NAME=Region_Code_Conversion,DATASET=MyData.CCAC_LHIN,KEY=Region_ID,OBJ1=Region_Code); ... View more

Hi there,   I have a data set like this (The blank rows between different Patient_IDs are just for easy reading):   Patient_ID Service_Type Service_Volume 001 Serv_01 5 001 Serv_02 8 001 Serv_03 10       002 Serv_01 5       003 Serv_03 6   Many patients did not receive all three service types.  I need to insert rows for each patient so that they all have three Service_Types and are with the value of 0 for the Service_Types that they did not receive service on.  The resulting data set would be something like the following table:   Patient_ID Service_Type Service_Volume 001 Serv_01 5 001 Serv_02 8 001 Serv_03 10       002 Serv_01 5 002 Serv_02 0 002 Serv_03 0       003 Serv_01 0 003 Serv_02 0 003 Serv_03 6   How should I be accomplish this?   Thanks a lot! Jason ... View more