topic Re: Proc Freq nlevels in SAS Procedures

Proc Freq nlevels

AmitKB — Thu, 10 Apr 2008 23:48:45 GMT

Hi,
I am trying to get the level counts for the variable market in code listed below. But SAS gives me error. My sas version is SAS 9.1 TS Level1M3.

Thanks in advance,

Amit

code:

rsubmit;
libname try ' library location ' ;
proc freq data=try.temp nlevels;
tables market;
run;
endrsubmit;

error:

ERROR 22-322: Syntax error, expecting one of the following: ;, (, COMPRESS,
DATA, FC, FORMCHAR, NOPRINT, ORDER, PAGE.
ERROR 200-322: The symbol is not recognized and will be ignored.

Re: Proc Freq nlevels

deleted_user — Fri, 11 Apr 2008 12:08:28 GMT

please post the log, from the line that says libname down to the error

Re: Proc Freq nlevels

AmitKB — Fri, 11 Apr 2008 17:21:36 GMT

Here is the log from actual program

5 rsubmit;
NOTE: Remote submit to UNIXBOX commencing.
152 libname merbonus '/intl/iimis1/intl_mr/abothra/merchant/bonus';
NOTE: Libref MERBONUS was successfully assigned as follows:
Engine: V8
Physical Name: /intl/iimis1/intl_mr/abothra/merchant/bonus
153
154 proc freq data=merbonus.exceldata nlevels ;
------- -
22 200
ERROR 22-322: Syntax error, expecting one of the following: ;, (, COMPRESS,
DATA, FC, FORMCHAR, NOPRINT, ORDER, PAGE.
ERROR 200-322: The symbol is not recognized and will be ignored.
155 tables market /noprint ;
156 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE FREQ used:
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: Remote submit to UNIXBOX complete.

Re: Proc Freq nlevels

darrylovia — Fri, 11 Apr 2008 17:55:46 GMT

I think your noprint is in the wrong place

try
proc freq data=merbonus.exceldata nlevels noprint;
tables market ;
run;

vs.

proc freq data=merbonus.exceldata nlevels ;
tables market /noprint;
run;

Re: Proc Freq nlevels

Cynthia_sas — Fri, 11 Apr 2008 18:41:51 GMT

Hi:

I notice that the libref MERBONUS was created with the V8 engine. Is it possible that you are still running SAS 8?

I know that NLEVELS works with SAS 9. I can't remember whether it was an available option in SAS 8 or not. Tech Support could answer that question for sure. I no longer have SAS 8 to test with.

cynthia