DATA Step, Macro, Functions and more

Limit the results to 10

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

Limit the results to 10

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;


Accepted Solutions
Solution
‎03-17-2017 02:44 PM
Super User
Posts: 5,085

Re: Limit the results to 10

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;

View solution in original post


All Replies
Solution
‎03-17-2017 02:44 PM
Super User
Posts: 5,085

Re: Limit the results to 10

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;

Contributor
Posts: 21

Re: Limit the results to 10

The number of observations printed by PROC PRINT
Contributor
Posts: 21

Re: Limit the results to 10

It worked, thank you!
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 131 views
  • 0 likes
  • 2 in conversation