Hello everybody,
I run my codes, but the result viewer window shows 'This page cannot be displayed'.
I am using bigdata and running time is killing me.
What is the problem?
How can I fix that?
Thanks in advance.
Regarding redirecting output to a file: Start studying the ODS. First issue a statement in your code that closes all destinations (http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/viewer.htm#a002233267.htm), and then open one destination (preferrably HTML) to a file. Use ods html close at the end of your code. You can then review the output file for size & content.
What ODS destination did you send the result to? Can you show code that generated the output? At least any ODS part if any.
That message looks like a broken url.
Send the ODS HTML output to a file and inspect that once your jobs have run. Maybe you create a file that is too big to be served via HTML or too big to be shown in a SAS result window (client running out of memory, overflow of internal structure).
And please clarify how you run your code
- Enterprise Guide: if yes, with local or remote workspace server
- SAS Studio
- Display Manager; specify operating system and access method (local, X Windows, etc)
To me it looks like the combined amount of outputs is just too big for the results window. Run a proc options to see the settings pertinent to memory (MEMSIZE et al). How much RAM does your notebook have?
SAS (r) Proprietary Software Release 9.4 TS1M3
Host Options:
ACCESSIBILITY=STANDARD
Specifies whether accessibility features are enabled in the Customize Tool dialog
box and in some Properties dialog boxes.
ALIGNSASIOFILES Aligns SAS files on a page boundary for improved performance.
ALTLOG= Specifies the location for a copy of the SAS log when SAS is running in batch mode.
ALTPRINT= Specifies the location for a copy of the SAS procedure output when SAS is running
in batch mode.
AUTHPROVIDERDOMAIN=
Specifies the authentication provider that is associated with a domain.
AUTHSERVER= Specifies the domain server that finds and authenticates secure server logins.
AWSCONTROL=(SYSTEMMENU MINMAX TITLE)
Specifies whether the main SAS window includes a title bar, a system control menu,
and minimize and maximize buttons.
AWSDEF=(0 0 79 79)
Specifies the location and dimensions of the main SAS window when SAS initializes.
AWSMENU Displays the menu bar in the main SAS window.
AWSMENUMERGE Embeds menu items that are specific to Windows in the main menus.
AWSTITLE= Specifies the text that appears in the title bar of the main SAS window.
COMAUX1= Specifies the first alternate communications access method.
COMAUX2= Specifies the second alternate communications access method.
COMDEF=(BOTTOM CENTER)
Specifies the location where the SAS Command window is displayed by default.
CONFIG=E:\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg
Specifies the configuration file that is used when initializing or overriding the
values of SAS system options.
NODBCS Disables double-byte character sets.
DBCSLANG=NONE Specifies a double-byte character set language.
DBCSTYPE=NONE Specifies the encoding method to use for a double-byte character set.
ECHO= Specifies the message to be echoed to the SAS log while initializing SAS.
EMAILDLG=NATIVE Specifies whether to use the native e-mail dialog box that is provided by your
e-mail application or the e-mail dialog box that is provided by SAS.
EMAILSYS=MAPI Specifies the e-mail protocol to use for sending electronic mail.
ENCODING=WLATIN1 Specifies the default character-set encoding for the SAS session.
ENHANCEDEDITOR Invokes the Enhanced Editor when SAS starts.
FILELOCKWAIT=0 Specifies the number of seconds that SAS will wait for a locked file.
FILELOCKWAITMAX=600
Specifies the number of seconds that SAS waits for a locked file to become
available.
FILTERLIST= Specifies an alternative set of file filter specifications to use for the Open and
Save As dialog boxes.
FONT=(Sasfont 8) Specifies a font to use for SAS windows.
FONTALIAS= Assigns a Windows font to one of the SAS fonts.
NOFULLSTIMER Does not write performance statistics to the SAS log.
HELPLOC=( "!SASROOT\core\help" "!MYSASFILES\classdoc"
"!SASROOT\iml\sasmisc\packages\abovebelow\help" )
Specifies the location of the text and index files for the facility that is used
to view the online SAS Help and Documentation.
HELPREGISTER= Registers help files to access from the main SAS window Help menu.
HOSTPRINT Prints using Windows printing.
NOICON Restores the main SAS window.
JREOPTIONS=( -DPFS_TEMPLATE=E:\SASHome\SASFoundation\9.4\tkjava\sasmisc\qrpfstpt.xml
-Djava.class.path=E:\SASHome\SASVersionedJarRepository\eclipse\plugins\sas.launcher.jar
-Djava.security.auth.login.config=E:\SASHome\SASFoundation\9.4\tkjava\sasmisc\sas.login.config
-Djava.security.policy=E:\SASHome\SASFoundation\9.4\tkjava\sasmisc\sas.policy
-Djava.system.class.loader=com.sas.app.AppClassLoader
-Dlog4j.configuration=file:/E:/SASHome/SASFoundation/9.4/tkjava/sasmisc/sas.log4j.properties
-Dsas.app.class.path=E:\SASHome\SASVersionedJarRepository\eclipse\plugins\tkjava.jar
-Dsas.ext.config=E:\SASHome\SASFoundation\9.4\tkjava\sasmisc\sas.java.ext.config
-Dsas.jre.libjvm=E:\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin\server\jvm.dll
-Dtkj.app.launch.config=E:\SASHome\SASVersionedJarRepository\picklist -Xms128m
-Xmx128m )
Specifies the Java Runtime Environment options for SAS.
LOADMEMSIZE=0 Specifies a suggested amount of memory that is needed for executable programs
loaded by SAS.
LOCALE=EN_US Specifies a set of attributes in a SAS session that reflect the language, local
conventions, and culture for a geographical region.
LOG= Specifies a location for the SAS log when SAS is running in batch mode.
MAXMEMQUERY=0 Specifies the maximum amount of memory that is allocated for procedures.
MEMBLKSZ=16777216 Specifies the memory block size for Windows memory-based libraries.
MEMCACHE=0 Specifies to use the memory-based libraries as a SAS file cache.
NOMEMLIB Does not process the Work library as a memory-based library.
MEMMAXSZ=2147483648
Specifies the maximum amount of memory to allocate for using memory-based
libraries.
MEMSIZE=2147483648
Specifies the limit on the amount of virtual memory that can be used during a SAS
session.
MSG=( "!SASROOT\core\sasmsg" "!SASROOT\accelmva\sasmsg"
"!SASROOT\access\sasmsg" "!SASROOT\af\sasmsg" "!SASROOT\cmp\sasmsg"
"!SASROOT\graph\sasmsg" "!SASROOT\inttech\sasmsg" "!SASROOT\lasreng\sasmsg"
"!SASROOT\spdsclient\sasmsg" )
Specifies the path to the library that contains SAS messages.
NOMSGCASE Specifies that SAS writes notes, warning, and error messages in mixed casing.
NONLSCOMPATMODE Encodes data using the SAS session encoding.
NUMKEYS=12 Specifies the number of available function keys.
NUMMOUSEKEYS=3 Specifies the number of mouse buttons that SAS displays in the KEYS window.
NOOPLIST Does not write SAS system option settings to the SAS log.
PATH=( "!SASROOT\core\sasexe" "!SASROOT\aacomp\sasexe"
"!SASROOT\accelmva\sasexe" "!SASROOT\access\sasexe" "!SASROOT\af\sasexe"
"!SASROOT\assist\sasexe" "!SASROOT\baseui\sasexe" "!SASROOT\cmp\sasexe"
"!SASROOT\connect\sasexe" "!SASROOT\creditscrnod\sasexe" "!SASROOT\dmine\sasexe"
"!SASROOT\dmscore\sasexe" "!SASROOT\eis\sasexe" "!SASROOT\ets\sasexe"
"!SASROOT\etscomp\sasexe" "!SASROOT\fsp\sasexe" "!SASROOT\graph\sasexe"
"!SASROOT\graphcomp\sasexe" "!SASROOT\hadoopbasics\sasexe"
"!SASROOT\hpdmine\sasexe" "!SASROOT\hpets\sasexe" "!SASROOT\hps\sasexe"
"!SASROOT\hpstat\sasexe" "!SASROOT\hptmine\sasexe" "!SASROOT\iml\sasexe"
"!SASROOT\inttech\sasexe" "!SASROOT\lasreng\sasexe" "!SASROOT\or\sasexe"
"!SASROOT\qc\sasexe" "!SASROOT\share\sasexe" "!SASROOT\spdsclient\sasexe"
"!SASROOT\stat\sasexe" "!SASROOT\statcomp\sasexe" "!SASROOT\tmine\sasexe"
"!SASROOT\txtancomp\sasexe" )
Specifies one or more search paths for SAS executable files.
PFKEY=(WIN) Specifies which set of function keys to designate as the primary set of function
keys.
PRINT= Specifies a location for SAS output when running in batch mode.
PRNGETLIST Recognizes printers that are attached to the system.
PRTABORTDLGS=BOTH Specifies when to display the Print Abort dialog box.
NOPRTPERSISTDEFAULT
SAS uses the default printer.
PRTSETFORMS Include the Use Forms checkbox in the Print Setup dialog box.
REALMEMSIZE=0 Specifies the amount of real memory SAS can expect to allocate.
REGISTER= Adds an application to the Tools menu in the main SAS window.
RESOURCESLOC=( "E:\SASHome\SASFoundation\9.4\core\resource" )
Specifies a directory location of the files that contain SAS resources.
RTRACE=NONE Produces a list of resources that are read or loaded during a SAS session.
RTRACELOC= Specifies the pathname of the file to which the list of resources that are read or
loaded during a SAS session is written.
SASCONTROL=(SYSTEMMENU MINMAX)
Specifies whether the SAS application windows include system and control menus,
and minimize and maximize buttons.
SASINITIALFOLDER= When SAS starts, changes the working folder and the default folder for the Open
and Save As dialog boxes to a specified folder.
NOSCROLLBARFLASH Disables mouse and keyboard focus on the scroll bar to eliminate cursor flashing.
SET=[FT15F001 = 'FT15F001.DAT'] [SASROOT = "E:\SASHome\SASFoundation\9.4"] [SASHOME = "E:\SASHome"]
[SASAUTOS = ( "!SASROOT\core\sasmacro" "!SASROOT\aacomp\sasmacro"
"!SASROOT\accelmva\sasmacro" "!SASROOT\assist\sasmacro" "!SASROOT\dmine\sasmacro"
"!SASROOT\dmscore\sasmacro" "!SASROOT\eis\sasmacro" "!SASROOT\ets\sasmacro"
"!SASROOT\graph\sasmacro" "!SASROOT\hps\sasmacro" "!SASROOT\iml\sasmacro"
"!SASROOT\inttech\sasmacro" "!SASROOT\lasreng\sasmacro"
"!SASROOT\or\sasmacro" "!SASROOT\qc\sasmacro" "!SASROOT\share\sasmacro"
"!SASROOT\stat\sasmacro" "!SASROOT\tmine\sasmacro" )] [SAMPSIO = (
"!SASROOT\core\sample" "!SASROOT\access\sample" "!SASROOT\accesssample\sample"
"!SASROOT\connect\sample" "!SASROOT\dmine\sample" "!SASROOT\eis\sample"
"!SASROOT\ets\sample" "!SASROOT\graph\sample" "!SASROOT\hps\sample"
"!SASROOT\hpstat\sample" "!SASROOT\iml\sample" "!SASROOT\inttech\sample"
"!SASROOT\or\sample" "!SASROOT\qc\sample" "!SASROOT\share\sample"
"!SASROOT\stat\sample" "!SASROOT\tmine\sample" )] [SAMPsrc=(
"!SASROOT\core\sample" "!SASROOT\access\sample" "!SASROOT\accesssample\sample"
"!SASROOT\connect\sample" "!SASROOT\dmine\sample" "!SASROOT\eis\sample"
"!SASROOT\ets\sample" "!SASROOT\graph\sample" "!SASROOT\hps\sample"
"!SASROOT\hpstat\sample" "!SASROOT\iml\sample" "!SASROOT\inttech\sample"
"!SASROOT\or\sample" "!SASROOT\qc\sample" "!SASROOT\share\sample"
"!SASROOT\stat\sample" "!SASROOT\tmine\sample" )] [INSTALL = (
)] [MYSASFILES = "?FOLDERID_Documents\My SAS Files\9.4"] [SASCFG =
"E:\SASHome\SASFoundation\9.4\nls\en"] [SAS_NO_RANDOM_ACCESS = "1"] [DTJ_CLASSPATH =
"E:\SASHome\SASFoundation\9.4\dmine\sasmisc\dtj.jar;E:\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jr
e\lib\rt.jar"] [SASAML = !SASROOT\share\sasmacro] [EISIMAGE = !SASROOT\eis\sample]
Defines a SAS environment variable.
NOSGIO Disables the Scatter/Gather I/O feature.
SLEEPCNTL=NO Specifies whether SAS prevents Windows from going into sleep mode.
SLEEPWINDOW Enables the SLEEP window.
SORTANOM= Specifies options for the host sort utility.
SORTCUT=0 Specifies the data size in number of observations above which SAS uses the host
sort instead of the internal SAS sort.
SORTCUTP=0 Specifies the data size in bytes above which SAS uses the host sort instead of the
internal SAS sort.
SORTDEV= Specifies the pathname that is used for temporary files that are created by the
host sort utility.
SORTNAME= Specifies the name of the host sort utility.
SORTPARM= Specifies the parameters for the host sort utility.
SORTPGM=BEST Specifies whether to use the SAS sort utility or the host sort utility or to let
SAS choose the sort utility.
SPLASH Displays the splash screen (logo screen) when SAS starts.
SPLASHLOC= Specifies the location of the splash screen (logo screen) bitmap that appears when
SAS starts.
SSLCERTISS= Specifies the name of the issuer of the digital certificate that SSL should use.
SSLCERTSERIAL= Specifies the serial number of the digital certificate that SSL should use.
SSLCERTSUBJ= Specifies the subject name of the digital certificate that SSL should use.
STIMEFMT=(NLDATM2. HMS TIMEAMPM KB MEMFULL TSFULL NC)
Specifies the format that is used to display the FULLSTIMER and STIMER output for
timestamp, memory, CPU and elapsed time statistics.
STIMER Writes real and CPU time to the SAS log.
SYSGUIFONT= Specifies a font to use for the button text and the descriptive text.
SYSIN= Specifies the SAS program to execute in batch.
SYSPRINT=("Foxit Reader PDF Printer")
Specifies a destination printer for printing SAS output.
TOOLDEF=(TOP RIGHT)
Specifies the Toolbox display location.
NOUPRINTMENUSWITCH
Disables the Universal Printing commands on the File menu.
USERCONFIG Process .sasv9.cfg and sasv9.cfg configuration files in user's home directory.
USERICON= Specifies the pathname of the resource file that is associated with the
user-defined icon.
NOVERBOSE Does not write start-up system options to the SAS log.
NOWEBUI Disables Web enhancements.
NOWINDOWSMENU Disables the Window menu in the main window if NOAWSMENUMERGE is specified.
XCMD Enables the X command in SAS.
NOXMIN Starts the application that is specified in the X command in the default active
state.
XSYNC Windows commands execute synchronously with SAS.
XWAIT The DOS shell closes and returns to SAS after EXIT is entered on the command line.
Thanks in advance.
My next approaches would be
- try -memsize=max during SAS invocation
- redirect the ods output to a file, and look at that
Would you tell me how can I do that?
Since you use SAS display manager, which means that you either start SAS from the commandline or from a desktop link, add -memsize max to this commandline.
Regarding redirecting output to a file: Start studying the ODS. First issue a statement in your code that closes all destinations (http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/viewer.htm#a002233267.htm), and then open one destination (preferrably HTML) to a file. Use ods html close at the end of your code. You can then review the output file for size & 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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.