my do loop doesn't work. help me

[LeeSeongWoo_]

data room1 room2 room3 room4 room5 room6 room7 room8 ;
do i=1 to 8 ;
if rooms = i then output room(i) ;

end ;

run;

what should i do if i want to fix room(i) 

[PaigeMiller]

This is not a direct answer to your question, but why do you need eight different data sets? You could keep all the data in one large data set and then do any subsequent processing with a BY statement. It's much simpler.

[LeeSeongWoo_]

Thank you for your reply . but the file is too big 

[PaigeMiller]

---

@LeeSeongWoo_ wrote:

Thank you for your reply . but the file is too big 

---

Too big to do what? How do you know it is too big? Give us information, describe your actual problem instead of avoiding describing the problem.

[ballardw]

---

@LeeSeongWoo_ wrote:

Thank you for your reply . but the file is too big 

---

What is too big? You don't even reference a data set to read from to split into something smaller.

[RW9]

As I posted in another thread today, splitting data out into multiple datasets is really not a good idea.

NOw to do what you want, you can't refere to dataset names by using array syntax,so please post an actual example, with test data in the form of a datastep where you would want to use this, as basically all your code below is doing is creating 8 datasets with one row each, which can be achieved by:

data room1 room2...;
run;

As you can see your example makes no sense at all.

[Astounding]

Do you have an existing data set that contains the variable ROOMS?  Right now, there is no data coming in via a SET or INPUT statement.

[Ron_MacroMaven]

"The file is *-always-* Too Big!"

macro calltext can do this trick.

see section 3.3 Splitting a Data Set

I agree with others: not a good idea to split a data set into subsets.

Figure out how to use either a by-statement or where clause.

Ron Fehd  macro function maven