topic Can you help me please immediately in SAS Programming

Can you help me please immediately

johnlennon — Mon, 05 Oct 2015 01:08:17 GMT

Hello,

I have this question " Create a new variable called project2 and add 10 points to the project grade of the following students A,B,C,D (keep the grades of other students same)"

Can you please help me out ?

Re: Can you help me please immediately

SASKiwi — Mon, 05 Oct 2015 03:13:12 GMT

Something similar to this:

if student in ('A', 'B', 'C') then grade = grade + 10;

BTW, it would be helpful if you summarised your problem in the title rather than ask for help because that applies to most posters...

Perhaps something like: SAS Coding Question

Re: Can you help me please immediately

michelle_delaurentis_sas_com — Mon, 05 Oct 2015 13:46:53 GMT

I partially agree with SASKiwi's answer except that the grade variable will be over written and you asked for a new variable. Therefore I suggest:

if student in ('A', 'B', 'C') then project2 = project + 10;

Re: Can you help me please immediately

MikeZdeb — Mon, 05 Oct 2015 14:00:28 GMT

Hi, another idea ...

data x;
input student :$1. grade @@;
datalines;
A 50 B 60 C 70 D 33
;

data y;
set x;
grade + 10*(student in ('A' 'B' 'C'));
run;

data set Y ...

Obs student grade

1 A 60
2 B 70
3 C 80
4 D 33

Re: Can you help me please immediately

hbi — Mon, 05 Oct 2015 18:09:00 GMT

Here is a slight variation of Mike's example. This one handles missing values.

data x;
    input student $ grade;
    datalines;
    A 50
    B 60
    C .
    D 33
;
run;

data y;
    set x;
    if student in ('A','B','C','D') then project2 = sum(grade, 10);
run;

Re: Can you help me please immediately

MikeZdeb — Mon, 05 Oct 2015 21:00:12 GMT

Hi, the SUM statement also ignores mising values.

data x;
input student :$1. grade @@;
datalines;
A 50 B 60 C . D 33
;

data y;
set x;
grade + 10*(student in ('A' 'B' 'C'));
run;

data set Y ..

Obs student grade

1 A 60
2 B 70
3 C 10
4 D 33

Re: Can you help me please immediately

hbi — Tue, 06 Oct 2015 00:00:47 GMT

You are right ... the boolean statement student in ('A' 'B' 'C') evaluates to 1; thus, for student 'C', 1*10 = 10.

In short, the sum operator (+) used in conjunction with the product of a boolean result would result in a non-missing value.