topic Re: Unable to figure error in else if then statement in SAS Programming

Unable to figure error in else if then statement

girlieq97 — Fri, 05 Oct 2018 02:05:09 GMT

Hello, thank you for any and all help. I am trying to run the below code and keep getting the below errors. Any suggestions on what I am doing wrong?

data temp;
set dat.finger;

if missing=1 then do;
segmentation='mine';
rNumb2=ranuni(5678);
if rNumb2< 0.50 then sun=1;
else sun=2;

If control not in (‘C’,’T’) then rNumb=ranuni(1234);
If control=’C’ then control2=’C’;
Else if control=’T’ then control2=’T’;
Else if rNumb<= 0.25 then control2='C';
else control2='T';

end;

run;

ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant,
a missing value, iterator, (.

ERROR 76-322: Syntax error, statement will be ignored.

ERROR 390-185: Expecting an relational or arithmetic operator.

ERROR 200-322: The symbol is not recognized and will be ignored.

Re: Unable to figure error in else if then statement

novinosrin — Fri, 05 Oct 2018 02:26:54 GMT

 data temp;
set dat.finger;


if missing=1 then do;
segmentation='mine';
rNumb2=ranuni(5678);
if rNumb2< 0.50 then sun=1;
else sun=2;

If control not in ('C','T') then rNumb=ranuni(1234);
If control='C' then control2='C';
Else if control='T' then control2='T';
Else if rNumb<= 0.25 then control2='C';
else control2='T';

end;

run;

Re: Unable to figure error in else if then statement

VDD — Fri, 05 Oct 2018 02:38:10 GMT

@girlieq97try this code

data temp;
set dat.finger;

if missing=1 then do;
segmentation='mine';
rNumb2=ranuni(5678);
if rNumb2< 0.50 then sun=1;
else sun=2;
If control not in ('C','T') then rNumb=ranuni(1234);
If control='C' then control2='C';
Else if control='T' then control2='T';
Else if rNumb<= 0.25 then control2='C';
else control2='T';

end;
run;

I think you were using the ` rather than the ' lol, small thing will get you.

`C' and 'C' mean different things to SAS you mixed up the quoiting.

Re: Unable to figure error in else if then statement

girlieq97 — Fri, 05 Oct 2018 02:43:48 GMT

thank you VDD for replying - omgosh something so simple! I reran it and now am getting

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
35:47 36:52 37:44 38:23
NOTE: Variable control is uninitialized.
NOTE: There were 0 observations read from the data set DAT.finger
NOTE: The data set WORK.TEMP has 0 observations and 256 variables.

Re: Unable to figure error in else if then statement

girlieq97 — Fri, 05 Oct 2018 02:44:42 GMT

thank you - very much

Re: Unable to figure error in else if then statement

VDD — Fri, 05 Oct 2018 02:48:51 GMT

do you have a list of the variables in SAS dataset DAT.finger?

is control in that list?

Re: Unable to figure error in else if then statement

girlieq97 — Fri, 05 Oct 2018 02:52:55 GMT

the whole run takes 90 mins - this was the one piece that seemed to be holding me up so I was trying to figure it out in EG. I am going to try and run the whole code in Unix. I will let you know - I don't think control is showing in the dataset because it was erroring out at first. I will post again when run is done. thank you so much!!

Re: Unable to figure error in else if then statement

VDD — Fri, 05 Oct 2018 02:55:32 GMT

good luck.

Re: Unable to figure error in else if then statement

girlieq97 — Fri, 05 Oct 2018 05:09:08 GMT

no luck 😕 control is missing from the dataset and another variable. It is already 10pm my time so going to call it a night and start fresh in the morning. thank you for your help though at least that is one less thing I have to worry about in the morning 🙂

Re: Unable to figure error in else if then statement

Kurt_Bremser — Fri, 05 Oct 2018 06:17:46 GMT

The bad quotes are most probably an artifact caused by a word processor.

NEVER use a word processor in programming, use text editors like notepad++ or the SAS Enhanced Editor.

Word processors may be used in documentation, but as a frontend for programming they are mostly useless.

Since I don't have dat.finger, I can't test it, but try

data temp;
set dat.finger;
if missing = 1
then do;
  segmentation = 'mine';
  rNumb2 = ranuni(5678);
  if rNumb2 < 0.50
  then sun = 1;
  else sun = 2;
  if control in ('C','T')
  then control2 = control;
  else do;
    rNumb = ranuni(1234);
    if rNumb <= 0.25
    then control2 = 'C';
    else control2 = 'T';
  end;
end;
run;

and see if you get your desired result. I've tried to straighten out the unwieldy if-then-else tree that's often hard to maintain.

Re: Unable to figure error in else if then statement

Kurt_Bremser — Fri, 05 Oct 2018 06:26:03 GMT

@girlieq97 wrote:

thank you VDD for replying - omgosh something so simple! I reran it and now am getting

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
35:47 36:52 37:44 38:23
NOTE: Variable control is uninitialized.
NOTE: There were 0 observations read from the data set DAT.finger
NOTE: The data set WORK.TEMP has 0 observations and 256 variables.

Maxim 3: know your data.

Check if the variables that you want to use are there (proc contents, table view)

Maxim 25: clean log, Maxim 31: computers are dumb

After following Maxim 3, use variables correctly; if type conversions are necessary, do them explicitly yourself, so you have control over formats etc. Don't let that be done automatically, automatisms in software might change.

Since you do not have a where condition in your code, this also means that dat.finger has no observations. Which means that this step can never have run for 90 minutes, so your overall code has to be much larger, and an empty dataset points to a severe problem further up in the code. Clean out your code step-by-step from the top. Mark steps and use "run selected".

Re: Unable to figure error in else if then statement

girlieq97 — Fri, 05 Oct 2018 15:28:10 GMT

Thank you for your help and observations. This was new code that I was adding to an already establish code run. So I was testing it outside of the larger code. You are absolutely right though I copied the code from a word document and I should have typed it out myself and I was not familiar with the data. I have gotten it to run correctly with the desired results since last night and am good to go this morning.

Re: Unable to figure error in else if then statement

VDD — Fri, 05 Oct 2018 15:48:22 GMT

Great, it is nice to hear that you have that road-block removed from your path.