Fluorite | Level 6

## Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

Hi, I copied the SAS code from the solution into SAS Studio and my results show that the values of SqMiles and Camping in row one are  0. However, the solution says: SqMiles is 1,014 and the value of Camping is 6,375".

Is anyone else having this issue?

1 ACCEPTED SOLUTION

Accepted Solutions
Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

I had the same issue with this question. It's a poorly written question and needs to be revised to specify what park they want as the answer instead of "Row 1"

In my 'row 1' slot without using any kind of sort -- because the question doesn't specify to sort -- was Noatak National Preserve.

There are several parks that are very small, and I'm guessing the original poster was using one of the parks that show 0 and 0, such as African Burial Grounds NM or Aztec Ruins NM possibly.

The correct answer uses Cape Krusenstern National Monument as the correct location. But I have no idea how they would ever arrive at that park ending up in Row 1.

Unless I am missing something obvious, please let me know if I am, this is a very very poor question that needs to be revisited and revised.

13 REPLIES 13
Super User

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

Please post the complete log (all code, all messages) by copy/pasting it into a window opened with this button:

Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

```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;```
Diamond | Level 26

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

@ohaetok wrote:
```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;```

The log was requested. This is not the log.

--
Paige Miller
Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

``` 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69         data np_summary_update;
70             set pg1.np_summary;
71             keep Reg ParkName DayVisits OtherLodging Acres SqMiles Camping;
72             SqMiles=Acres*.0015625;
73             Camping=sum(OtherCamping,TentCampers,
74                         RVCampers,BackcountryCampers);
75             format SqMiles comma6. Camping comma10.;
76         run;

NOTE: There were 135 observations read from the data set PG1.NP_SUMMARY.
NOTE: The data set WORK.NP_SUMMARY_UPDATE has 135 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time           0.00 seconds
user cpu time       0.00 seconds
system cpu time     0.00 seconds
memory              959.75k
OS Memory           22440.00k
Timestamp           01/17/2023 10:03:07 PM
Step Count                        55  Switch Count  2
Page Faults                       0
Page Reclaims                     165
Page Swaps                        0
Voluntary Context Switches        18
Involuntary Context Switches      0
Block Input Operations            0
Block Output Operations           264

77
78         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
88         ```
Diamond | Level 26

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

So you are getting zero values where you expect non-zero values. Your code does not produce errors, as shown in the log. So the problem must be that the data contains values that are not expected. Please LOOK AT the data set named pg1.np_summary with your own eyes to see if you can figure out why you are getting zeros.

--
Paige Miller
SAS Super FREQ

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

Hi:
I just tested the code and got the same correct results as that shown in the answer for the question (1014 and 6375). So I can't duplicate your experience.

The fact that you're getting 0 indicates to me that something might be wrong with your LIBNAME statement or possibly your input data set got accidentally deleted or corrupted. Did you see any Physical File not found messages in the log?

In the np_summary_update data set that you create, the first row should be for Cape Krusenstern National Monument with SqMiles and Camping as indicated above. When you check the input data in pg1.np_summary, the data should have 135 rows and 10 variables. After you run your program, the work.np_summary_update data set should have 135 rows and 7 variables (because of the recommended KEEP).
Cynthia

Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

Hi, it doesn't seem like there is anything wrong with the files, unless I am missing something.  I am still getting 0 as the answers. I attached pictures of the code, the results for the modified table ( total rows:135, total columns 7), and results for the original table ( total rows:135, total columns: 10).

Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

`libname pg1 "/home/u44465073/EPG1V2/data";`

this is the libname statement I use

Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

I had the same issue with this question. It's a poorly written question and needs to be revised to specify what park they want as the answer instead of "Row 1"

In my 'row 1' slot without using any kind of sort -- because the question doesn't specify to sort -- was Noatak National Preserve.

There are several parks that are very small, and I'm guessing the original poster was using one of the parks that show 0 and 0, such as African Burial Grounds NM or Aztec Ruins NM possibly.

The correct answer uses Cape Krusenstern National Monument as the correct location. But I have no idea how they would ever arrive at that park ending up in Row 1.

Unless I am missing something obvious, please let me know if I am, this is a very very poor question that needs to be revisited and revised.

SAS Employee

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

Thank you for the input. I'm guessing what happened is that you permanently sorted the table in a prior practice, which obviously impacted the order for this practice. I've updated the question in the course to this: What are the values of SqMiles and Camping when ParkName is Cape Krusenstern National Monument?

Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

That is very possible, thank you for the feedback.
Fluorite | Level 6

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

To kinda close the loop on this, I went back to the data set to see if I did sort it using PROC CONTENTS. When I pulled up the PROC CONTENTS for the temporary dataset we created, 'np_summary_update,' it shows that it wasn't sorted, but it does show that I sorted by Descending Acres when I use PROC CONTENTS on the original pg1.np_summary data. That was helpful to go back and look at that once you mentioned it, I'll keep that in mind moving forward, thank you.

SAS Employee

## Re: Lesson 4_ Level 1 Practice: Creating New Columns (p104p04.sas)

Thanks for following up!  Good learning exercise...  Regardless, your suggestion was valid to change the question so that it doesn't depend on a particular sort order.  I appreciate you taking the time to provide the feedback and see it through to the end. That helps us improve our training. 🙂

Discussion stats
• 13 replies
• 2493 views
• 2 likes
• 6 in conversation