topic Sorting data in SAS Programming

Sorting data

harveysarah0 — Wed, 26 Feb 2020 00:20:26 GMT

Sort your merged SAS data set by price of a quarter rack of ribs, from cheapest to

most expensive. Print the resulting table and present it (properly titled) in your

solutions.

proc sort data=Bbq;
          
   by descending price 
  
run;

What else am I missing?

Patrick — Wed, 26 Feb 2020 00:33:39 GMT

Use a Title statement and Proc Print to print your data.

Check if the sort order is correct and from cheapest (lowest value) to most expensive (highest value).

harveysarah0 — Wed, 26 Feb 2020 02:04:15 GMT

what's a title statement? Sorry I am very new to SAS. and so everything is right except including the title statement and using Proc Print?

Patrick — Wed, 26 Feb 2020 02:11:36 GMT

Proc Sort allows you to sort a table. You've done that (but.... shouldn't you sort ascending from lowest to highest value?).

Now using this sorted table you need to create a report (print what's in the table).

The title statement is what allows you to define a title for your report. Documented here.

Proc Print is a SAS procedure which allows you to create a report (print your data). Documented here.