Homework Problems

In short, your assignment for this lesson involves reading thekidsbooks.txt Download kidsbooks.txtdata file into a temporary data set calledkidsbooksand then generating a report that looks like this:

The columns of thekidsbook.txt Download kidsbook.txtdata file are defined as follows:

Variable

Definition

Columns

Title

Title of the book

1-20

Author

Author of the book

22-40

Publisher

Publisher of the book

43-58

Pubdate

Publication date

61-70

Price

Price of the book

72-76

Pages

Number of pages

79-80

It might not be immediately obvious but to generate the report, you'll need to select only those books whose price per page exceeds 30 cents. Another hint is that setting the page size to 38 helps to keep the footnote a nice close distance to the main content of the report. One final hint ... note that the report displays the books in descending order of price.

This is the kidsbook.txt

The Kissing HandPenn, AudreyTanglewood Press06/25/2006

9.9532

Voices in the ParkBrowne, AnthonyDK Publishing08/01/2001

7.9932

Anno's JourneyAnno, MitsumasaPutnam Juvenile08/04/1997

7.9948

An Egg is QuietAston, Dianna HuttsChronicle Books03/02/2006

11.5536

FlotsamWiesner, DavidClarion Books09/04/2006

11.5640

The Snowy DayKeats, Ezra JackPuffin10/28/1976

6.9940

CorduroyFreeman, DonViking Juvenile03/11/1968

11.5528

Snowflake BentleyMartin, JacquelineHoughton Mifflin09/28/1998

10.8832

Knuffle BunnyWillems, MoHyperion Books07/12/2004

10.8740

Bear Snores OnWilson, KarmaSimon & Schuster04/07/2003

10.7232

Rattletrap CarRoot, PhyllisCandlewick Press04/12/2004

7.9940

Oliver Finds His Way Root, PhyllisCandlewick Press08/26/2002

11.2440

Please note the question itself (above) and the associated data can be found at the link below. Thank you

https://docs.google.com/document/d/1astOTs7xhkuaZiSlnSUk7XXYgldznV50/edit?usp=sharing&ouid=111784480047729475081&rtpof=true&sd=true