Showing posts with label transpose SAS easy. Show all posts
Showing posts with label transpose SAS easy. Show all posts

Wednesday, 19 October 2011

Great Transposing Tip

"You blocked me on facebook and now you are going to die"

Transposing in SAS is a great feature, but I always forget how to do it. My very talented colleague made this little illustration to remind him how it works and now you can use it too!



/*          |  id
        ----+-----
        by  |  var       */


proc transpose data= bernard out= mark (drop=_:) prefix= title_;
      var data;
      id column_headings;
      by row_groups;
run;