topic Re: Doubt in write a code in SAS Programming

Doubt in write a code

Navaneethan6 — Fri, 24 Nov 2023 10:24:17 GMT

Hi Team, I am practicing for the SAS base certification I have a scenario question which share by friend, I start to write the program for that I can't understand some points in the question. could please help to understand that.

1. Create data set ‘scoredata0’ from importing the excel data ‘score_data_miss777’

2. In data step,

a. create a new data set ‘scoredata1’ from ‘scoredata0’ using set statement

b. convert 777 in variables Score1,2,3 to missing (periods) using if… then … else statement

c. calculate average of scores using SAS function MEAN

d. using the calculated average score to create Grade categories A, B, C, D, F

3. Print data ‘scoredata1’ using Proc Print.

I can't understand the option b and don't know how to write the code for option d.

code I tried is below.

proc import datafile="/home/u62129231/EPG1V2/SAS P 1/score_data_miss777.xlsx"

dbms=xlsx out=scoredata0 replace;

run;

data scoredata1;

set work.scoredata0;

if score1=. then

do;

score1=777;

end;

if score2=. then

do;

score2=777;

end;

if score3=. then

do;

score3=777;

end;

run;

proc means data=scoredata1;

run;

proc print data=scoredata1;

run;

Re: Doubt in write a code

PaigeMiller — Fri, 24 Nov 2023 10:30:45 GMT

Your code does not do

convert 777 in variables Score1,2,3 to missing (periods) using if… then … else statement

Instead it does things the other way around, it converts missing to 777.

Re: Doubt in write a code

andreas_lds — Fri, 24 Nov 2023 11:38:55 GMT

"c. calculate average of scores using SAS function MEAN"

>> you need to use the mean-function inside the data step, not the mean procedure

"d. using the calculated average score to create Grade categories A, B, C, D, F"

>> hardly possible without knowing which score to map to which letter. With the information a format or if-then-else could be used or a select-block.

Re: Doubt in write a code

Navaneethan6 — Fri, 24 Nov 2023 12:23:38 GMT

Is Now my code is correct ?

proc import datafile="/home/u62129231/EPG1V2/SAS P 1/score_data_miss777.xlsx"
dbms=xlsx out=scoredata0 replace;
run;

data scoredata1;
set work.scoredata0;

if score1=777 then
do;
score1=.;
end;

if score2=777 then
do;
score2=.;
end;

if score3=777 then
do;
score3=.;
end;

run;

proc means data=scoredata1;
run;

proc print data=scoredata1;
run;

Re: Doubt in write a code

PaigeMiller — Fri, 24 Nov 2023 13:58:21 GMT

@Navaneethan6 wrote:

Is Now my code is correct ?

Test it yourself.

Re: Doubt in write a code

Navaneethan6 — Fri, 24 Nov 2023 16:10:28 GMT

Yeah, I will definitely test the code, but I need to under the question. should I need to do those 777 values as missing values right?

Re: Doubt in write a code

PaigeMiller — Fri, 24 Nov 2023 17:39:06 GMT

@Navaneethan6 wrote:

Yeah, I will definitely test the code, but I need to under the question. should I need to do those 777 values as missing values right?

I don't understand your question.

Re: Doubt in write a code

Tom — Fri, 24 Nov 2023 17:47:31 GMT

I think that they want you to do 2a to 2d in a single data step.

Also did they provide a rule for converting an average score into a letter grade? What scores should considered an A? etc.

Re: Doubt in write a code

Tom — Fri, 24 Nov 2023 17:52:41 GMT

@Navaneethan6 wrote:

Yeah, I will definitely test the code, but I need to under the question. should I need to do those 777 values as missing values right?

Answer this question. When assigning letter grades do you use the class's average score? Or do you use the average score for an individual student in the class?