I have transformed this table with imported data, but need to merge the collection of rows into individual rows by date. This would eliminate the excess of empty cells. Right now there are hundreds of rows when. I want them to condensed in to the three separate dates that data was collected. I have no experience with SAS, I appreciate the more specific and detailed you are. How do I begin? What procedure do I use?      I know the photo is not great, but you can see that it created the same date entry for each column, when it could be condensed into one.  I used if statements and drop statements to filter the data I wanted to utilize.  Other than that, the following is the is the only code in the program.    proc sort; by REPORT_DATE; proc report data=one out=sorted ; column REPORT_DATE LEVEL_2, (STORES_WITH_ADS WEIGHTED_AVERAGE_PRICE); define REPORT_DATE / display; define LEVEL_2/ across;   proc print; run;   When I tried to define REPORT_DATE / group;  it removes my column titles and transforms my graph back to a long dataset rather than a wide and still prints the same date multiple times.  ... View more