Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About jc3992
08-15-2019
jc3992
Pyrite | Level 9
Member since
01-23-2018
- 139 Posts
- 78 Likes Given
- 1 Solutions
- 1 Likes Received
-
Latest posts by jc3992
Subject Views Posted 2540 08-14-2019 07:10 AM 2629 08-12-2019 01:30 AM 2289 08-11-2019 05:35 PM 1640 08-04-2019 12:09 AM 1668 08-03-2019 10:39 PM 1322 07-22-2019 12:56 AM 1175 03-22-2019 09:58 AM 1214 03-21-2019 09:26 PM 1395 12-11-2018 09:49 PM 1420 12-11-2018 07:52 PM -
Activity Feed for jc3992
- Posted Re: Importing tab-delimited file failed on SAS Studio. 08-14-2019 07:10 AM
- Posted Importing tab-delimited file failed on SAS Studio. 08-12-2019 01:30 AM
- Posted Read in hyphen in SAS on SAS Studio. 08-11-2019 05:35 PM
- Got a Like for Re: Colon modifier seems not work. 08-04-2019 09:50 AM
- Posted Re: Colon modifier seems not work on SAS Studio. 08-04-2019 12:09 AM
- Posted Colon modifier seems not work on SAS Studio. 08-03-2019 10:39 PM
- Liked Re: Have trouble reading in fixed-space data for Reeza. 07-22-2019 10:56 PM
- Liked Re: Have trouble reading in fixed-space data for ballardw. 07-22-2019 10:56 PM
- Liked Re: Have trouble reading in fixed-space data for andreas_lds. 07-22-2019 10:37 PM
- Posted Have trouble reading in fixed-space data on SAS Programming. 07-22-2019 12:56 AM
- Posted Re: Formatted Input Help for "Time" variable on SAS Studio. 03-22-2019 09:58 AM
- Posted Formatted Input Help for "Time" variable on SAS Studio. 03-21-2019 09:26 PM
- Posted Re: SAS multi array question on SAS Programming. 12-11-2018 09:49 PM
- Posted SAS multi array question on SAS Programming. 12-11-2018 07:52 PM
- Posted Re: SAS "Set" statement when combining two data sets on SAS Programming. 12-11-2018 07:14 PM
- Posted Re: SAS macro question "&sysday" on SAS Programming. 12-11-2018 07:02 PM
- Posted Re: SAS macro question "&sysday" on SAS Programming. 12-11-2018 06:52 PM
- Posted Re: SAS "Set" statement when combining two data sets on SAS Programming. 12-11-2018 05:32 PM
- Posted SAS macro question "&sysday" on SAS Programming. 12-11-2018 05:30 PM
- Posted Re: SAS "Set" statement when combining two data sets on SAS Programming. 12-11-2018 05:19 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 2 1 -
My Liked Posts
Subject Likes Posted 1 08-04-2019 12:09 AM
03-12-2018
02:34 PM
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/4e483ce2-cce2-4814-ad43-364ce5bf63bb);
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_4e483ce2-cce2-4814-ad43-364ce5bf63bb' BODY_ID='div_4e483ce2-cce2-4814-ad43-364ce5bf63bb' );
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 data churchdata;
74 set "folders/myfolders/Programs/Week_6/churchdata.sas7dbat";
75 input Employer $ Receiver $ Date mmddyy10. Amount COMMA9. City $ Sate $ Zip LastNamePart $ FirstNamePart $;
76 if upcase(LastNamePart) = "Church" and upcase(state) = "NY";
77 run;
78
79 proc print data=churchdata;
80 run;
81
82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
83 ODS HTML CLOSE;
84 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
85 QUIT;RUN;
86 ODS HTML5 (ID=WEB) CLOSE;
87
88 ODS RTF (ID=WEB) CLOSE;
89 ODS PDF (ID=WEB) CLOSE;
90 FILENAME _GSFNAME;
91 DATA _NULL_;
92 RUN;
93 OPTIONS VALIDMEMNAME=COMPAT;
94 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
95
User: sasdemo
DATA Step Statements
... View more
03-12-2018
02:34 PM
input Employer $ Receiver $ Date mmddyy10. Amount COMMA9. City $ Sate $ Zip LastNamePart $ FirstNamePart $; Like this?
... View more
03-12-2018
02:18 PM
I don't really understand... Is that because of the data type? I came back to check the data set, There are surname which is "CHURCH" so was it because of the Capital letter? Also, I have this code: %let lname=Churchhill;
%let state=VA;
options MPRINT;
%let dirdata=/folders/myfolders;
libname perm "&dirdata";
run;
%macro church2(lname=, state=);
data churchdata;
set churchdata"&dirdata";
if &lname.=Churchhill and &state.=VA then do;
call symput('Churchhill',&lname.);
call symput('VA',&state.);
end;
title "The donors with surname &lname and from the state &state";
proc print data=churchdata;
run;
title;
%mend church2;
%church2(lname=Churchhill,state=VA); Ask us to modify the earlier code (LastNamePart=CHURCH and State is NY to : (1) Modify your code in part (a) so that the last name of the donor and the state of the donor are macro variables, named &lname and &state, that are created in the first two lines of your program with %let commands. Use the name Churchill (entered exactly like this in your macro variable) and make Virginia (VA) the state. Then run the macro that you created in part (b) to get a listing again, but this time with the data set you just created, with the same N of records and the same variables. Include the macro variables in the title statements so that they resolve to the correct values. The LOG showed no errors but still no output...sigh 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/878f0262-510f-4d7f-8d0b-bf7a5d005929);
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_878f0262-510f-4d7f-8d0b-bf7a5d005929' BODY_ID='div_878f0262-510f-4d7f-8d0b-bf7a5d005929' );
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 %let lname=Churchhill;
74 %let state=VA;
75
76 options MPRINT;
77
78 %let dirdata=/folders/myfolders;
79 libname perm "&dirdata";
80 run;
81 %macro church2(lname=, state=);
82 data churchdata;
83 set churchdata"&dirdata";
84 if &lname.=Churchhill and &state.=VA then do;
85 call symput('Churchhill',&lname.);
86 call symput('VA',&state.);
87 end;
88 title "The donors with surname &lname and from the state &state";
89 proc print data=churchdata;
90 run;
91 title;
92 %mend church2;
93
94 %church2(lname=Churchhill,state=VA);
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
User: sasdemo
DATA Step Statements
... View more
03-12-2018
01:44 PM
Hello everyone, My code is as below: data churchdata;
set "folders/myfolders/Programs/Week_6/churchdata.sas7dbat";
if upcase(LastNamePart) = "Church" and upcase(state) = "NY";
run;
proc print data=churchdata noobs;
run; I got no errors nor any output. Any help would be appreciated. Thank~ 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;
______________________________________________________________________________________________________________________
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/b59f1c47-d5c4-49d1-b05b-75c5e247d9ab);
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_b59f1c47-d5c4-49d1-b05b-75c5e247d9ab' BODY_ID='div_b59f1c47-d5c4-49d1-b05b-75c5e247d9ab' );
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;
64 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results:
________________________________________________
49
64 ! ChenJenli_jc3992_Assignment5.sas') STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE'
64 ! CSS_PREFIX='.ods_b59f1c47-d5c4-49d1-b05b-75c5e247d9ab' BODY_ID='div_b59f1c47-d5c4-49d1-b05b-75c5e247d9ab' );
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.
70 OPTIONS DTRESET DATE NUMBER NOTES;
71 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK;
72
73 data churchdata;
74 set "folders/myfolders/Programs/Week_6/churchdata.sas7dbat"
_____________________________
49
74 ! ;
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.
75 if upcase(LastNamePart) = "Church" and upcase(state) = "NY";
76 run;
77
78 proc print data=churchdata noobs;
79 run;
80
81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
82 ODS HTML CLOSE;
83 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
84 QUIT;RUN;
85 ODS HTML5 (ID=WEB) CLOSE;
86
87 ODS RTF (ID=WEB) CLOSE;
88 ODS PDF (ID=WEB) CLOSE;
89 FILENAME _GSFNAME;
90 DATA _NULL_;
91 RUN;
92 OPTIONS VALIDMEMNAME=COMPAT;
93 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
94
User: sasdemo
Macro Variables
... View more
03-12-2018
12:55 PM
Hello, I have another related question as below: Using your macro, print out the first 5 records from the SAS data set you created in (a), but only for the variables date, receiver, and amount. Include appropriate titles in your listing. My code is : options MPRINT;
%let dirdata=/folders/myfolders;
%let lib=perm "&dirdata";
%let data=churchdata;
%macro p5m3a (lib=,data=, nobs=);
proc print data=&dirdata.&lib..&dsn. (keep=date receiver amount)(obs=5);
run;
%mend p5m3a;
%p5m3a(lib=perm, data=churchdata,nobs=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;
______________________________________________________________________________________________________________________
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/1bf2f9c0-63d4-4e15-b723-99d29b4d898e);
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_1bf2f9c0-63d4-4e15-b723-99d29b4d898e' BODY_ID='div_1bf2f9c0-63d4-4e15-b723-99d29b4d898e' );
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
74 options MPRINT;
75
76 %let dirdata=/folders/myfolders;
77 %let lib=perm "&dirdata";
78 %let data=churchdata;
79 %macro p5m3a (lib=,data=, nobs=);
80 proc print data=&dirdata.&lib..&dsn. (keep=date receiver amount)(obs=5);
81 run;
82 %mend p5m3a;
83
84 %p5m3a(lib=perm, data=churchdata,nobs=5);
85
86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
87 ODS HTML CLOSE;
88 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
89 QUIT;RUN;
90 ODS HTML5 (ID=WEB) CLOSE;
91
92 ODS RTF (ID=WEB) CLOSE;
93 ODS PDF (ID=WEB) CLOSE;
94 FILENAME _GSFNAME;
95 DATA _NULL_;
96 RUN;
97 OPTIONS VALIDMEMNAME=COMPAT;
98 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
99
User: sasdemo
Macro Statements Any help would be highly appreciated! Thanks~
... View more
03-12-2018
12:31 PM
well...but our course has to finish SAS and R in one semester. felt helpless... options MPRINT;
%let LastNamePart=Church;
%let State=NY;
%let dirdata=/folders/myfolders;
libname perm "&dirdata";
run;
%macro church(lib=, dsn=,LastNamePart=, State=);
proc sort data churchdata out=church1;
set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
if &LastNamePart.="Church"and &State.="NY" then do;
end;
proc print data=church1;
run;
%mend;
%church(lib=perm, dsn=church1,LastNamePart=Church,State=NY); I did not get errors with this but no result still... 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;
______________________________________________________________________________________________________________________
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/858d35bc-a033-414a-85c6-e0d80658f281);
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_858d35bc-a033-414a-85c6-e0d80658f281' BODY_ID='div_858d35bc-a033-414a-85c6-e0d80658f281' );
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 %let LastNamePart=Church;
75 %let State=NY;
76 %let dirdata=/folders/myfolders;
77 libname perm "&dirdata";
78 run;
79 %macro church(lib=, dsn=,LastNamePart=, State=);
80 data=churchdata out=church1;
81 set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat"
_____________________
49
81 ! ;
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.
82 if &LastNamePart.="Church"and &State.="NY" then do;
83 end;
84 proc print data=church1;
85 run;
86 %mend;
87
88 %church(lib=perm, dsn=church1,LastNamePart=Church,State=NY);
89
90
91 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
92 ODS HTML CLOSE;
93 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
94 QUIT;RUN;
95 ODS HTML5 (ID=WEB) CLOSE;
96
97 ODS RTF (ID=WEB) CLOSE;
98 ODS PDF (ID=WEB) CLOSE;
99 FILENAME _GSFNAME;
100 DATA _NULL_;
101 RUN;
102 OPTIONS VALIDMEMNAME=COMPAT;
103 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
104
User: sasdemo
... View more
03-12-2018
12:05 PM
Why can't this work? options MPRINT;
%let LastNamePart=Church;
%let State=NY;
%let dirdata=/folders/myfolders;
libname perm "&dirdata";
run;
%macro church(lib=, dsn=,LastNamePart=, State=);
data churchdata;
set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
proc sort data=churchdata out=church1;
by LastNamePart;
run;
proc print data=church1;
where State="NY";
run; I did not get error but no result either. LOG: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 options MPRINT;
74 %let LastNamePart=Church;
75 %let State=NY;
76 %let dirdata=/folders/myfolders;
77 libname perm "&dirdata";
NOTE: Libref PERM refers to the same physical library as WEEK_6.
NOTE: Libref PERM was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
78 run;
79 %macro church(lib=, dsn=,LastNamePart=, State=);
80 data churchdata;
81 set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
82 proc sort data=churchdata out=church1;
83 by LastNamePart;
84 run;
85 proc print data=church1;
86 where State="NY";
87 run;
88
89
90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
91 ODS HTML CLOSE;
92 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
93 QUIT;RUN;
94 ODS HTML5 (ID=WEB) CLOSE;
95
96 ODS RTF (ID=WEB) CLOSE;
97 ODS PDF (ID=WEB) CLOSE;
98 FILENAME _GSFNAME;
99 DATA _NULL_;
100 RUN;
101 OPTIONS VALIDMEMNAME=COMPAT;
102 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
103
User: sasdemo
Procedure Options
... View more
03-12-2018
11:48 AM
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73
74 %let dirdata=/folders/myfolders;
75
76 libname perm "&dirdata./Programs/Week_6";
NOTE: Libref PERM refers to the same physical library as _TEMP2.
NOTE: Libref PERM was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders/Programs/Week_6
77
78 data churchdata;
79 set perm.churchdata;
NOTE: Data file PERM.CHURCHDATA.DATA is in a format that is native to another host, or the file encoding does not match the session
encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
80 if upcase(lastnamepart) = "Church" and upcase(state) = "NY";
81 run;
NOTE: There were 500 observations read from the data set PERM.CHURCHDATA.
NOTE: The data set WORK.CHURCHDATA has 0 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
82
83 proc print data=churchdata noobs;
84 run;
NOTE: No observations in data set WORK.CHURCHDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
85 if upcase(lastnamepart) = "Church" and upcase(state) = "NY";
__
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
86 run;
87
88 proc print data=churchdata noobs;
89 run;
NOTE: No observations in data set WORK.CHURCHDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
90
91
92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
105
User: sasdemo I got this LOG with your code. Would you let me know how can I modify it? Thanks~~
... View more
03-12-2018
10:56 AM
Because for the following questions we have to do macro....:( Thanks~~ Mine is options MPRINT;
%let LastNamePart=Church;
%let State=NY;
%let dirdata=/folders/myfolders;
libname perm "&dirdata";
run;
%macro church(lib=, dsn=,LastNamePart=, State=);
data churchdata;
set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
proc sort data=churchdata out=church1;
by &LastNamePart. &State.;
where &LastNamePart.=Church and &State.=NY;
run;
proc print data=church1;
title;
run;
%mend;
%church(lib=perm, dsn=church1,LastNamePart=Church,State=NY); still had no idea why it did not work though but gotta move on to the next~~ (right hand hurts....) Thanks guys!! LOG: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 options MPRINT;
74 %let LastNamePart=Church;
75 %let State=NY;
76 %let dirdata=/folders/myfolders;
77 libname perm "&dirdata";
NOTE: Libref PERM refers to the same physical library as WEEK_6.
NOTE: Libref PERM was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
78 run;
79 %macro church(lib=, dsn=,LastNamePart=, State=);
80 data churchdata;
81 set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
82 proc sort data=churchdata out=church1;
83 by &LastNamePart. &State.;
84 where &LastNamePart.=Church and &State.=NY;
85 run;
86 proc print data=church1;
87 title;
88 run;
89 %mend;
90
91 %church(lib=perm, dsn=church1,LastNamePart=Church,State=NY);
MPRINT(CHURCH): data churchdata;
MPRINT(CHURCH): set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
NOTE: Data file _TEMP2.CHURCHDATA.DATA is in a format that is native to another host, or the file encoding does not match the
session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: There were 500 observations read from the data set /folders/myfolders/Programs/Week_6/churchdata.sas7bdat.
NOTE: The data set WORK.CHURCHDATA has 500 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
MPRINT(CHURCH): proc sort data=churchdata out=church1;
ERROR: Variable CHURCH not found.
MPRINT(CHURCH): by Church NY;
ERROR: Variable NY not found.
MPRINT(CHURCH): where Church=Church and NY=NY;
ERROR: Variable Church is not on file WORK.CHURCHDATA.
MPRINT(CHURCH): run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.CHURCH1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.CHURCH1 was not replaced because this step was stopped.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
MPRINT(CHURCH): proc print data=church1;
MPRINT(CHURCH): title;
MPRINT(CHURCH): run;
NOTE: No variables in data set WORK.CHURCH1.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
92
93 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
106
User: sasdemo
Procedure Statements
... View more
03-12-2018
10:38 AM
I changed to this. options MPRINT;
%let LastNamePart=Church;
%let State=NY;
%let dirdata=/folders/myfolders;
libname perm "&dirdata";
run;
%macro church(lib=, dsn=,LastNamePart=, State=);
data churchdata;
set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
proc sort data=churchdata out=church1;
by &LastNamePart.;
where &State.=NY;
run;
proc print data=church1;
var &LastNamePart. ;
run;
%mend;
%church(lib=perm, dsn=churchdata,LastNamePart=Church,State=NY); Yes I tried that but did not work. The above code also got errors: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 options MPRINT;
74 %let LastNamePart=Church;
75 %let State=NY;
76 %let dirdata=/folders/myfolders;
77 libname perm "&dirdata";
NOTE: Libref PERM refers to the same physical library as WEEK_6.
NOTE: Libref PERM was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
78 run;
79 %macro church(lib=, dsn=,LastNamePart=, State=);
80 data churchdata;
81 set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
82 proc sort data=churchdata out=church1;
83 by &LastNamePart.;
84 where &State.=NY;
85 run;
86 proc print data=church1;
87 var &LastNamePart. ;
88 run;
89 %mend;
90
91 %church(lib=perm, dsn=churchdata,LastNamePart=Church,State=NY);
MPRINT(CHURCH): data churchdata;
MPRINT(CHURCH): set "/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
NOTE: Data file _TEMP2.CHURCHDATA.DATA is in a format that is native to another host, or the file encoding does not match the
session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: There were 500 observations read from the data set /folders/myfolders/Programs/Week_6/churchdata.sas7bdat.
NOTE: The data set WORK.CHURCHDATA has 500 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
MPRINT(CHURCH): proc sort data=churchdata out=church1;
MPRINT(CHURCH): by Church;
ERROR: Variable CHURCH not found.
MPRINT(CHURCH): where NY=NY;
ERROR: Variable NY is not on file WORK.CHURCHDATA.
MPRINT(CHURCH): run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.CHURCH1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.CHURCH1 was not replaced because this step was stopped.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
MPRINT(CHURCH): proc print data=church1;
MPRINT(CHURCH): var Church ;
ERROR: Variable CHURCH not found.
MPRINT(CHURCH): 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
92
93 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
106
... View more
03-12-2018
10:11 AM
Hello everyone, I would like to ask if I do any wrong to multiple conditions in macro function: The data set contains the following columns: Employer Receiver Date Amount City State Zip LastNamePart FirstNamePart The question is: Write a SAS program that accesses the data in the permanent SAS data set named churchdata. Subset the data to only contain records with the last name of Church that live in New York State (NY). Do not assume that all such values are in uppercase. I wonder if I use "If...and...then...do" Can I solve this one? Seemed not because in my output, only Last name contained "Church" be selected, but the State did not exclude those other than "NY" I wonder if anyone has other thoughts? Thanks a lot~~ options MPRINT;
%let LastNamePart=Church;
%let State=NY;
%let dirdata=/folders/myfolders;
libname perm "&dirdata";
run;
%macro church(lib=, dsn=,LastNamePart=, State=);
data churchdata;
set"&dirdata/Programs/Week_6/churchdata.sas7bdat";
%if &LastNamePart.=Church
&State. =NY
%then %do;
%end;
proc print data=&lib..&dsn.;
run;
%mend;
%church(lib=perm, dsn=churchdata,LastNamePart=Church,State=NY); LOG: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 options MPRINT;
74 %let LastNamePart=Church;
75 %let State=NY;
76 %let dirdata=/folders/myfolders;
77 libname perm "&dirdata";
NOTE: Libref PERM refers to the same physical library as WEEK_6.
NOTE: Libref PERM was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
78 run;
79 %macro church(lib=, dsn=,LastNamePart=, State=);
80 data churchdata;
81 set"&dirdata/Programs/Week_6/churchdata.sas7bdat";
82 %if &LastNamePart.=Church
83 &State. =NY
84 %then %do;
85 %end;
86 proc print data=&lib..&dsn.;
87 run;
88 %mend;
89
90 %church(lib=perm, dsn=churchdata,LastNamePart=Church,State=NY);
MPRINT(CHURCH): data churchdata;
MPRINT(CHURCH): set"/folders/myfolders/Programs/Week_6/churchdata.sas7bdat";
NOTE: Data file _TEMP2.CHURCHDATA.DATA is in a format that is native to another host, or the file encoding does not match the
session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: There were 500 observations read from the data set /folders/myfolders/Programs/Week_6/churchdata.sas7bdat.
NOTE: The data set WORK.CHURCHDATA has 500 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
MPRINT(CHURCH): proc print data=perm.churchdata;
ERROR: File PERM.CHURCHDATA.DATA does not exist.
MPRINT(CHURCH): 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
91
92
93 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
106
User: sasdemo
Macro Variables
... View more
03-12-2018
06:52 AM
Thank you! It worked. My code is: options MPRINT;
libname DATA '/folders/myfolders';
data tb2000;
set "/folders/myfolders/Programs/Week_6/tb2000.sas7bdat";
proc print data=tb2000;
run;
%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=8); LOG: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73
74 options MPRINT;
75
76
77 libname DATA '/folders/myfolders';
NOTE: Libref DATA was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
78 data tb2000;
79 set "/folders/myfolders/Programs/Week_6/tb2000.sas7bdat";
NOTE: Data file _TEMP2.TB2000.DATA is in a format that is native to another host, or the file encoding does not match the session
encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce
performance.
NOTE: There were 201 observations read from the data set /folders/myfolders/Programs/Week_6/tb2000.sas7bdat.
NOTE: The data set WORK.TB2000 has 201 observations and 22 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
80 proc print data=tb2000;
81 run;
NOTE: There were 201 observations read from the data set WORK.TB2000.
NOTE: PROCEDURE PRINT used (Total process time):
real time 1.54 seconds
cpu time 1.53 seconds
82
83 %macro pam(lib=,dsn=,obs=);
84 proc print data=&lib..&dsn.(obs=&obs);
85 title "Listing of first &obs records from library &lib, member &dsn," ;
86 title2 "on &sysday, &sysdate.." ;
87 run;
88 %mend pam;
89
90
91
92 %pam(lib=WORK, dsn=_LAST_, obs=8);
MPRINT(PAM): proc print data=WORK._LAST_(obs=8);
MPRINT(PAM): title "Listing of first 8 records from library WORK, member _LAST_," ;
MPRINT(PAM): title2 "on Monday, 12MAR18." ;
MPRINT(PAM): run;
NOTE: There were 8 observations read from the data set WORK.TB2000.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.11 seconds
cpu time 0.11 seconds
93
94
95
96 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
109 Still got one day to go through other questions...Whole weekend for SAS...But thanks for everyone. Thanks!
... View more
03-11-2018
11:12 PM
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?
... View more
03-11-2018
10:34 PM
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...:(
... View more
03-11-2018
09:45 PM
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.
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
08-15-2019
02:25 AM
|
