topic Re: NO Print option in sas EG in New SAS User

NO Print option in sas EG

sivastat08 — Wed, 17 Jul 2019 14:03:08 GMT

Hi All, I want to use no print option when data size is large .Please help me on the below.

Below is my sample code, if my data output exceeds 1000 observation then it should not print the output.

data xyz;
set sashelp.class;
run;

proc print data=xyz;
run;

proc report data=xyz (option=noprint);

run;

proc sql ;
select * from sashelp.class;
run;

Thanks,

Siva

Re: NO Print option in sas EG

Tom — Wed, 17 Jul 2019 15:17:54 GMT

I don't understand the request.

Do you want to only print a few observations to provide an example?

proc print data=xyz(obs=10);
title2 'First 10 observations';
run;

Re: NO Print option in sas EG

sivastat08 — Wed, 17 Jul 2019 15:21:13 GMT

Thanks for answer Tom.

Re: NO Print option in sas EG

Reeza — Wed, 17 Jul 2019 15:22:43 GMT

Not sure what you mean. You want to conditionally execute the PROC PRINT or REPORT?

Do you want to limit the observations or not have any output.

You can add the data set option OBS=1000 to the data sets to have it only print 1000 max.

proc print data=xyz (obs=1000);
run;

Re: NO Print option in sas EG

sivastat08 — Wed, 17 Jul 2019 16:21:22 GMT

Thanks for the replay Reeza.

if My data exceeds 1000 then it shout not print otherwise it should print .

your code is working fine.Thanks for the answer Reeza

Re: NO Print option in sas EG

Reeza — Wed, 17 Jul 2019 16:28:46 GMT

1. Get the number of observations in the data set.

2. Decide to print or not.

proc sql noprint;
create table xyz as
select * from sashelp.class;
quit;

*gets count;
%let count = &sqlobs;

data _null_;
if &count <= 1000 then do;
      call execute('proc print data=xyz; run;');
end;

run;

There are various ways to get the count and various ways to conditionally run things, I've illustrated one above. I'm assuming your code is not realistic and simplified for the forum so just giving the generic solution.