topic Re: What does this LOG mean and how can I make this code work? in SAS Programming

What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 21:21:42 GMT

Hello everyone,

Because I had been stuck in this code for an afternoon and cannot pass it on,

and there was not an error nor any output to this code.

I have to post it to ask for help~~~

Thanks for any guidance!

options MPRINT;

%MACRO pam(lib=,dsn=,obs=);
%let dirdata=/folders/myfolders;
%let dirOUT=/folders/myfolders;
%let lib=WORK;
%let dsn=tb2000;
%let obs=5;
libname &lib "&dirdata";
run;
data &dsn;
infile "&dirdata&lib..&dsn";
proc print data=&dsn &obs; 
title "Listing of first 5 records from &lib, &dsn,";
title2 "on &sysday, &sysdate..";
run;
%mend pam(lib=, dsn=,obs=);

The LOG showed:

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         options MPRINT;
 74         
 75         %MACRO pam(lib=,dsn=,obs=);
 76         %let dirdata=/folders/myfolders;
 77         %let dirOUT=/folders/myfolders;
 78         %let lib=WORK;
 79         %let dsn=tb2000;
 80         %let obs=5;
 81         libname &lib "&dirdata";
 82         run;
 83         data &dsn;
 84         infile "&dirdata&lib..&dsn";
 85         proc print data=&dsn &obs;
 86         title "Listing of first 5 records from &lib, &dsn,";
 87         title2 "on &sysday, &sysdate..";
 88         run;
 89         %mend pam(lib=, dsn=,obs=);
 WARNING: Extraneous text on %MEND statement ignored for macro definition PAM.
 90         
 91         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 104

