topic Re: coding issue in SAS Programming

coding issue

u19696098 — Fri, 29 Oct 2021 01:45:10 GMT

Hi I am having issue in solving below problem from coursera as i am entering the exact code that of solution by but its not returning any records please help; Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table

The np_species table includes one row for each species that is found in each national park. If necessary, start SAS Studio before you begin.

Reminder: If you restarted your SAS session, you must run the libname.sas program to access your course files.

Open a new program window and write a DATA step to read the pg1.np_species table and create a new permanent table named out.fox in the EPG1V2/output (or EPG194/output) folder.
Include only the rows where Category is Mammal and Common_Names includes Fox.
Exclude the Category, Record_Status, Occurrence, and Nativeness columns from the output data.
Submit the program.
Notice that Fox Squirrels are included in the output table. Add a condition in the WHERE statement to exclude rows that include Squirrel.
Submit the program and verify the results.
Sort the fox table by Common_Names.

What is the value of Common_Names in row one?

data out.fox;
set pg1.np_species;
where Category="Mammal" and Common_Names like '%Fox%'
and Common_Names not like '%Squirrel%';
drop Category Record_Status Occurrence Nativeness;
run;

proc sort data=out.fox;
by Common_Names;
run;

Re: coding issue

Reeza — Fri, 29 Oct 2021 02:59:13 GMT

Show the log please.

Re: coding issue

ChrisNZ — Fri, 29 Oct 2021 05:49:44 GMT

Notice that Fox Squirrels are included in the output table

Common_Names not like '%Squirrel%'

These two don't seem to be compatible.

Re: coding issue

AMSAS — Fri, 29 Oct 2021 11:09:22 GMT

Post your log file, also try building up your where clause bit by bit and reviewing the output dataset each time.

Your code looks good, at least when I tried it on a sample:

data got ;
	infile cards dlm=" " dsd;
	input 
		category :$20.
		common_names :$20.
	;
cards ;
fish 'Marlin'
fish 'Dorado' 
Mammal 'Squirrel'
Mammal 'Flying Fox'
Mammal 'Fox'
Mammal 'Red Squirrel'
Mammal 'Squirrel Fox' 
Mammal 'Fox Squirrels'
;
run ;

data want ;
	set got ;
	where 
		Category="Mammal" and 
		Common_Names like '%Fox%' and 
		Common_Names not like '%Squirrel%';
	put category= common_names= ;
run;

Re: coding issue

Cynthia_sas — Fri, 29 Oct 2021 13:37:55 GMT

Hi:
Coursera has a Discussion Forum area that is monitored by SAS instructors. The advice you've been given is good advice. If you only did a WHERE to search for the string Fox in the Common_Names column, you'd get some plants like Foxglove or Foxtail. So, adding a compound expression to filter to only get the Mammals, gets you closer to what is needed. However, if you look at an expression as used in this code:

You see that there is still one row that we need to eliminate, so the solution to this (graded) practice requires another condition to eliminate the Fox Squirrel from the output.

So running this final compound WHERE should enable you to find the correct answer to the question. Then you need to look at the resulting table so you can answer the question. You just need to type the name of the animal in row one of the output table.

Since this is a graded practice on the Coursera platform, I am not going to post the answer here.
Cynthia

Re: coding issue

u19696098 — Fri, 29 Oct 2021 13:59:15 GMT

Thank you all for valuable suggestions, But this is not working for me;

libname out "/home/u19696098/EPG1V2/data" ;

data out.fox;
set pg1.np_species;
where Category="Mammal" and Common_Names like '%Fox%'
and Common_Names not like '%Squirrel%';
drop Category Record_Status Occurrence Nativeness;
run;

proc sort data=out.fox;
by Common_Names;
run;

70 libname out "/home/u19696098/EPG1V2/data" ;

NOTE: Libref OUT refers to the same physical library as PG1.

NOTE: Libref OUT was successfully assigned as follows:

Engine: V9

Physical Name: /home/u19696098/EPG1V2/data

74 data out.fox;

75 set pg1.np_species;

76 where Category="Mammal" and Common_Names like '%Fox%'

77 and Common_Names not like '%Squirrel%';

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

78 drop Category Record_Status Occurrence Nativeness;

79 run;

