Proc Transpose

tparvaiz — Fri, 22 Mar 2013 22:19:57 GMT

Hi, I am trying to use proc transpose and getting an error message.

here is my sample data

Here is my desired output

I was trying code like this:

proc transpose data=WORK.IN

out=WORK.OUT

Location PRoductL;

ID year_month;

got the following error message:

ERROR: The ID value "'2013-1'n" occurs twice in the same BY group.

and so on

please advice.

Thanks in advance

Re: Proc Transpose

PGStats — Fri, 22 Mar 2013 22:26:40 GMT

Should work if you add a semicolon before BY, use Product instead of PRoductL and add a RUN; statement at the end. - PG

tparvaiz — Fri, 22 Mar 2013 22:59:30 GMT

Thanks. it worked

I actually had dups that I wasn't aware of..