topic Re: SAS Programming 1: Essential Lesson4: p104p04 in Programming 1 and 2

SAS Programming 1: Essential Lesson4: p104p04

Catherine18 — Thu, 23 Sep 2021 16:57:55 GMT

Open p104p04.sas from the practices folder.

Create a new column named SqMiles by multiplying Acres by .0015625.
Create a new column named Camping as the sum of OtherCamping, TentCampers, RVCampers, and BackcountryCampers.
Format SqMiles and Camping to include commas and zero decimal places.
Modify the KEEP statement to include the new columns.
Submit the program.

I tried the following codes but I am getting different answers.

data np_summary_update;
    set pg1.np_summary;
    keep Reg ParkName DayVisits OtherLodging Acres SqMiles Camping;
    SqMiles=Acres*.0015625;
    Camping=sum(OtherCamping,TentCampers,
                RVCampers,BackcountryCampers);
    format SqMiles comma6. Camping comma10.;
run;

So, the question is and the answers in the answerkey are: SqMiles  1,014 and Camping 6,375.
and my answers are: SqMile 77 and Camping 201,741
I copied and pasted the codes from the answer key and still geting the same results (77, 201741). I did not sort the data in anyway nor the question asked to sort the data.
Did anyone else had the same issue?

Re: SAS Programming 1: Essential Lesson4: p104p04

Kurt_Bremser — Thu, 23 Sep 2021 17:17:41 GMT

You can check the validity of your code quite easily, by doing the calculation yourself with the values found in the dataset. After all, it's just one multiplication and adding of 4 values.

If the dataset is the result of an earlier task of yours, go back there to see if you calculate the correct values there.

Re: SAS Programming 1: Essential Lesson4: p104p04

Reeza — Thu, 23 Sep 2021 17:11:30 GMT

Is Acres 648,960 or 4928 in the original data set?
Are you sure you're using the correct input data set?

Re: SAS Programming 1: Essential Lesson4: p104p04

Cynthia_sas — Thu, 23 Sep 2021 17:13:29 GMT

Hi:

My guess is that somehow the original dataset, pg1.np_summary got corrupted or lost rows. When you run a PROC CONTENTS on pg1.np_summary, you should see 135 observations or rows and 10 columns or variables, as shown in the PROC CONTENTS output below:

Another way to check is to look in your log. You should see something like this:

If you have anything OTHER than 135 as the number of observations for pg1.np_summary, then it is a good idea to re-run the data creation program again to refresh the data.

When I run the program against the data with 135 observations, the first observation is for the ParkName value of Cape Krusenstern National Monument the SqMiles value is 1,014 and the Camping value is 6,375 . Please go back to the Course Overview instructions and re-run the program to re-create the data for the class. The answer key is correct and it seems like something happened to your data, perhaps accidentally that changed pg1.np_summary.

Cynthia

Re: SAS Programming 1: Essential Lesson4: p104p04

Catherine18 — Thu, 23 Sep 2021 18:13:23 GMT

I am getting a total of 135 observations and it's unsorted. I have 7 variables since I dropped a couple of them. I am not sure what went wrong but I will try re-creating the data. Thanks!

Re: SAS Programming 1: Essential Lesson4: p104p04

Catherine18 — Thu, 23 Sep 2021 18:17:54 GMT

I am positive that I am using the correct data (unless it got corrupted somehow) because I copied and pasted the codes from the answer key and I am getting the same results as my code's output. This is my first row:
Reg ParkName DayVisits Other Acres SqMiles Camping
1 NE Acadia National Park 3,303,393 0 49,057.36 77 201,741

Re: SAS Programming 1: Essential Lesson4: p104p04

Catherine18 — Thu, 23 Sep 2021 18:21:14 GMT

The calculations are correct but it has multiple rows and the question is about the first row. I am getting the exact set of results somewhere at the bottom but not in the first row. So I think it is some sorting issue. But, I did not sort the data neither the question asked to sort it.

Re: SAS Programming 1: Essential Lesson4: p104p04

Catherine18 — Thu, 23 Sep 2021 18:31:16 GMT

I tried re-uploading the data and now I am getting correct results. Thanks, @Cynthia_sas and everyone!