BookmarkSubscribeRSS Feed
PPLee
Fluorite | Level 6

Hi!

 

I have encountered errors while running the following codes, the errors of which varied in each run.  Can you please help me look into the errors (as displayed below), and give me some advice? 

 

Thank you.

 

Best regards

Piea Peng.

 

(Please note: I am using SAS University Edition and SAS 9.4)

 

******************************************************************************************

My codes:

******************************************************************************************

ods html body="C:/Users/pplee/Documents/SASUniversityEdition_1/myfolders_1/temp.htm";

 

data temp;
tday=current_date();
call symput('asof', trim(left(put(tday,worddate20.))));
call symput('file', trim(left(put(tday,MMYYN6.))));
curhref="<LI> </LI> <A href=/main.htm>"|| put(tday,worddate20.)||"</A>";
keep curhref tday;
run;

 

title1 "<H2> Data Dictionary </H2>";

 

proc template;
define style styles.main;
parent=styles.default;
style Table from Output / cellspacing=0 frame=void RULES=NONE;
style Header from HeadersAndFooters / background=color_list("bgA");
style Body from Document / prehtml="<table width=100%> <td align=right>";
end;

run;

 

proc report data=temp
style(REPORT)={background=#002288}
style(HEADER)={foreground=#002288};
column curhref;
define curhref / order "Most Current Version";
run;

 

%macro rawvar;
ods html body="/folders/myfolders_1/&rawvar..html";
proc print noobs data=WORK.IMPORT(where=(rawvar="&rawvar"));
title "Report for rawvar &rawvar";
run;

ods html close;
%mend;

 

proc sort data=WORK.IMPORT out=newdsn nodupkey;
by rawvar;
run;

 

data _null_ ;
set newdsn;
by rawvar;
call execute("%create("||rawvar||")");
run;

 

ods html body="/folders/myfolders_1/main.htm";

 

proc report data=WORK.IMPORT nowd;
column Module Nature rawvar;
define Module / group "Module" width=80 order=internal;
define Nature /group "Nature" width=11;
define rawvar /group width=80 ;
compute rawvar ;
href=trim(rawvar)||".html";
call define(_col_, "URLP", href);
endcomp;

 

title1 "Data Dictionary";
title2 "By Module and Nature";
title3 height=2 "Date As of &asof";

run;

 

ods html close;
ods html close;

ods html;
ods pdf;

 

******************************************************************************************

One of the errors I had is as follows:

******************************************************************************************

1 OPTIONS NOSYNTAXCHECK;
2 TITLE;
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
3 FOOTNOTE;
4 OPTIONS LOCALE=en_SG DFLANG=LOCALE;
5 DATA _NULL_;
149 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
_________________
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.
 
6 RUN;
7 OPTIONS VALIDVARNAME=V7;
8 OPTIONS VALIDMEMNAME=EXTEND;
9 FILENAME _HTMLOUT TEMP;
10 FILENAME _RTFOUT TEMP ENCODING='UTF-8';
10 FILENAME _RTFOUT TEMP ENCODING='UTF-8'
_
49
10 ! ;
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.
 
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.8;
18 %LET _CLIENTVERSION=3.8;
19 %LET _CLIENTMODE=basic;
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
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 '.'
_
49
28 ! ;
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.
 
29 DATA _NULL_;
30 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));
____________
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.
 
31 RUN;
32 FILENAME _CWD;
33
34 %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR(/folders/myshortcuts/myfolders_1/create_hyperlink_data_dic_7Nov2019.sas));
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
35 %LET _BASEURL = %BQUOTE(http://localhost:10080/SASStudio/);
30 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD'));
____
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.
 
36 %LET _EXECENV=SASStudio;
37 DATA _NULL_;
38 CALL SYMPUT("GRAPHINIT","");
39 CALL SYMPUT("GRAPHTERM","");
40 RC=TSLVL('SASXGOPT','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;
NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks.
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);
42 IF (RC^=' ') THEN DO;
___________
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.
 
60 %LET _SASWSTEMP_=%BQUOTE(/folders/myfolders/.sasstudio/.images/0166719c-dd9f-4643-8e14-d41cefa9523f);
61 ODS LISTING CLOSE;
62 ODS AUTONAVIGATE OFF;
63 ODS GRAPHICS ON;
64 ODS HTML5 (ID=WEB) DEVICE=SVG GPATH="&_SASWSTEMP_" ENCODING=utf8 ANCHOR='web-0166719c-dd9f-4'
 
_________________________________________
_______________________________________
___________
____________
49
49
49
49
64 ! ACCESSIBLE_GRAPH FILE=_HTMLOUT (TITLE='Results: create_hyperlink_data_dic_7Nov2019.sas') STYLE=Htmlblue
64 ! OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE' CSS_PREFIX='.ods_0166719c-dd9f-4643-8e14-d41cefa9523f'
64 ! BODY_ID='div_0166719c-dd9f-4643-8e14-d41cefa9523f' );
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.
 
65 ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT sasdate;
66 ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT ACCESSIBLE;
67 &GRAPHINIT;
68 OPTIONS FIRSTOBS=1;
69 OPTIONS OBS=MAX;
70 OPTIONS DTRESET DATE NUMBER NOTES;
71 OPTIONS NOSYNTAXCHECK;
72
73 data temp;
74 tday=current_date();
75 call symput('asof', trim(left(put(tday,worddate20.))));
49: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
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 call
75 ! symput('asof'
_
49
75 ! , trim(left(put(tday,worddate20.))));
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.
 
76 call symput('file', trim(left(put(tday,MMYYN6.))));
77 curhref="<LI> </LI> <A href=/main.htm>"|| put(tday,worddate20.)||"</A>";
78 keep curhref tday;
79 run;
80
81
82
83 OPTIONS NOSYNTAXCHECK;
84 ODS HTML CLOSE;
85 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
86 QUIT;RUN;
87 ODS HTML5 (ID=WEB) CLOSE;
88
89 ODS RTF (ID=WEB) CLOSE;
90 ODS PDF (ID=WEB) CLOSE;
91 FILENAME _GSFNAME;
92 DATA _NULL_;
93 RUN;
94 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
95
 
 
 
******************************************************************************************
2 REPLIES 2
Cynthia_sas
SAS Super FREQ

Hi:

  I am not sure of your entire issue, but one of your issues is probably THIS: 

ods html body="C:/Users/pplee/Documents/SASUniversityEdition_1/myfolders_1/temp.htm";

OR THIS

ods html body="/folders/myfolders_1/main.htm";

 

  When you use SAS University Edition you must write to your shared folder location. You were instructed to define that location as

/folders/myfolders -- not /folders/myfolders_1

 

  You also cannot write to a C: drive location when you use SAS University Edition in a Virtual Machine. If you have any doubt about the correct path, please right click on your MyFolders top node in the Server Files and Folders navigation pane on the left. Then select Properties after the right click. In the  Location area of the Properties window, you will see the correct shared folder location, as it is known to SAS University Edition.

 

Hope this helps,

Cynthia

PPLee
Fluorite | Level 6

Hi Cynthia

 

Thank you very much for your prompt reply.  I agree with your advice.

 

Best regards

Piea Peng

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 747 views
  • 0 likes
  • 2 in conversation