topic Re: Variables listing in SAS Programming

Variables listing

Chieko — Tue, 08 Dec 2015 16:53:05 GMT

I have variables name like this

Total1, Male 2 Female1,Total2, Male 2 Female2, Total3, Male 3 Female3, Total4, Male 4 Female4..... Total n, Male n, Female n.

Is there any shortcuts to such variable names to list for input statement? Like X1 X2 X3 --> X1- X3

Re: Variables listing

Haikuo — Tue, 08 Dec 2015 17:00:46 GMT

You just did that! Have you tried?

data test;
input x1-x3;
cards;
 1 2 3
 ;

Edit: After viewing @Reeza, I realize that I misread your question. Please ignore my response. I didn't delete it just for the sake of record.

Re: Variables listing

Reeza — Tue, 08 Dec 2015 16:57:49 GMT

Unfortunately not 😞

You could create a macro to create the names, but if you only have 3 it's not useful.

data _null_;
length var $1000.;

do i=1 to 10;

var=catt(var, " Total"||put(i, 2. -l), " Male"||put(i, 2. -l), " Female"||put(i, 2. -l));
end;

call symputx('input_list', var);
run;

%put &input_list;

Re: Variables listing

Astounding — Tue, 08 Dec 2015 17:25:44 GMT

You will need to know how many sets appear on a line. And even then the programming is somewhat sophisticated:

data want;

infile rawdata dlm=',';

array total {5};

array male {5};

array female {5};

do J=1 to 5;

input total{J} male{J} female{J} @ ;

end;

run;

The variables won't be stored in the same order internally, but you can certainly shorten the program. Good luck.

Re: Variables listing

Chieko — Tue, 08 Dec 2015 19:57:09 GMT

Thank you for your quick resposne to my question. I have more than 100 sets it would be useful

Re: Variables listing

Chieko — Tue, 08 Dec 2015 17:48:07 GMT

Thank you anyway