topic Re: Creating Variables in SAS Programming

Creating Variables

Vahe_Mar — Thu, 07 Feb 2019 12:14:17 GMT

I need shortest way for creating Var0-Var10 with 0 value.

Sample:

VAR0 VAR1 VAR2 ...

0 0 0

Re: Creating Variables

RW9 — Thu, 07 Feb 2019 12:20:12 GMT

data want;
  array var{10} 8 (0,0,0,0,0,0,0,0,0,0);
run;

That would create var1-var10. There doesn't seem to be a simple method of it:

data want;
  retain var0 var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 0;
run;

data want;
  array x var0-var10;
  do over x;
    x=0;
  end;
run;

I mean you could do:

options missing=0;
data want;
  length var0-var10 8;
run;

But that is not actually setting the value, just changing the system default.

I suppose the real question is why you would need to, are you performing some calculation and want a template to add to or sum with? There is likely to be better methods, but need more information.

Re: Creating Variables

Vahe_Mar — Thu, 07 Feb 2019 12:21:53 GMT

RW9 Thanks for answering. Yes i am calculating something and final data should have 10 variables. Some of calculation have two some of 3 , i need set it together and if have missing values in calculation I will have 0 instead of missing.

Re: Creating Variables

kiranv_ — Thu, 07 Feb 2019 12:22:46 GMT

one way

data want;
retain var1-var10 0;
run;

Re: Creating Variables

kiranv_ — Thu, 07 Feb 2019 12:36:58 GMT

if you have dataset then probably do.

data want;
set have;
array h(*) var0-var10;
do i = 1 to dim(h);
if h(i)= . then 
h(i) = 0;
end;
run;

Re: Creating Variables

Vahe_Mar — Thu, 07 Feb 2019 12:48:41 GMT

Thanks used this way

Re: Creating Variables

RW9 — Thu, 07 Feb 2019 13:13:55 GMT

If your counting something then you shouldn't need to create variables? If the data doesn't have something that you are expecting, either add a template, or pad out the data you already have.

Re: Creating Variables

novinosrin — Thu, 07 Feb 2019 14:20:22 GMT

Is your question just to create an(one) observation?

or is there a bigger objective?

Re: Creating Variables

Vahe_Mar — Fri, 08 Feb 2019 13:24:12 GMT

Dear novinosrin ,
just create one obs its part of coding with other part I am good thanks for asking