topic How to create a very simple table with one variable and 1-90 as observations in SAS Procedures

How to create a very simple table with one variable and 1-90 as observations

vanpeltm1785 — Mon, 04 Dec 2017 19:11:57 GMT

Hello,

I realize this is probably super easy, but I don't know how....

Trying to create a table in sas that simply has number 1 - 90:

HEADER
1
2
3
4
5
etc...
SAS EG 7.13

Re: How to create a very simple table with one variable and 1-90 as observations

bstarr — Mon, 04 Dec 2017 19:22:19 GMT

data want;
do HEADER = 1 to 90;
output;
end;
run;

Re: How to create a very simple table with one variable and 1-90 as observations

error_prone — Mon, 04 Dec 2017 19:26:45 GMT

Why do you need a dataset containing the numbers 1 to 90?

The problem can be solved with a small data-step, i recommend reading the sas documentation.

data work.number;
    length header 8;

    do header = 1 to 90;
        output;
    end;
run;

Re: How to create a very simple table with one variable and 1-90 as observations

novinosrin — Mon, 04 Dec 2017 20:00:11 GMT

Hi, sounds like you are learner like me, so I am sharing my learning approach with the following experiments to understand operations, iterations, and explicit output:

/* using infinite increments with support from break and continue structures*/
data w;
	do i= 1 by 1;
		output;

		if i=90 then
			leave;
	end;
run;

/*while expression*/
data w1;
	do while(i<90);
		i+1;
		output;
	end;
run;

/*until expression*/
data w2;
	do until(i=90);
		i+1;
		output;
	end;
run;

/* start and stop with constant operands*/
data w3;
	do i=1 to 90;
		output;
	end;
run;

/* using operands*/
data w4;
	start=1;
	increment=1;
	stop=90;

	do i=start by increment to stop;
		output;
	end;

	keep i;
run;
;