Proc Transpose

Reply
Frequent Contributor
Posts: 134

Proc Transpose

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

here is my sample data

LocationProductYear_MonthQTY
CanadaProd A2013_01400
CanadaProd A2013_02100
CanadaProd C2013_02300
USAProd A2013_01500
USAProd C2013_02200

Here is my desired output

LocationProduct2013_012013_02
CanadaProd A400100
CanadaProd C-300
USAProd A500-
USAProd C-200

I was trying code like this:

proc transpose data=WORK.IN

out=WORK.OUT

by

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

Respected Advisor
Posts: 4,919

Re: Proc Transpose

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

PG
Frequent Contributor
Posts: 134

Re: Proc Transpose

Thanks. it worked

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

Ask a Question
Discussion stats
  • 2 replies
  • 210 views
  • 0 likes
  • 2 in conversation