Converting rows to columns (pivoting) and columns to rows (unpivoting) are common data transformation tasks in SQL. While many modern SQL databases provide PIVOT and UNPIVOT functions, these are not ...

</pre><BR><BR>There's a fixed, small number of different statuses (status1, ..., statusn), I want to generate a dataset with the following columns:<BR><BR>source, status1_num, status2_num, ..., ...

Pivoting transposing wider using sas sql and macro variables %let pgm=utl-pivoting-transposing-wider-using-sas-sql-and-macro-language; ...