topic Re: Limit the results to 10 in SAS Programming

Limit the results to 10

pacruz — Fri, 17 Mar 2017 18:31:00 GMT

I have the following code but want to limit the result to 10 instead of all the data. I thought firstobs=10 will make it happen but it did not. Please help!

DATA two;
infile 'C:\Users\paul\Downloads\btt.dat' firstobs=10;
input Childid 1-4 Sex 6 Bweight 8-11 Gestage 13-14 Momage 16-17
Parity 19 Mdbp 25-27 Momeduc 29 Mmedaid 31 socio 33 dbp5 35-37 sbp5 39-41
ht5 43-47 wt5 49-52 hdl5 54-57 ldl5 59-62 trig5 64-67 smoke5 69 medaid5 71
socio5 73;
BMI = ht5 / wt5**2;
run;
proc print data=two;
var Childid ht5 wt5 BMI;
run;

Re: Limit the results to 10

Astounding — Fri, 17 Mar 2017 18:40:16 GMT

Which are you trying to limit:

The number of observations in TWO
The number of observations printed by PROC PRINT

To limit the latter, use:

proc print data=two (obs=10);

var Childid ht5 wt5 BMI;
run;

Re: Limit the results to 10

pacruz — Fri, 17 Mar 2017 18:43:08 GMT

The number of observations printed by PROC PRINT

Re: Limit the results to 10

pacruz — Fri, 17 Mar 2017 18:44:27 GMT

It worked, thank you!