I got the original data and saved it in an excel workbook, then I imported into SAS. Below is the code and output: PROC IMPORT OUT=WORK.ORIGINAL                DATAFILE="DIRECTORY\Original.xlsx"                DBMS=EXCEL REPLACE;           RANGE="SHEET1$";           GETNAMES=YES;           MIXED=NO;           SCANTEXT=YES;           USEDATE=YES;           SCANTIME=YES; RUN; PROC SORT DATA=WORK.ORIGINAL;      BY CATEGORY SUBCATEGORY CLASS ITEM_DESCRIPTION ITEM_ID; RUN; PROC TRANSPOSE DATA=WORK.ORIGINAL OUT=T_ORIGINAL;      BY CATEGORY SUBCATEGORY CLASS ITEM_DESCRIPTION ITEM_ID; RUN; DATA TRANSPOSED;      SET T_ORIGINAL;      LABEL _LABEL_ ='Date' COL1='Price';      RENAME _LABEL_ =Date COL1=Price;      DROP _NAME_; RUN; Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 30/March/2015 26 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 06/April/2015 24 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 13/April/2015 25 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 20/April/2015 21 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 27/April/2015 22 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 04/May/2015 24 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 30/March/2015 23 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 06/April/2015 26 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 13/April/2015 24 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 20/April/2015 22 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 27/April/2015 23 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 04/May/2015 25 ... View more