topic Re: if any help me to resolve error in SAS Studio

if any help me to resolve error

asundha — Fri, 22 Feb 2019 14:03:36 GMT

data reg;
set oriontst.REGION;

if country =('CA' , 'AU') then
do;
discount=0.10;
discount_type='required';
region='north_america';
end;
else if country ='OTHERS' then
do;
discount=0.05;
discount_type='optional';
region NE 'north_america';
end;
run;

My errors:

71 data reg;

72 set oriontst.supplier;

74 if country =('CA' , 'AU') then

388

200

75 do;

180

ERROR 388-185: Expecting an arithmetic operator.

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

ERROR 180-322: Statement is not valid or it is used out of proper order.

76 discount=0.10;

77 discount_type='required';

78 region='north_america';

79 end;

___

161

80 else if country ='OTHERS' then

____

160

ERROR 161-185: No matching DO/SELECT statement.

ERROR 160-185: No matching IF-THEN clause.

81 do;

82 discount=0.05;

83 discount_type='optional';

84 region NE 'north_america';

______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

85 end;

86 run;

Re: if any help me to resolve error

novinosrin — Fri, 22 Feb 2019 14:07:56 GMT

use IN operator

if country IN ('CA' , 'AU')

how to write code for given task below in attachment

asundha — Fri, 22 Feb 2019 14:08:13 GMT

Re: if any help me to resolve error

PaigeMiller — Fri, 22 Feb 2019 14:08:38 GMT

if country =('CA' , 'AU') then do;

This is not proper syntax. You want

if country in ('CA','AU') then do;

In the future, please click on the {i} icon and paste your log into this window. We need to see your log, and we need to see it formatted properly for ease of reading, so please DO NOT SKIP THIS STEP.

Re: if any help me to resolve error

Kurt_Bremser — Fri, 22 Feb 2019 14:11:34 GMT

Use the in operator:

if country in ('CA','AU') then do;

and

region NE 'north_america';

is not a valid SAS statement. What should it do?

PS see my footnotes for hints on posting code and logs ({i} and "little running man" buttons).

Re: if any help me to resolve error

asundha — Fri, 22 Feb 2019 14:11:47 GMT

If I use in also
I'm getting error like this
Statement is not valid or it is used out of order

Re: if any help me to resolve error

novinosrin — Fri, 22 Feb 2019 14:15:31 GMT

I think that's because

region NE 'north_america'; /*wrong assignment*/

is wrong in your else clause

else if country ='OTHERS' then
do;
discount=0.05;
discount_type='optional';
region NE 'north_america'; Wrong
end;

Re: if any help me to resolve error

asundha — Fri, 22 Feb 2019 14:15:47 GMT

just now i was added the task in attachment

Re: if any help me to resolve error

asundha — Fri, 22 Feb 2019 14:18:05 GMT

Re: if any help me to resolve error

asundha — Fri, 22 Feb 2019 14:20:26 GMT

ok then what is the correct code .

see in the attachment(task) below.

Re: how to write code for given task below in attachment

RW9 — Fri, 22 Feb 2019 14:25:14 GMT

Sorry, we are really not here to do your homework. That question is very simple, and it is for you to do the programming on. If you have specific questions, come back with them, show what you have done and where you are stuck, and avoid using attachments - put text in the body of the post.

Re: if any help me to resolve error

Kurt_Bremser — Fri, 22 Feb 2019 14:28:07 GMT

@asundha wrote:
If I use in also
I'm getting error like this
Statement is not valid or it is used out of order

The log points you to invalid code, and see my previous post.

Re: if any help me to resolve error

novinosrin — Fri, 22 Feb 2019 14:48:22 GMT

Correction:

region = 'NOT north_america';

Re: if any help me to resolve error

Reeza — Fri, 22 Feb 2019 16:30:24 GMT

Comment every line and you'll find your mistake.