topic Re: Proc contents in SAS Programming

Proc contents

mcgannmary1 — Fri, 05 Jul 2019 15:03:28 GMT

Hi, This should be an easy one. I am trying to run proc contents as written below...

/*Count of sterilization failures by type by diagnosis*/

data deliveries;
set 'H:Deliveries\pcori_preg_diag_final.sas7bdat';
run;

proc contents;
deliveries;
run;

And I am getting this error message:

4 proc contents;
NOTE: Writing HTML Body file: sashtml.htm
5 deliveries;
----------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
6 run;

What am I missing?

Thank you!

Re: Proc contents

mcgannmary1 — Fri, 05 Jul 2019 15:04:00 GMT

I have no idea how that smiley face showed up in my code!

Re: Proc contents

PaigeMiller — Fri, 05 Jul 2019 15:05:30 GMT

proc contents data=deliveries;
run;

Re: Proc contents

PaigeMiller — Fri, 05 Jul 2019 15:09:26 GMT

@mcgannmary1 wrote:
I have no idea how that smiley face showed up in my code!

when pasting or typing SAS code, you need to first click on the running man icon and then type or paste your code into that window. Then the forum software will format the text as actual SAS code, and the colon followed by right-parenthesis (or colon follow by letter D, etc.) will not be intrepreted as a smiley face.

Re: Proc contents

Reeza — Fri, 05 Jul 2019 15:18:00 GMT

It's not common to see the full path in your SET statement. It's more usual to see a libname referenced and then youcopy the data set over to use.

libname source 'H:\Deliveries\';
data deliveries;
set source.pcori_preg_diag_final;
run;

proc contents data=deliveries;
run;

Re: Proc contents

Tom — Fri, 05 Jul 2019 15:23:09 GMT

There is no need to make a copy of your data first before asking PROC CONTENTS (or any other proc) to use it.

proc contents data='H:\deliveries\pcori_preg_diag_final.sas7bdat';
run;

Remember to start your paths with \ or else Windows will treat them as relative, even when prefixed with a drive letter.

Re: Proc contents

mcgannmary1 — Fri, 05 Jul 2019 15:28:00 GMT

Thank you for your speedy reply.

The code you shared worked!:)

Re: Proc contents

mcgannmary1 — Fri, 05 Jul 2019 15:30:45 GMT

Hmmmm....the proc freq still doesn't work. Is there something wrong with the data step?

105 /*proc contents data='H:\PCORI\Deliveries\pcori_preg_diag_final.sas7bdat';*/
106 /*run; */
107
108 proc freq;
109 category;
--------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
110 run;

Re: Proc contents

PaigeMiller — Fri, 05 Jul 2019 15:34:30 GMT

@mcgannmary1 wrote:

108 proc freq;
109 category;
--------
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
110 run;

It's not clear what you are trying to do here in PROC FREQ, as there is no such thing as a CATEGORY statement in PROC FREQ.

Since this is independent of your earlier problem with PROC CONTENTS, you probably ought to start a new thread on this, rather than discuss it here.

Re: Proc contents

mcgannmary1 — Fri, 05 Jul 2019 15:35:39 GMT

Thank you!

Re: Proc contents

Reeza — Fri, 05 Jul 2019 15:37:53 GMT

You're missing the data= statement on your proc freq, the same thing you did with your PROC CONTENTS. For a proc to know what data set you're working with you should always put an explicit DATA= after the PROC name. If you don't, it uses the last generated file - not in the order of the program but what you ran, so it's very easy to get errors and wrong results when you don't use the DATA= on your PROC STATEMENTS. Especially at the beginning.

Re: Proc contents

Tom — Fri, 05 Jul 2019 15:38:15 GMT

Most procs will support the DATA= option on the PROC statement. But when in doubt look at the documentation for the PROC.

For PROC FREQ you need to use a TABLES statement to list of variables (or variable combinations) that you want to analyze.

proc freq data=deliveries;
  tables category;
run;