Hi
I have the following table in SAS:
Var1 Var2 Var3
TJones Chem 01042008
0356 spec
0444 test
SJohn Hem 02042008
0112 test
0411 spec
Desired Output:
Var1 Var2 Var3 TestCode Testname
TJones Chem 01042008 0356 spec
TJones Chem 01042008 0444 test
SJohn Hem 02042008 0112 test
SJohn Hem 02042008 0411 spec
I need to create one observation per person with unique test codes.
Thanks
I have the following table in SAS:
Var1 Var2 Var3
TJones Chem 01042008
0356 spec
0444 test
SJohn Hem 02042008
0112 test
0411 spec
Desired Output:
Var1 Var2 Var3 TestCode Testname
TJones Chem 01042008 0356 spec
TJones Chem 01042008 0444 test
SJohn Hem 02042008 0112 test
SJohn Hem 02042008 0411 spec
I need to create one observation per person with unique test codes.
Thanks