Proc Transpose

[tparvaiz]

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

here is my sample data

Location	Product	Year_Month	QTY
Canada	Prod A	2013_01	400
Canada	Prod A	2013_02	100
Canada	Prod C	2013_02	300
USA	Prod A	2013_01	500
USA	Prod C	2013_02	200

Here is my desired output

Location	Product	2013_01	2013_02
Canada	Prod A	400	100
Canada	Prod C	-	300
USA	Prod A	500	-
USA	Prod 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

[PGStats]

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

[tparvaiz]

Thanks. it worked

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