Does anyone know whether Proc sql supports Transform/Pivot standard SQl statement. I did a simple test and the log showed "invalid statement". I am wondering if anyone knows something about it. Thanks.
Some database vendors "extend" the SQL syntax to do special functions in their data base structure. If TRANSFORM/PIVOT is not ANSI standard, then PROC SQL probably does not support the use of that clause. I would recommend that you contact Tech Support for help (or the definitive answer) for this question.
Thanks for your quick reply. I went through SAS 9.2 Dcumentation for Proc SQL and didn't see transform/pivot in syntax session. I guess proc sql wouldn't support it. I will check with SAS tech support to verify it.