topic new to array in SAS Procedures

new to array

Steelers_In_DC — Fri, 08 Feb 2013 20:29:53 GMT

Hello, I am trying to get the hang of arrays and having trouble. The below code is intended to take current weight and get a goal weight. Instead of doing that I am adding two variables and not calculating goal weight. If anyone can see the errors and advise I would appreciate it. Thanks:

data start;

infile datalines;

input name $ sex $ weight1 weight2;

cards;

sara f 120 119

bill m 220 219

;

run;

data end (drop=i);

set start;

array start_array{*} _numeric_;

array end_array{*} goal_weight1-goal_weight2;

if sex=f then do

i=1 to 2;

end_array{i}=start_array{i}*.95;

end;

else if sex=m then do

i=1 to 2;

end_array{i}=start_array{i}*.9;

end;

run;

Re: new to array

Haikuo — Fri, 08 Feb 2013 21:02:47 GMT

Not sure if you have other issues with the code, but is it supposed to be like:

if sex='f' then do

else if sex='m' then do

Haikuo

Re: new to array

PGStats — Fri, 08 Feb 2013 21:02:55 GMT

The only prroblem I see is the absence of quotes around f and m in your if statements. PG

Re: new to array

Tom — Fri, 08 Feb 2013 21:15:38 GMT

Other than the missing quotes around the string literals and the strange indentation the program looks fine.

It is converting the existing weights to goal weights by multiplying by a fraction that depends on gender.

What did you want to do differently?

goal_ goal_

Obs name sex weight1 weight2 weight1 weight2

1 sara f 120 119 114 113.05

2 bill m 220 219 198 197.10

Re: new to array

Cynthia_sas — Fri, 08 Feb 2013 23:14:47 GMT

Hi:

In answer to your more general question about arrays, I have always found this to be a good paper.

http://support.sas.com/rnd/papers/sgf07/arrays1780.pdf

But, as you learned, the problem was not so much with array processing as IF statement syntax and the need for quoting character strings in comparisons.

cynthia