topic Re: Where clause doesn't work. in New SAS User

Where clause doesn't work.

GN0001 — Tue, 21 Jul 2020 01:34:53 GMT

SAS Studio doesn't filter it:

I have this:

Add a WHERE statement that uses the SUBSTR        *;
*       function to include rows where the second letter  *;
*       of Basin is P (Pacific ocean storms).


data pacific;
	set pg1.storm_summary;
	drop Type Hem_EW Hem_NS MinPressure Lat Lon;
    WHERE Substr(Basin, 2, 1) = "P";
run;

It shows all the values for the column when I run this code:

Regards,

Re: Where clause doesn't work.

PGStats — Tue, 21 Jul 2020 01:52:26 GMT

Please show the log that results when you run the code.

Re: Where clause doesn't work.

WarrenKuhfeld — Tue, 21 Jul 2020 02:01:43 GMT

If this is literally what you did, end the last comment with a semicolon.

In general, you will find that a user error is *FAR* more likely than a major and central component of SAS not working.

Re: Where clause doesn't work.

mkeintz — Tue, 21 Jul 2020 04:45:23 GMT

BTW, if you are looking at just a single character, then you might want to know about the CHAR function, as in:

WHERE char(Basin,2) = "P";

Re: Where clause doesn't work.

ballardw — Tue, 21 Jul 2020 05:18:27 GMT

It may not hurt to show the code you used to check on the result.

We get someone about once a week that "examines" the input data instead of the output data.

Re: Where clause doesn't work.

Cynthia_sas — Tue, 21 Jul 2020 14:46:39 GMT

Hi:
This looks like a program from our Programming 1 class. We have a separate forum for the Programming 1 and Programming 2 classes, so student questions are monitored by the class instructors. In the future, you might want to consider posting class questions there. We need to know generally, what lesson you're working on and the title of the activity or practice you're working on. If you open a specific program file as a starter, that is useful to know too.
Cynthia
Here's the link for future reference to the forum for these classes: https://communities.sas.com/t5/Programming-1-and-2/bd-p/course_discussions

Re: Where clause doesn't work.

GN0001 — Tue, 21 Jul 2020 23:51:40 GMT

Sorry, I don't have the code any longer.

But I think I was wrong and where clause worked properly.

Respectfully,

Guity