Proc Content Errors

BLT2023 — Tue, 26 Sep 2023 20:34:54 GMT

While working on a project for class, I have written the following code:

LIBNAME Check XLSX "&CourseRoot/CDPHE Study/Data/1_Source/Insurance.xlsx";
LIBNAME Check CLEAR;

LIBNAME	CoImpt XLSX "&CourseRoot/CDPHE Study/Data/1_Source/Insurance.xlsx";
PROC PRINT
		DATA = CoImpt.Insurance
		LABEL;
	RUN;
	
	PROC CONTENTS;
	RUN;

When I do not include the Proc Contents, it runs fine. When I include the Proc Contents, I get two error messages:

ERROR: Couldn't find range or sheet in spreadsheet

ERROR: File COIMPT.EDUCATION.DATA does not exist.

Below is the log for reference. Where have I gone wrong?

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         LIBNAME Check XLSX "&CourseRoot/CDPHE Study/Data/1_Source/Insurance.xlsx";
 NOTE: Libref CHECK was successfully assigned as follows: 
       Engine:        XLSX 
       Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/Insurance.xlsx
 70         LIBNAME Check CLEAR;
 NOTE: Libref CHECK has been deassigned.
 71         
 72         LIBNAMECoImpt XLSX "&CourseRoot/CDPHE Study/Data/1_Source/Insurance.xlsx";
 NOTE: Libref COIMPT was successfully assigned as follows: 
       Engine:        XLSX 
       Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/Insurance.xlsx
 73         PROC PRINT
 74         DATA = CoImpt.Insurance
 75         LABEL;
 76         RUN;
 
 NOTE: Access by observation number not available. Observation numbers will be counted by PROC PRINT.
 NOTE: The import data set has 1 observations and 64 variables.
 NOTE: The import data set has 1 observations and 64 variables.
 NOTE: There were 1 observations read from the data set COIMPT.Insurance.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.06 seconds
       user cpu time       0.05 seconds
       system cpu time     0.01 seconds
       memory              4240.71k
       OS Memory           29028.00k
       Timestamp           09/26/2023 08:29:08 PM
       Step Count                        92  Switch Count  0
       Page Faults                       0
       Page Reclaims                     886
       Page Swaps                        0
       Voluntary Context Switches        9
       Involuntary Context Switches      2
       Block Input Operations            0
       Block Output Operations           24
       
 
 77         
 78         
 78       !  PROC CONTENTS;
 ERROR: Couldn't find range or sheet in spreadsheet
 ERROR: File COIMPT.EDUCATION.DATA does not exist.
 79         RUN;
 
 NOTE: Statements not processed because of errors noted above.
 NOTE: PROCEDURE CONTENTS used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              2875.00k
       OS Memory           29028.00k
       Timestamp           09/26/2023 08:29:08 PM
       Step Count                        93  Switch Count  0
       Page Faults                       0
       Page Reclaims                     662
       Page Swaps                        0
       Voluntary Context Switches        2
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           8
       
 NOTE: The SAS System stopped processing this step because of errors.
 80         
 81         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 91

Re: Proc Content Errors

rudfaden — Wed, 27 Sep 2023 13:46:20 GMT

The CONTENTS procedure shows the contents of a SAS data set.

You have an Excel sheet.

Ergo you get an error

topic Proc Content Errors in SAS Procedures

Proc Content Errors

Re: Proc Content Errors