Need help with sas printing procedure...

[sasNoodle]

Hi everyone, I'm trying to write a proc print that prints to the output screen every 100,000th observation. Is there any easy way to do this?

 

[kdt82]

I can't see a way to do this without subsetting the data first. Something like the following perhaps... Data large is a dummy dataset of 1 million records and data small is taking a record every 100,000. If you have a large dataset this may take a while.
HTH

data large;
do i=1 to 1000000;
   output;
end;
run;

data small;
set large;
if ^mod(_n_,100000);
run;
proc print;run;

 

[krispi]

Hi - I think you need to create an observation number on your source dataset before doing the proc print. Try a variation of this:

data xx; set whatever;
	zz=_n_;
run;


proc print data=xx;
where mod(zz,100000)=0;
run;

 

[krispi]

Actually, thinking about it, a simpler way to get the same result would be to use proc sql, (no proc print required as sql output is automatically printed) - try this...

proc sql;
	select 
	variable1, variable2, etc
	from your_dataset
	where mod(monotonic(),100000)=0
;
quit;

 

[kdt82]

Good point krispi

 

[sasNoodle]

Thanks krispi and kdt82 for your help. This worked!!