WARNING: The variable Category in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable Record_Status in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable Occurrence in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable Nativeness in the DROP, KEEP, or RENAME list has never been referenced.

Re: coding issue

u19696098 — Fri, 29 Oct 2021 15:02:15 GMT

Hi All,

I tried in different way and still it shows the error below, please let me know what mistake did i do here.

please help me.....

Re: coding issue

ballardw — Fri, 29 Oct 2021 15:12:10 GMT

@u19696098 wrote:

Hi All,

I tried in different way and still it shows the error below, please let me know what mistake did i do here.

please help me.....

Sounds like time to go back an make sure that you built the NP.Species data set correctly. Then that you did not modify it to remove the Common_names variable. Spelling counts. If you accidentally created a variable named "Comman_names", for example, that might be one of the causes of the errors. Proc Contents will list all the variables in a data set and basic properties.

So try

Proc Contents data=NP.Species;
run;

and see what it tells you about your version of the data set.

Re: coding issue

u19696098 — Fri, 29 Oct 2021 15:40:27 GMT

Hello,

Common_Names is the correct variable name and Proc contents gives below, not sure why its saying everytime the variable Common_Names not found

Re: coding issue

Reeza — Fri, 29 Oct 2021 15:57:06 GMT

Your code in the images doesn't match what's been posted.

COMMON NAMES and COMMON_NAMES -> you're missing the underscore in your second reference to the variable.
You need to fix your errors in the order they appear, so start from the first error-you're showing the last error when I can see other errors above it.

Re: coding issue

u19696098 — Fri, 29 Oct 2021 16:01:57 GMT

Hi Everyone;

Not sure what is happening; if I run with the one of the varibale it gives the result;

but when i run the same code for another variable Common Names; it does not work, please please help me....

Re: coding issue

u19696098 — Fri, 29 Oct 2021 16:05:58 GMT

Please see above I have correctly entered Common_Names but look at the log, every time i get that even though that variable is under NP library and in species table

Re: coding issue

Reeza — Fri, 29 Oct 2021 16:12:13 GMT

Show your full log please to ensure your previous step was also run correctly.
IF common_names doesn't work in this step it shouldn't have worked in the previous step either.

Re: coding issue

u19696098 — Fri, 29 Oct 2021 16:18:54 GMT

What i mean is Common_Names did not work at all, If I run the code eliminating this variable at least for one variable Category, it works.

Re: coding issue

Reeza — Fri, 29 Oct 2021 16:36:24 GMT

What makes you think that the variable is common_names?
Could it be "Common Names'n instead? (EDIT: according to the proc contents output this is correct).

Add the following to the top of your program and run it all again. This should fix your variable names, check it by running a proc contents and ensure your output matches Cynthia's post.

options validvarname = v7;

~~As others have requested if none of these work, post the output of proc contents. That will provide allow us to provide the definitive answer.~~

~~proc contents data=np.species;~~
~~run;~~
EDIT: Saw your proc contents output. Yeah, add that option to the top of your code. Your file was imported with spaces in the names. So if you set the option to validvarname=v7 the names will then be COMMON_NAMES not COMMON NAMES. That space does matter and does mean that your variables should be references as "COMMON NAMES"n or "Category"n - there are likely trailing spaces somewhere here messing things up.

Are you using On Demand for Academics or your own SAS installation?

Re: coding issue

u19696098 — Fri, 29 Oct 2021 16:50:48 GMT

Hi Thanks so much, as code works now with options validvarname = v7; as i forget to include this however, with below codes the output is still showing the 'squirrel' which should not be there and my answer to the question of the beginning post still got wrong;

please help

Re: coding issue

Reeza — Fri, 29 Oct 2021 17:02:20 GMT

Squirrel and squirrel are not the same.

Re: coding issue

Reeza — Fri, 29 Oct 2021 17:03:07 GMT

The options statement should ideally go before your LIBNAME statement though.

Re: coding issue

u19696098 — Fri, 29 Oct 2021 17:14:16 GMT

Hi,

The issue is solved, running code below provided me the correct output. Thanks all for your valuable efforts, appreciated.

Re: coding issue

Kurt_Bremser — Fri, 29 Oct 2021 20:26:21 GMT

It's not common_names, it`s 'Common Names'n (name literal because of the blank).