Variables listing

[Chieko]

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

[Haikuo]

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.

[Chieko]

Thank you anyway

[Reeza]

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;

[Chieko · Accepted solution]

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

[Astounding]

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.