topic Re: proc contents in SAS Programming

proc contents

fpedrozam — Thu, 24 Dec 2020 18:16:57 GMT

Hi! Could you help me with the problem below. Appreciate.

proc contents data='D:\Projetos\SAS_Oficial_Online\EPG1V2_EG\data\pg1v2_eg.sas';

run;

1 The SAS System segunda-feira, 21 de dezembro de 2020 21h05min00s

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HTMLBlue
17 STYLESHEET=(URL="file:///D:/aplicativos/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 proc contents data='D:\Projetos\SAS_Oficial_Online\EPG1V2_EG\data\pg1v2_eg.sas';
ERROR: Extension for physical file name "D:\Projetos\SAS_Oficial_Online\EPG1V2_EG\data\pg1v2_eg.sas" does not correspond to a valid
member type.
27 run;

NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: The SAS System stopped processing this step because of errors.
28
29 GOPTIONS NOACCESSIBLE;
30 %LET _CLIENTTASKLABEL=;
31 %LET _CLIENTPROCESSFLOWNAME=;
32 %LET _CLIENTPROJECTPATH=;
33 %LET _CLIENTPROJECTPATHHOST=;
34 %LET _CLIENTPROJECTNAME=;
35 %LET _SASPROGRAMFILE=;
36 %LET _SASPROGRAMFILEHOST=;
37
38 ;*';*";*/;quit;run;
39 ODS _ALL_ CLOSE;
40
41
42 QUIT; RUN;
43

Re: proc contents

PaigeMiller — Thu, 24 Dec 2020 18:52:54 GMT

PROC CONTENTS works on SAS data sets.

26 proc contents data='D:\Projetos\SAS_Oficial_Online\EPG1V2_EG\data\pg1v2_eg.sas';
ERROR: Extension for physical file name "D:\Projetos\SAS_Oficial_Online\EPG1V2_EG\data\pg1v2_eg.sas" does not correspond to a valid
member type.

You have data= and then a SAS program, not a SAS data set.

What are you trying to do?

Re: proc contents

fpedrozam — Thu, 24 Dec 2020 18:55:12 GMT

I want to import and do some analysis

Re: proc contents

PaigeMiller — Thu, 24 Dec 2020 19:04:57 GMT

@fpedrozam wrote:
I want to import and do some analysis

PROC CONTENTS does neither. Why are you using PROC CONTENTS? Import from where?

Re: proc contents

fpedrozam — Thu, 24 Dec 2020 19:39:53 GMT

import the file with extension .sas

Re: proc contents

PaigeMiller — Thu, 24 Dec 2020 20:42:26 GMT

A file with extension .sas is a SAS program, it has code that you (or someone) has written. It cannot be Imported because it does not have data. You cannot do analysis on it, because it is not data.

In just about all versions of SAS that I know of, you use File->Open to open this file.

Re: proc contents

japelin — Fri, 25 Dec 2020 09:58:49 GMT

I think this will fit you want to do.

%include 'D:\Projetos\SAS_Oficial_Online\EPG1V2_EG\data\pg1v2_eg.sas';

Re: proc contents

fpedrozam — Fri, 25 Dec 2020 15:10:22 GMT

wonderful. It worked. thanks