topic Re: Array: variables numeric and character start same in SAS Programming

Array: variables numeric and character start same

mansour_ib_sas — Wed, 22 Aug 2018 10:17:38 GMT

Hello,

I have numeric variables and characters that start with x.

I want to create two vectors as follows, but I can not.

data tab1;
input id x1 x2 x3 x4 x5 x6 $ X7 $;
cards;
1 3 2 2 . 1 a b
1 . 1 1 3 2 . b
1 9 . 3 9 6 . b
1 8 . 7 3 2 a b
1 8 2 . 6 . a b
1 6 5 . . 9 a .
2 1 3 . 8 . . b
2 2 5 8 . . a b
2 3 3 11 . . a b
2 4 3 9 . 10 a b
;
run;

data tab2;
set tab1;

array Xnum(*) x: _numeric_;

array Xchar(*) x: _CHARACTER_;

/*Instructions*/
run;

Is there a possibility to do this in sas?

example:

use these options as functions

_numeric_ (x: )

_character_ (y: )

Thank you

Re: Array: variables numeric and character start same

RW9 — Wed, 22 Aug 2018 10:21:12 GMT

Just don't specify the x: part:

data tab1;
  input id x1 x2 x3 x4 x5 x6 $ X7 $;cards;1 3 2 2 . 1 a b1 . 1 1 3 2 . b1 9 . 3 9 6 . b1 8 . 7 3 2 a b1 8 2 . 6 . a b1 6 5 . . 9 a .2 1 3 . 8 . . b2 2 5 8 . . a b2 3 3 11 . . a b2 4 3 9 . 10 a b;
run;

data tab2;
  set tab1;  
  array xnum(*) _numeric_;
  array xchar(*) _character_;
/*Instructions*/
run;

True you will need to do a check to see if vname="id" and not do your logic for that one (as id is also numeric).

Otherwise you will need to build lists of variables from sashelp.vcolumn, which is harder.

Re: Array: variables numeric and character start same

Kurt_Bremser — Wed, 22 Aug 2018 10:23:36 GMT

Use from-to variable lists:

data tab1;
input id x1 x2 x3 x4 x5 x6 $ X7 $;
cards;
1 3 2 2 . 1 a b
1 . 1 1 3 2 . b
1 9 . 3 9 6 . b
1 8 . 7 3 2 a b
1 8 2 . 6 . a b
1 6 5 . . 9 a .
2 1 3 . 8 . . b
2 2 5 8 . . a b
2 3 3 11 . . a b
2 4 3 9 . 10 a b
;
run;

data tab2;
set tab1;
array Xnum(*) x1-x5;
array Xchar(*) x6-x7;
/*Instructions*/
run;

Re: Array: variables numeric and character start same

Astounding — Wed, 22 Aug 2018 11:59:36 GMT

Here's a variation that doesn't require you to sort through which are numeric and which are character.

array nums {*} x1-numeric-x7;

array chars {*} x1-character-x7;

Re: Array: variables numeric and character start same

Kurt_Bremser — Wed, 22 Aug 2018 12:04:05 GMT

Learned something new. Thanks, @Astounding!

Re: Array: variables numeric and character start same

Ksharp — Wed, 22 Aug 2018 14:45:45 GMT


data tab2;
set tab1;
array Xnum(*) x1-numeric-x7;
array Xchar(*) x1-character-x7;
run;

Re: Array: variables numeric and character start same

mansour_ib_sas — Wed, 22 Aug 2018 17:12:05 GMT

thank you