Cody's Collection of Popular SAS Programming Tasks and How to Tackle Them

Chapter 7: Restructuring (Transposing) SAS Data Sets

Introduction

Task: Converting a data set with one observation per subject into one with multiple observations per subject (using a DATA step)

Task: Converting a data set with one observation per subject into one with multiple observations per subject (using PROC TRANSPOSE)

Task: Converting a data set with multiple observations per subject into one with one observation per subject (using a DATA step)

Task: Converting a data set with multiple observations per subject into one with one observation per subject (using PROC TRANSPOSE)

Conclusion

Introduction

At some point in your programming career you will need to restructure data sets. For example, you might have a data set that looks like this: ...