Help using Base SAS procedures

Input all recurring independent variables

Reply
Contributor
Posts: 21

Input all recurring independent variables

Hi SAS Community,

 

I have currently 300 variables (labelled as 'Distance1' to 'Distance300') and wish to incorporate this into proc statement. I am using Proc Mixed currently. How do I make a statement/ loop such that it automatically incorporates all the 300 variables without having to specify them manually (one by one)?

 

Does anyone has an idea? Comments and feedback will be greatly appreciated.

 

Best,


David

Super User
Posts: 7,760

Re: Input all recurring independent variables

Usually SAS allows the construct Distance1-Distance300 to be used where a list of variables is needed.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 7,942

Re: Input all recurring independent variables

As an alternative to @KurtBremser suggestion, you could normalise the dataset, that is make a long, rather than wide dataset.

...       DISTANCE_NUM    DISTANCE_RES

...       1                           abc

...       2                           def

 

And then use a by statement on your procedure, i.e.

proc means data=have;
  by ... distance_num;
  var distance_res;
  output...;
run;
Ask a Question
Discussion stats
  • 2 replies
  • 260 views
  • 0 likes
  • 3 in conversation