topic Re: How to return data in a variable if they are of specific value in SAS Programming

How to return data in a variable if they are of specific value

sulaiman1760 — Sun, 27 Jun 2021 12:14:04 GMT

Hi everyone,

I am new in SAS and I am currently working on my first assignment.

I have a PISA data set, where I have to find all the schools that have a reading score above 500.

Now, I do have a variable for school 'schoolid' and a variable for reading score 'score_r'.

I thought about making an if-statement that returns the value in schoolid, whenever they fulfilled score_r>500, but do you know how I can write this in SAS the proper way?

best regards

Sulaiman.

Re: How to return data in a variable if they are of specific value

PaigeMiller — Sun, 27 Jun 2021 12:34:27 GMT

if score_r>500 then ... ;

It's not really clear to me what you want to have happen when score_r>500, so that part requires more explanation. The value of school_id is already in the variable school_id, so you don't really need to do anything, or maybe I'm just not understanding what you are asking.

Re: How to return data in a variable if they are of specific value

sulaiman1760 — Sun, 27 Jun 2021 12:34:37 GMT

We have data for couple schools lets say:
school1 school2 ...
they all have a different reading score, so maybe school1 has reading score of 501, that would be score_r=501 and school2 has score_r=499.
In this task I need to make a code that only returns school1, because that is the only one with score_r>500. Excuse me, if the question was unclear.

Re: How to return data in a variable if they are of specific value

PaigeMiller — Sun, 27 Jun 2021 12:37:37 GMT

In this task I need to make a code that only returns school1, because that is the only one with score_r>500

So you want to eliminate the school with score_r<=500 from the data set?

data want;
    set have;
    if score_r>500;
run;

Re: How to return data in a variable if they are of specific value

sulaiman1760 — Sun, 27 Jun 2021 12:39:11 GMT

Thanks!