What did I miss in the code..:(

Thanks!!!

Re: What does this LOG mean and how can I make this code work?

ChrisNZ — Sun, 11 Mar 2018 21:34:06 GMT

Extraneous text on %MEND statement ignored for macro definition PAM.

Isn't that text clear?

%mend; suffices. No extra parameters.

Re: What does this LOG mean and how can I make this code work?

art297 — Sun, 11 Mar 2018 21:39:56 GMT

Since I saw your other post earlier, I think that the following is what you're trying to do:

libname testdata '/folders/myfolders';

/*
for test purposes only .. create tb200 using sashelp.class
data testdata.tb2000;
  set sashelp.class;
run;
*/

%MACRO pam(lib=work,dsn=_LAST_,obs=5);
  proc print data=&lib..&dsn. (obs=&obs); 
    title "Listing of first &obs. records from &lib..&dsn.";
    title2 "on &sysday, &sysdate.";
  run;
%mend pam;

%pam(lib=testdata, dsn=tb2000,obs=8)

Art, CEO, AnalystFinder.com

Re: What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 21:42:57 GMT

hmm.

even if I get no errors for this code:

options MPRINT;

%MACRO pam;
%let dirdata=/folders/myfolders;
%let dirOUT=/folders/myfolders;

libname &lib "&dirdata";
data &dsn;
infile "&dirdata&lib..&dsn";
run;

proc print data=&dsn; 
title "Listing of first 5 records from &lib, &dsn,";
title2 "on &sysday, &sysdate..";
run;
%mend;

The LOG showed:

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         options MPRINT;
 74         
 75         %MACRO pam;
 76         %let dirdata=/folders/myfolders;
 77         %let dirOUT=/folders/myfolders;
 78         
 79         libname &lib "&dirdata";
 80         data &dsn;
 81         infile "&dirdata&lib..&dsn";
 82         run;
 83         
 84         proc print data=&dsn;
 85         title "Listing of first 5 records from &lib, &dsn,";
 86         title2 "on &sysday, &sysdate..";
 87         run;
 88         %mend;
 89         
 90         
 91         
 92         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 105

But I still have not got any output.

I will run your code to give a try...

I think I should get an output with those two titles...:(

Re: What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 21:46:11 GMT

This is the LOG for your code.

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         libname testdata '/folders/myfolders';
 NOTE: Libref TESTDATA refers to the same physical library as WEEK_6.
 NOTE: Libref TESTDATA was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: /folders/myfolders
 74         
 75         /*
 76         for test purposes only .. create tb200 using sashelp.class
 77         data testdata.tb2000;
 78           set sashelp.class;
 79         run;
 80         */
 81         
 82         %MACRO pam(lib=work,dsn=_LAST_,obs=5);
 83           proc print data=&lib..&dsn. (obs=&obs);
 84             title "Listing of first &obs. records from &lib..&dsn.";
 85             title2 "on &sysday, &sysdate.";
 86           run;
 87         %mend pam;
 88         
 89         %pam(lib=testdata, dsn=tb2000,obs=8)
 MPRINT(PAM):   proc print data=testdata.tb2000 (obs=8);
 ERROR: File TESTDATA.TB2000.DATA does not exist.
 MPRINT(PAM):   title "Listing of first 8 records from testdata.tb2000";
 MPRINT(PAM):   title2 "on Sunday, 11MAR18";
 MPRINT(PAM):   run;
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 90         
 91         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 104

Re: What does this LOG mean and how can I make this code work?

art297 — Sun, 11 Mar 2018 21:50:13 GMT

The file '/folders/myfolders/tb2000.sas7bdat' doesn't exist, thus you can't print it.

Art, CEO, AnalystFinder.com

Re: What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 22:10:13 GMT

I have uploaded it to the library "Week_6"

And the LOG has not showed that it does not exist.

My code is as below:

options MPRINT;

%MACRO pam;

%let dirdata=/folders/myfolders;
%let dirOUT=/folders/myfolders;

libname Week_6 "&dirdata";
data pam;
infile "&dirdata/Programs/Week_6/tb2000.sas7bdat";
proc print data=pam;
run;

%macro pam;
title "Listing of first 5 records from library &lib, member &dsn,";
title2 "on &sysday, &sysdate..";
proc print data=&lib..&dsn(obs=5);
run;
title;
%mend pam;

The LOG:

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 2          TITLE;
 3          FOOTNOTE;
 4          OPTIONS LOCALE=en_US DFLANG=LOCALE;
 5          DATA _NULL_;
 6          RUN;
 7          OPTIONS VALIDVARNAME=V7;
 8          OPTIONS VALIDMEMNAME=COMPAT;
 9          FILENAME _HTMLOUT TEMP;
 10         FILENAME _RTFOUT TEMP ENCODING='UTF-8';
 11         FILENAME _PDFOUT TEMP;
 12         FILENAME _GSFNAME TEMP;
 13         FILENAME _DATAOUT TEMP;
 14         %LET SYSCC=0;
 15         %LET _CLIENTAPP='SAS Studio';
 16         %LET _CLIENTAPPABREV=Studio;
 17         %LET _CLIENTAPPVERSION=3.7;
 18         %LET _CLIENTVERSION=3.7;
 19         %LET _CLIENTMODE=basic;
 20         %LET _SASSERVERNAME=%BQUOTE(localhost);
 21         %LET _SASHOSTNAME=%BQUOTE(localhost);
 22         %LET _SASPROGRAMFILEHOST=%BQUOTE(localhost);
 23         %LET _CLIENTUSERID=%BQUOTE(sasdemo);
 24         %LET _CLIENTUSERNAME=%BQUOTE(sasdemo);
 25         %LET CLIENTMACHINE=%BQUOTE(10.0.2.2);
 26         %LET _CLIENTMACHINE=%BQUOTE(10.0.2.2);
 27         %let SASWORKLOCATION="%sysfunc(getoption(work))/";
 28         FILENAME _CWD '.';
 29         DATA _NULL_;
 30         CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));
 31         RUN;
 32         FILENAME _CWD;
 33         
 34         %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR(/folders/myfolders/Programs/Week_6/ChenJenli_jc3992_Assignment5.sas));
 35         %LET _BASEURL = %BQUOTE(http://localhost:10080/SASStudio/);
 36         %LET _EXECENV=SASStudio;
 37         DATA _NULL_;
 38         CALL SYMPUT("GRAPHINIT","");
 39         CALL SYMPUT("GRAPHTERM","");
 40         RC=TSLVL('GEOCODE','N');
 41         _ERROR_=0;
 42         IF (RC^=' ') THEN DO;
 43         CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");
 44         CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");
 45         END;
 46         RUN;
 47         DATA _NULL_;
 48         RC=SYSPROD("PRODNUM002");
 49         IF (RC^=1) THEN DO;
 50         CALL SYMPUT("GRAPHINIT","");
 51         CALL SYMPUT("GRAPHTERM","");
 52         END;
 53         RUN;
 54         %LET _DATAOUT_MIME_TYPE=;
 55         %LET _DATAOUT_NAME=;
 56         %LET _DATAOUT_TABLE=;
 57         %LET _DATAOUT_URL=;
 58         %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;
 59         %LET _SASWS_ = %BQUOTE(/folders/myfolders);
 60         %LET _SASWSTEMP_=%BQUOTE(/folders/myfolders/.sasstudio/.images/5758c3cf-6519-489b-8bcc-fb17f767c995);
 61         ODS LISTING CLOSE;
 62         ODS AUTONAVIGATE OFF;
 63         ODS GRAPHICS ON;
 64         ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8  FILE=_HTMLOUT (TITLE='Results:
 64       ! ChenJenli_jc3992_Assignment5.sas') STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'
 64       ! CSS_PREFIX='.ods_5758c3cf-6519-489b-8bcc-fb17f767c995' BODY_ID='div_5758c3cf-6519-489b-8bcc-fb17f767c995' );
 65         ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT sasdate;
 66         ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT;
 67         &GRAPHINIT;
 68         OPTIONS FIRSTOBS=1;
 69         OPTIONS OBS=MAX;
 70         OPTIONS DTRESET DATE NUMBER NOTES;
 71         OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;
 72         
 73         
 74         options MPRINT;
 75         
 76         %MACRO pam;
 77         
 78         %let dirdata=/folders/myfolders;
 79         %let dirOUT=/folders/myfolders;
 80         
 81         libname Week_6 "&dirdata";
 82         data pam;
 83         infile "&dirdata/Programs/Week_6/tb2000.sas7bdat";
 84         proc print data=pam;
 85         run;
 86         
 87         %macro pam;
 88         title "Listing of first 5 records from library &lib, member &dsn,";
 89         title2 "on &sysday, &sysdate..";
 90         proc print data=&lib..&dsn(obs=5);
 91         run;
 92         title;
 93         %mend pam;
 94         
 95         
 96         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 97         ODS HTML CLOSE;
 98         &GRAPHTERM; ;*';*";*/;RUN;QUIT;
 99         QUIT;RUN;
 100        ODS HTML5 (ID=WEB) CLOSE;
 101        
 102        ODS RTF (ID=WEB) CLOSE;
 103        ODS PDF (ID=WEB) CLOSE;
 104        FILENAME _GSFNAME;
 105        DATA _NULL_;
 106        RUN;
 107        OPTIONS VALIDMEMNAME=COMPAT;
 108        OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
 109

Re: What does this LOG mean and how can I make this code work?

art297 — Sun, 11 Mar 2018 22:20:25 GMT

Looks like you created the dataset as a file called pam in your work directory. If so, then all you need is:

%MACRO pam(lib=work,dsn=_LAST_,obs=5);
  proc print data=&lib..&dsn. (obs=&obs); 
    title "Listing of first &obs. records from &lib..&dsn.";
    title2 "on &sysday, &sysdate.";
  run;
%mend pam;

%pam(dsn=pam,obs=8)

Art, CEO, AnalystFinder.com

Re: What does this LOG mean and how can I make this code work?

ChrisNZ — Sun, 11 Mar 2018 22:21:28 GMT

why do you have

%macro pam;

twice in your program?

Re: What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 22:25:15 GMT

well...

I thought I have to define it firstly.

My understanding of %macro is I had to do it firstly without %macro,

and then project the result I had earlier to the %macro.

So others can make changes with my code on the %macro.

Is my understanding correct?

Re: What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 22:29:19 GMT

Let me try it....

Re: What does this LOG mean and how can I make this code work?

jc3992 — Sun, 11 Mar 2018 22:41:14 GMT

options MPRINT;



%let dirdata=/folders/myfolders;
%let dirOUT=/folders/myfolders;

libname Week_6 "&dirdata" ;
data pam;
infile "&dirdata/Programs/Week_6/tb2000.sas7bdat" ;
proc print data=pam;
run;

%macro pam(lib=WORK, dsn=_LAST_, obs=5);
proc print data=&lib..&dsn.(obs=&obs);
title "Listing of first 5 records from library &lib, member &dsn," ;
title2 "on &sysday, &sysdate.." ;
run;
title;
%mend pam;

%pam(dsn=pam,obs=5);

LOG :

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 2          TITLE;
 3          FOOTNOTE;
 4          OPTIONS LOCALE=en_US DFLANG=LOCALE;
 NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
 5          DATA _NULL_;
 6          RUN;
 7          OPTIONS VALIDVARNAME=V7;
 8          OPTIONS VALIDMEMNAME=COMPAT;
 9          FILENAME _HTMLOUT TEMP;
 10         FILENAME _RTFOUT TEMP ENCODING='UTF-8';
 11         FILENAME _PDFOUT TEMP;
 12         FILENAME _GSFNAME TEMP;
 13         FILENAME _DATAOUT TEMP;
 14         %LET SYSCC=0;
 15         %LET _CLIENTAPP='SAS Studio';
 16         %LET _CLIENTAPPABREV=Studio;
 17         %LET _CLIENTAPPVERSION=3.7;
 18         %LET _CLIENTVERSION=3.7;
 19         %LET _CLIENTMODE=basic;
 20         %LET _SASSERVERNAME=%BQUOTE(localhost);
 21         %LET _SASHOSTNAME=%BQUOTE(localhost);
 22         %LET _SASPROGRAMFILEHOST=%BQUOTE(localhost);
 23         %LET _CLIENTUSERID=%BQUOTE(sasdemo);
 24         %LET _CLIENTUSERNAME=%BQUOTE(sasdemo);
 25         %LET CLIENTMACHINE=%BQUOTE(10.0.2.2);
 26         %LET _CLIENTMACHINE=%BQUOTE(10.0.2.2);
 27         %let SASWORKLOCATION="%sysfunc(getoption(work))/";
 28         FILENAME _CWD '.';
 29         DATA _NULL_;
 30         CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));
 31         RUN;
 32         FILENAME _CWD;
 33         
 34         %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR(/folders/myfolders/Programs/Week_6/ChenJenli_jc3992_Assignment5.sas));
 35         %LET _BASEURL = %BQUOTE(http://localhost:10080/SASStudio/);
 36         %LET _EXECENV=SASStudio;
 NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
 
            ________________________________________________________________________________________________________________________
            49
 
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 37         DATA _NULL_;
 38         CALL
 38       ! SYMPUT("GRAPHINIT"
                             _
                             49
 38       ! ,"");
 39         CALL
 39       ! SYMPUT("GRAPHTERM"
                             _
                             49
 39       ! ,"");
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 40         RC=TSLVL('GEOCODE','N');
 41         _ERROR_=0;
 42         IF (RC^=' ') THEN DO;
 43         CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;");
                                  ___                                    ________________
                                  49                                     49
 44         CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;");
                                  ___                      ___________________________________
                                  49                       49
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 45         END;
 46         RUN;
 47         DATA _NULL_;
 48         RC=SYSPROD("PRODNUM002"
                                  _
                                  49
 48       ! );
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 49         IF (RC^=1) THEN DO;
 50         CALL
 50       ! SYMPUT("GRAPHINIT"
                             _
                             49
 50       ! ,"");
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 51         CALL SYMPUT("GRAPHTERM","");
 52         END;
 53         RUN;
 54         %LET _DATAOUT_MIME_TYPE=;
 55         %LET _DATAOUT_NAME=;
 56         %LET _DATAOUT_TABLE=;
 57         %LET _DATAOUT_URL=;
 58         %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE;
 59         %LET _SASWS_ = %BQUOTE(/folders/myfolders);
 60         %LET _SASWSTEMP_=%BQUOTE(/folders/myfolders/.sasstudio/.images/a98faac7-1ad7-4d9c-984d-53c7da57687d);
 NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
 61         ODS LISTING CLOSE;
 62         ODS AUTONAVIGATE OFF;
 63         ODS GRAPHICS ON;
 64         ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8  FILE=_HTMLOUT (TITLE='Results:
 64       ! ChenJenli_jc3992_Assignment5.sas') STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'
 64       ! CSS_PREFIX='.ods_a98faac7-1ad7-4d9c-984d-53c7da57687d' BODY_ID='div_a98faac7-1ad7-4d9c-984d-53c7da57687d' );
 NOTE: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
 65         ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT sasdate;
 66         ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT;
 67         &GRAPHINIT;
 68         OPTIONS FIRSTOBS=1;
 69         OPTIONS OBS=MAX;
 70         OPTIONS DTRESET DATE NUMBER NOTES;
 71         OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;
 72         
 73         options MPRINT;
 74         
 75         
 76         
 77         %let dirdata=/folders/myfolders;
 78         %let dirOUT=/folders/myfolders;
 79         
 80         libname Week_6 "&dirdata" ;
 81         data pam;
 82         infile "&dirdata/Programs/Week_6/tb2000.sas7bdat" ;
 83         proc print data=pam;
 82         infile "&dirdata/Programs/Week_6/tb2000.sas7bdat"
                                                            _
                                                            49
 82       !  ;
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 84         run;
 85         
 86         %macro pam(lib=WORK, dsn=_LAST_, obs=5);
 87         proc print data=&lib..&dsn.(obs=&obs);
 88         title "Listing of first 5 records from library &lib, member &dsn,"
                                                                             ___________
                                                                             49
 88       !  ;
 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release.  Inserting white space 
              between a quoted string and the succeeding identifier is recommended.
 
 89         title2 "on &sysday, &sysdate.." ;
 90         run;
 91         title;
 92         %mend pam;
 93         
 94         %pam(dsn=pam,obs=5);
 95         
 96         
 97         
 98         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 99         ODS HTML CLOSE;
 100        &GRAPHTERM; ;*';*";*/;RUN;QUIT;
 101        QUIT;RUN;
 102        ODS HTML5 (ID=WEB) CLOSE;
 103        
 104        ODS RTF (ID=WEB) CLOSE;
 105        ODS PDF (ID=WEB) CLOSE;
 106        FILENAME _GSFNAME;
 107        DATA _NULL_;
 108        RUN;
 109        OPTIONS VALIDMEMNAME=COMPAT;
 110        OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
 111

Re: What does this LOG mean and how can I make this code work?

art297 — Sun, 11 Mar 2018 23:04:22 GMT

Two problems.

Fiirst,

81         data pam;
 82         infile "&dirdata/Programs/Week_6/tb2000.sas7bdat" ;

is not how you would create the file pam.

I would use:

%let dirdata=/folders/myfolders/Programs/Week_6;

data pam;
  set "&dirdata./tb2000";
run;

Then I would use:

%MACRO pam(lib=work,dsn=_LAST_,obs=5);
  proc print data=&lib..&dsn. (obs=&obs); 
    title "Listing of first &obs. records from &lib..&dsn.";
    title2 "on &sysday, &sysdate.";
  run;
%mend pam;

%pam(dsn=pam,obs=8)

Art, CEO, AnalystFinder.com

Re: What does this LOG mean and how can I make this code work?

ChrisNZ — Sun, 11 Mar 2018 23:05:10 GMT

%macro pam;

is the start of the definition of the macro

%mend;

is the end of the definition

%pam;

calls the macro

Re: What does this LOG mean and how can I make this code work?

jc3992 — Mon, 12 Mar 2018 01:44:12 GMT

Thanks!! After getting a coffee and re-think it over again.

Here is my code, but Ive got errors which I do not know where to start working with...:(

Need help!

%let dirdata=/folders/myfolders;
%let dirOUT=/folders/myfolders;
%let lib=WORK;
%let dsn=_LAST_;
%let obs=5;

%macro pam(lib=,dsn=,obs=);
proc print data=&dirdata&lib..&dsn.(obs=5);
title "Listing of first 5 records from library &lib, member &dsn," ;
title2 "on &sysday, &sysdate.." ;
run;
%mend pam;

%pam;

The LOG is as below:

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         
 74         %let dirdata=/folders/myfolders;
 75         %let dirOUT=/folders/myfolders;
 76         %let lib=WORK;
 77         %let dsn=_LAST_;
 78         %let obs=5;
 79         
 80         %macro pam(lib=,dsn=,obs=);
 81         proc print data=&dirdata&lib..&dsn.(obs=5);
 82         title "Listing of first 5 records from library &lib, member &dsn," ;
 83         title2 "on &sysday, &sysdate.." ;
 84         run;
 85         %mend pam;
 86         
 87         %pam;
 MPRINT(PAM):   proc print data=/folders/myfolders.(obs=5);
 MPRINT(PAM):   title "Listing of first 5 records from library , member ," ;
 NOTE: Line generated by the macro variable "LIB".
 87         /folders/myfolders
            _
            22
            76
 ERROR 22-322: Expecting a name.  
 
 ERROR 76-322: Syntax error, statement will be ignored.
 
 MPRINT(PAM):   title2 "on Monday, 12MAR18." ;
 MPRINT(PAM):   run;
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.00 seconds
       cpu time            0.01 seconds
       
 88         
 89         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 102

I did not get why the LOG showed that on Line 88 I need a name for that?

That was macro calling. But I felt if SAS had not found the file or did I do wrong with the path so it did not print out anything?

Re: What does this LOG mean and how can I make this code work?

jc3992 — Mon, 12 Mar 2018 01:45:26 GMT

Thanks!! But I found I need not create another data name.

I should have used the macro pam as the data name.

So I tried again.

Re: What does this LOG mean and how can I make this code work?

ChrisNZ — Mon, 12 Mar 2018 01:52:19 GMT

parameter lib= should be a library

libname DATA '/folders/myfolders';

%macro pam(lib=,dsn=,obs=);
  proc print data=&lib..&dsn.(obs=&obs);
  title "Listing of first &obs records from library &lib, member &dsn," ;
  title2 "on &sysday, &sysdate.." ; 
  run;
%mend pam;

%pam(lib=WORK, dsn=_LAST_, obs=5);
or
%pam(lib=DATA, dsn=_LAST_, obs=5);

Re: What does this LOG mean and how can I make this code work?

jc3992 — Mon, 12 Mar 2018 02:34:06 GMT

After reading @Tom comment,

I changed to this :

options MPRINT;


%let dirdata=/folders/myfolders;
%let dirOUT=/folders/myfolders;
%let lib=Week_6;
libname Week_6 "&dirdata";
data tb2000;
infile "&dirdata/Programs/Week_6/tb2000.sas7bdat";
proc print data=tb2000;
run;

%macro pam(lib=,dsn=,obs=);

title "Listing of first 5 records from library &lib, member &dsn," ;
title2 "on &sysday, &sysdate.." ;
proc print data=&lib..&dsn. (obs=8);
run;
title;
%mend pam;

My mindset was,

I should run the statement and then define the macro function and then call the macro function.(But I wanted to try to print out firstly and then put macro in it and then call the macro, so I had not run to that step yet because there were errors...)

The LOG is as below:

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         
 74         options MPRINT;
 75         
 76         
 77         
 78         %let dirdata=/folders/myfolders;
 79         %let dirOUT=/folders/myfolders;
 80         %let lib=Week_6;
 81         libname Week_6 "&dirdata";
 NOTE: Libref WEEK_6 refers to the same physical library as PERM.
 NOTE: Libref WEEK_6 was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: /folders/myfolders
 82         data tb2000;
 83         infile "&dirdata/Programs/Week_6/tb2000.sas7bdat";
 
 NOTE: The infile "/folders/myfolders/Programs/Week_6/tb2000.sas7bdat" is:
       Filename=/folders/myfolders/Programs/Week_6/tb2000.sas7bdat,
       Owner Name=sasdemo,Group Name=sas,
       Access Permission=-rw-rw-r--,
       Last Modified=10Mar2018:22:36:26,
       File Size (bytes)=50176
 
 NOTE: 0 records were read from the infile "/folders/myfolders/Programs/Week_6/tb2000.sas7bdat".
 NOTE: The data set WORK.TB2000 has 1 observations and 0 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 84         proc print data=tb2000;
 
 85         run;
 
 NOTE: No variables in data set WORK.TB2000.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 86         
 87         
 88         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 101

And there was a message saying that "Work.tb2000" has no column in it popping out.

My hand is tired I need to rest a bit....

Used a 13" Mac book for this...:(

Re: What does this LOG mean and how can I make this code work?

ChrisNZ — Mon, 12 Mar 2018 02:42:10 GMT

You can read a sas table (sas7bdat file) with infile.

Run my code.

Re: What does this LOG mean and how can I make this code work?

jc3992 — Mon, 12 Mar 2018 03:12:41 GMT

This is the LOG of your code:

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73          libname DATA '/folders/myfolders';
 NOTE: Libref DATA refers to the same physical library as WEEK_6.
 NOTE: Libref DATA was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: /folders/myfolders
 74         
 75         %macro pam(lib=,dsn=,obs=);
 76           proc print data=&lib..&dsn.(obs=&obs);
 77           title "Listing of first &obs records from library &lib, member &dsn," ;
 78           title2 "on &sysday, &sysdate.." ;
 79           run;
 80         %mend pam;
 81         
 82         
 83         
 84         %pam(lib=DATA, dsn=_LAST_, obs=8);
 MPRINT(PAM):   proc print data=DATA._LAST_(obs=8);
 MPRINT(PAM):   title "Listing of first 8 records from library DATA, member _LAST_," ;
 MPRINT(PAM):   title2 "on Monday, 12MAR18." ;
 MPRINT(PAM):   run;
 NOTE: No variables in data set WORK.TB2000.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 
 85         
 86         
 87         
 88         
 89         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 102

Why is there no variable in dataset WORK.2000?

I tried to change the "libname" to "WORK"

but the LOG showed "the WORK cannot be reassigned".

Was this what the question want?