topic Re: Create a SAS Array with non-consecutive variable names in SAS Programming

Create a SAS Array with non-consecutive variable names

MB_Analyst — Thu, 14 Dec 2017 14:41:13 GMT

I have this syntax to achieve this result:

data have;
     set want;
          array xs(*) var1-var5 
           all = max(of xs(*));
run:

var1 var2 var3 var4 var5 all

1 . . . . 1

. 3 . . . 3

. . 2 . . 2

. . . 6 . 6

. . . . 8 8

If I have data like this, where var3 is missing, will the same syntax work for this?

var1 var2 var4 var5 all

1 . . . 1

. 3 . . 3

. . 2 . 2

. 6 . . 6

. . . 8 8

Ksharp — Fri, 15 Dec 2017 14:14:52 GMT

data have;
     set want;
           all = max(of var: );
run:

art297 — Fri, 15 Dec 2017 17:59:32 GMT

Or, if your variables names don't start with "var", you could use a variable list that only relies on the variable order in the dataset. i.e.:

data want;
     set have;
          array xs(*) var1--var5;
           all = max(of xs(*));
run;

Art, CEO, AnalystFinder.com

Tom — Fri, 15 Dec 2017 17:48:00 GMT

Yes.

But SAS will create an empty (all missing) variable named VAR3.