topic Re: Specifying Rows in SAS in New SAS User

Specifying Rows in SAS

Cyclopsedia — Fri, 21 Aug 2020 16:38:15 GMT

Hi all,

I'm a newbie with SAS of just 1 week experience and learning through Coursera and this website. The activity is requesting that in my freq output that I put Species_ID to have results starting with YOSE and Category equal to Mammals.

Errors I'm receiving:

ERROR: Variable Mammal is not on file PG1.NP_SPECIES.

I'm not asking for answers on solving this activity but rather some pointers on what code should be where , Proc FREQ and Proc Print.

Below is my code; (Please be gentle in criticism lol)

proc freq data=pg1.np_species;
tables Abundance Conservation_Status;
run;

proc print data=pg1.np_species;
var Species_ID Category;
where species_id = "YOSE%" and Category = Mammal;
run;

Thanks for everyone's time 🙂

Re: Specifying Rows in SAS

novinosrin — Fri, 21 Aug 2020 16:40:23 GMT

are you missing to include Mammals within quotes " "

proc freq data=pg1.np_species;
tables Abundance Conservation_Status;
run;

proc print data=pg1.np_species;
var Species_ID Category;
where species_id = "YOSE%" and Category = "Mammal";
run;

Re: Specifying Rows in SAS

Cyclopsedia — Fri, 21 Aug 2020 17:44:46 GMT

Good question. Checking now..

It looks like when I typed out this issue I WAS missing quotation marks but it doesn't seem to have a difference in my results output.

My goal; is to have species_Id show anything starting with YOSE and Category to point to Mammal only..here are my results with and without quotations. It isn't printing what I've got in PROC PRINT.

Does it matter if the Print statement is before or after Proc Freq?

Re: Specifying Rows in SAS

novinosrin — Fri, 21 Aug 2020 17:52:37 GMT

I am going guess here as I do not know what's in your species data. Perhaps, you are after this?

where upcase(species_id) like "YOSE%" and upcase(Category) = "MAMMAL";

/*Task1*/
proc print data=pg1.np_species;
var Species_ID Category;
where upcase(species_id)  like "YOSE%" and upcase(Category) = "MAMMAL";
run;

/*Task 2*/
proc freq data=pg1.np_species;
tables Abundance Conservation_Status;
run;

Re: Specifying Rows in SAS

ballardw — Fri, 21 Aug 2020 17:56:47 GMT

@Cyclopsedia wrote:

Good question. Checking now..

It looks like when I typed out this issue I WAS missing quotation marks but it doesn't seem to have a difference in my results output.

My goal; is to have species_Id show anything starting with YOSE and Category to point to

If you used "YOSE%" as a LIKE value then you have to use Like "YOSE%" not =.

Or you can use the =: comparison for a "starts with"

where species_id =: "YOSE%"

The order for Proc Freq and Proc Print would really matter if you are creating a data set in Proc Freq that you want to print with Proc Print. But with both (or multiple procedures) using the same input data set then the order in the code is the order the results are created. So if you have a preference of appearance then have the procedures in the desired order.

Re: Specifying Rows in SAS

Cyclopsedia — Fri, 21 Aug 2020 18:14:05 GMT

Both responses to this issue are correct, Thanks a TON guys. it's pretty likely you'll see more posts from me in the future haha but I look forward to getting SAS down 🙂

Re: Specifying Rows in SAS

Cyclopsedia — Fri, 21 Aug 2020 18:14:52 GMT

Both responses to this issue are correct, Thanks a TON and it's pretty likely you'll see more posts from me in the future haha but I look forward to getting SAS down . Thanks again for your patience with me

Re: Specifying Rows in SAS

Cyclopsedia — Fri, 21 Aug 2020 18:16:32 GMT

I meant to click this as a solution. My apologies.

Re: Specifying Rows in SAS

novinosrin — Fri, 21 Aug 2020 18:20:25 GMT

Welcome to SAS communities @Cyclopsedia

Sir @ballardw , I have noticed you sharing a set of instructions that depicts how to ask a good question. Could you please post that here so that OP can use and follow those well laid instructions in the future

Re: Specifying Rows in SAS

Cynthia_sas — Fri, 21 Aug 2020 22:30:47 GMT

HI:
The = sign will not work with %. That means you are looking for actual variable values that are exactly YOSE% -- and if you remember from the instructions, there are NOT any values that have a %. You will want to review the video on special WHERE operators. You are supposed to use LIKE for this practice (not =).
Hope this helps,
Cynthia

Re: Specifying Rows in SAS

Cynthia_sas — Fri, 21 Aug 2020 22:31:18 GMT

This practice was meant to have the students use LIKE.
Cynthia