topic Re: Programming 2 Lesson 2 - Activity4 in Programming 1 and 2

Programming 2 Lesson 2 - Activity4

mk133201 — Fri, 22 Jul 2022 10:26:14 GMT

Hi,

I am trying to follow through the below activity in Lesson 2. I am using the last.Basin statement but unfortunately it is not working... does anyone know why?

Thanks 🙂

Open p202a04.sas from the activities folder and perform the following tasks:

Change the WHERE statement to a subsetting IF statement and submit the program. How many rows are included in the output table?

if last.Basin = 1

Re: Programming 2 Lesson 2 - Activity4

PaigeMiller — Fri, 22 Jul 2022 10:17:54 GMT

... unfortunately it is not working ...

Explain what you mean. Saying "it doesn't work" and not telling us the evidence that it doesn't work gets us nowhere.

Re: Programming 2 Lesson 2 - Activity4

mk133201 — Fri, 22 Jul 2022 10:25:47 GMT

Hi,

thanks for your msg, oops i just re-checked and seems i overlooked the output table names - hence seeing 54 rows in the output table and thought the last.Basin code wasn't working. I would delete this post if i can, sorry for any inconveniences.

Re: Programming 2 Lesson 2 - Activity4

ballardw — Fri, 22 Jul 2022 16:34:24 GMT

Just mark your message as the "solution". Then anyone seeing this thread from a search can see that the solution was "read the table name" or what ever correctly.