topic Re: my do loop doesn't work. help me in SAS Programming

my do loop doesn't work. help me

LeeSeongWoo_ — Wed, 06 Sep 2017 13:54:15 GMT

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)

Re: my do loop doesn't work. help me

PaigeMiller — Wed, 06 Sep 2017 13:57:57 GMT

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.

Re: my do loop doesn't work. help me

RW9 — Wed, 06 Sep 2017 13:58:25 GMT

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.

Re: my do loop doesn't work. help me

LeeSeongWoo_ — Wed, 06 Sep 2017 13:59:27 GMT

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

Re: my do loop doesn't work. help me

Astounding — Wed, 06 Sep 2017 14:00:19 GMT

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.

Re: my do loop doesn't work. help me

PaigeMiller — Wed, 06 Sep 2017 14:01:03 GMT

@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.

Re: my do loop doesn't work. help me

Ron_MacroMaven — Wed, 06 Sep 2017 14:05:04 GMT

"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

Re: my do loop doesn't work. help me

ballardw — Wed, 06 Sep 2017 14:38:12 GMT

@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.