topic Re: How to use IF THEN ELSE in SAS DATA STEP in ODS and Base Reporting

How to use IF THEN ELSE in SAS DATA STEP

inquistive — Thu, 14 Oct 2021 19:41:43 GMT

Hi experts,

I am a SAS neophyte. I am trying to assign different values to a variable based on other variable values in SAS DATA step. Please do not suggest case when expressions of proc sql(which I already know).

Please point out where my code went wrong and also suggest what I need to do. Appreciate your patience and support in advance. My code looks like this;

Data student;

set list (keep= studentid student_name student_type specialty1 stream specialty2 specialtyType1) ;
length specialtyType1 $15.;
specilatyType1 =' ';
if (student_type IN ('rational', 'hardworking') or (student_type= 'Active' and specialty1 IN ('math', 'science', 'computer science')))
then specilatyType1=' Stem';
else specilatyType1= 'Non stem';

end';
run;

Re: How to use IF THEN ELSE in SAS DATA STEP

sbxkoenk — Thu, 14 Oct 2021 19:44:11 GMT

What's the

end';

doing there?

Koen

Re: How to use IF THEN ELSE in SAS DATA STEP

PaigeMiller — Thu, 14 Oct 2021 19:47:15 GMT

You have the following line of code

end';

which should be deleted.

Other than that, why do you think anything is wrong? Explain.

Re: How to use IF THEN ELSE in SAS DATA STEP

inquistive — Thu, 14 Oct 2021 19:47:17 GMT

My apologies. the apostrophe evaded my eyes. it's not in my code.

Re: How to use IF THEN ELSE in SAS DATA STEP

inquistive — Thu, 14 Oct 2021 19:47:37 GMT

My apologies. The apostrophe evaded my eyes. it's not in my code.

Re: How to use IF THEN ELSE in SAS DATA STEP

WarrenKuhfeld — Thu, 14 Oct 2021 19:54:36 GMT

You will also want to spell "specialty" consistently.

Re: How to use IF THEN ELSE in SAS DATA STEP

ballardw — Thu, 14 Oct 2021 20:03:06 GMT

@inquistive wrote:

Hi experts,

I am a SAS neophyte. I am trying to assign different values to a variable based on other variable values in SAS DATA step. Please do not suggest case when expressions of proc sql(which I already know).

Please point out where my code went wrong and also suggest what I need to do. Appreciate your patience and support in advance. My code looks like this;

Data student;

set list (keep= studentid student_name student_type specialty1 stream specialty2 specialtyType1) ;
length specialtyType1 $15.;
specilatyType1 =' ';
if (student_type IN ('rational', 'hardworking') or (student_type= 'Active' and specialty1 IN ('math', 'science', 'computer science')))
then specilatyType1=' Stem';
else specilatyType1= 'Non stem';

end';
run;

When a question like " point out where my code went wrong" arises the first thing to ask, is what did the LOG look like. Copy the entire log including all notes, messages, warnings or erorrs, for the data step or procedure that you think something went wrong with, on the forum open a text box using the </> icon above the message window and paste the log text into the box.

Then things like retyped errant apostrophes are not the problem.

Another possible typing error but if actually in your data different spellings of your variable.

length specialtyType1 $15.;
specilatyType1 =' ';

Which defines a length for one variable but the SPECILATY variable will have a length of 1. Then in the later statements you attempt to assign values to the one character length variable:

then specilatyType1=' Stem';
else specilatyType1= 'Non stem';

Spelling counts in programming.

You should have a note in the Log that variable Speciality is uninitialized. Which if you copy the log as requested we would have seen an pointed out sooner.
.