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
Should work if you add a semicolon before BY, use Product instead of PRoductL and add a RUN; statement at the end. - PG
Thanks. it worked
I actually had dups that I wasn't aware of..
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.