How can I have both options where and obs in one proc print?

helper27 — Mon, 09 Mar 2020 03:47:30 GMT

Hi, I am trying to get slipper product in first 50 observation and I am using following syntax.However it showing error message

ERROR 22-7: Invalid option name (.

proc print data=sashelp.shoes (where=(product="Slipper") (obs=50);
run;

Kindly help. Thanks in advance!

Re: How can I have both options where and obs in one proc print?

Reeza — Mon, 09 Mar 2020 04:04:38 GMT

You have 3 open parenthesis and only 2 closing parenthesis.

proc print data=sashelp.shoes ( where=(product="Slipper") obs=50 ) ;

You don't need extra parentheses around the obs option.

@helper27 wrote:

Hi, I am trying to get slipper product in first 50 observation and I am using following syntax.However it showing error message

22

ERROR 22-7: Invalid option name (.
 
proc print data=sashelp.shoes ( where=(product="Slipper") (obs=50) ;
run;

Kindly help. Thanks in advance!

topic How can I have both options where and obs in one proc print? in SAS Studio

How can I have both options where and obs in one proc print?

Re: How can I have both options where and obs in one proc print?