About mdavidson

mdavidson · ‎09-04-2012

I'm trying to use the %gettweet macro downloaded from here: http://support.sas.com/resources/papers/proceedings11/324-2011.pdf I'm getting the following error: filename XMLLib "&PATH/twitterOutput.xml"; libname XMLLib xml xmlmap=SXMLMAP ACCESS=readonly; NOTE: Libref XMLLIB was successfully assigned as follows: Engine: XML Physical Name: XMLLIB ERROR: Namespace was not declared previously. encountered during XMLInput parsing occurred at or near line 15, column 22340 I think the problem lies somewhere in my XML map file, pasted below. Any suggestions? (%gettweet) <?xml version="1.0" encoding="UTF-8"?> <SXLEMAP name="Tweet" version="1.2"> <TABLE name="entry"> <TABLE-DESCRIPTION>entry</TABLE-DESCRIPTION> <TABLE-PATH syntax="XPath">/feed/entry</TABLE-PATH> <COLUMN name="entry_ORDINAL" ordinal="YES"> <INCREMENT-PATH beginend="BEGIN" syntax="XPath">/feed/entry</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="id"> <PATH syntax="XPath">/feed/entry/id</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>38</LENGTH> </COLUMN> <COLUMN name="published"> <PATH syntax="XPath">/feed/entry/published</PATH> <TYPE>numeric</TYPE> <DATATYPE>datetime</DATATYPE> <FORMAT width="19">IS8601DT</FORMAT> <INFORMAT width="19">IS8601DT</INFORMAT> </COLUMN> <COLUMN name="title"> <PATH syntax="XPath">/feed/entry/title</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>139</LENGTH> </COLUMN> <COLUMN name="updated"> <PATH syntax="XPath">/feed/entry/updated</PATH> <TYPE>numeric</TYPE> <DATATYPE>datetime</DATATYPE> <FORMAT width="19">IS8601DT</FORMAT> <INFORMAT width="19">IS8601DT</INFORMAT> </COLUMN> <COLUMN name="twitter_source"> <PATH syntax="XPath">/feed/entry/twitter:source</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>49</LENGTH> </COLUMN> <COLUMN name="twitter_lang"> <PATH syntax="XPath">/feed/entry/twitter:lang</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>2</LENGTH> </COLUMN> <COLUMN name="uri"> <PATH syntax="XPath">/feed/entry/author/uri</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>34</LENGTH> </COLUMN> <COLUMN name="content"> <PATH syntax="XPath">/feed/entry/content</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>444</LENGTH> </COLUMN> </TABLE> </SXLEMAP>

mdavidson · ‎08-28-2012

I'm able to navigate to the drive, so it is definitely mounted and online. Any other ideas?

mdavidson · ‎08-28-2012

I've run into a problem with a filename statement hanging all of the sudden. This code ran fine in the past but when I submit this code, SAS hangs at "Running..." Any ideas on what it could be? filename mymac "***directory path***"; %include mymac ('*.sas'); Here's my setup. SAS 9.2 on UNIX. Enterprise Guide 4.3

mdavidson · ‎08-28-2012

Thanks Don. That's a goood tip, I was not aware of that option. What does your initilization program look like? Something like this? filename mymac "***path***"; %include mymac ('*.sas');

mdavidson · ‎07-23-2012

Has anyone ever written a program to decode a vehicle's VIN in order to better organize make, model, year, trim level, etc... There are several free websites out there that will decode a VIN, but I'm attempting to do this in SAS. Is there anything out there?

mdavidson · ‎06-25-2012

Here's what is not working. When I open EG and run one of the autocall macros I don't have any problems. When I run that same macro via stored process, the macro fails (ERROR 180-322: Statement is not valid or it is used out of proper order. ) So for some reason the stored process server is not referencing the autocall library. I first modified the ./opt/biserver/Lev1/SASApp/sasv9_usermods.cfg file and still ran into the same problem. Then I even went one step furthur and modified the /opt/SAS/SASFoundation/9.2/nls/en/sasv9.cfg file, and I still have the same problem. Here's what my sasv9.cfg file looks like: -- [root@sas02 en]# more sasv9.cfg /* This config file contains the default SAS configuration option settings which are defined during the SAS Foundation Installation process. This file gets recreated during SAS Installation Upgrade process therefore user specified settings added to this file will be lost during an upgrade. With this in mind, we strongly discourage editing this file, as the edits will be lost on upgrade. A new configuration file named sasv9_local.cfg has been created in the !SASROOT directory to store user specified settings. Settings in this file will remain in place during upgrades to this SAS Installation and will override the default options values when the same options are contained in both places. */ /* Default options: */ -insert sashelp !SASROOT/nls/en/sascfg -insert helploc !SASROOT/X11/native_help -SET SASAUTOS ("***macro path***") -- And I checked, yes the stored process is running via SASApp - Logical Stored Process Server. I'm going to have to get with my UNIX admin and open up the config file located in ./opt/biserver/Lev1/SASApp/StoredProcessServer

mdavidson · ‎06-25-2012

Hello -- I've set up an autocall macro library on our SAS server (UNIX, SAS EG 4.3) by adding the following option to the config file: -SET SASAUTOS ("***macro path****") This works just as intended, all of the macros in the "macro path" folder are available to the session. However, I'm running into problems when running stored processes which reference those same shared macros. I know the sasutos option should be in the usermods file, but I've inserted the sasautos option in all of the following files but I've still had no luck. ./opt/biserver/Lev1/SASMeta/sasv9_usermods.cfg ./opt/biserver/Lev1/SASMeta/WorkspaceServer/sasv9_usermods.cfg ./opt/biserver/Lev1/SASMeta/MetadataServer/sasv9_usermods.cfg ./opt/biserver/Lev1/SASMeta/BatchServer/sasv9_usermods.cfg ./opt/biserver/Lev1/SASApp/sasv9_usermods.cfg ./opt/biserver/Lev1/SASApp/StoredProcessServer/sasv9_usermods.cfg ./opt/biserver/Lev1/SASApp/WorkspaceServer/sasv9_usermods.cfg ./opt/biserver/Lev1/SASApp/PooledWorkspaceServer/sasv9_usermods.cfg I was doing some reading and came across this note: http://support.sas.com/kb/32/231.html which references multiple config files being referenced by the stored process server: Store the .sas files for the user-created AUTOCALL macros in a directory other than the ones listed above, which must be concatenated into the SASAUTOS system option search path. The default SASAUTOS directory search path is determined when SAS initializes by reading the SAS configuration file(s) associated with the installation. Multiple SAS configuration files are read by default when a stored process is executed through a workspace server or stored process server. For example, in a Windows environment the SAS configuration files read by default will be similar to this: <BIConfigDir>\Lev1\SASMain\StoredProcessServer\sasv9_StorProcSrv.cfg <BIConfigDir>\Lev1\SASMain\sasv9.cfg !sasroot\sasv9.cfg !sasroot\nls\en\SASV9.CFG Any ideas on what config files on UNIX I need to modify to make my autocall library available to the stored process server?

mdavidson · ‎06-19-2012

This is strange, this code worked briefly yesterday. Any ideas? I'm trying to create a directory folder called "aa". I've attached the SAS code along with the log below. %macro chk_dir(dir=) ; /* options noxwait;*/ %local rc fileref ; %let rc = %sysfunc(filename(fileref,&dir)) ; %if %sysfunc(fexist(&fileref)) %then %put NOTE: The directory "&dir" exists ; %else %do ; %sysexec which mkdir &dir ; %put %sysfunc(sysmsg()) The directory has been created. ; %put &fileref; %end ; %let rc=%sysfunc(filename(fileref)) ; %mend chk_dir ; %chk_dir(dir=home/sas/permanent/BI Group SAS Code/DecisionSciences/aa) ; %macro chk_dir(dir=) ; /* options noxwait;*/ %local rc fileref ; %let rc = %sysfunc(filename(fileref,&dir)) ; %if %sysfunc(fexist(&fileref)) %then %put NOTE: The directory "&dir" exists ; %else %do ; %sysexec which mkdir &dir ; %put %sysfunc(sysmsg()) The directory has been created. ; %put &fileref; %end ; %let rc=%sysfunc(filename(fileref)) ; %mend chk_dir ; %chk_dir(dir=home/sas/permanent/BI Group SAS Code/DecisionSciences/aa) ; ***********LOG************** 14 GOPTIONS ACCESSIBLE; 15 %macro chk_dir(dir=) ; 16 /* options noxwait;*/ 17 %local rc fileref ; 18 %let rc = %sysfunc(filename(fileref,&dir)) ; 19 %if %sysfunc(fexist(&fileref)) %then 20 %put NOTE: The directory "&dir" exists ; 21 %else 22 %do ; 23 %sysexec mkdir &dir ; 24 %put %sysfunc(sysmsg()) The directory has been created. ; 25 %put &fileref; 26 %end ; 27 %let rc=%sysfunc(filename(fileref)) ; 28 %mend chk_dir ; 29 30 %chk_dir(dir=home/sas/permanent/BI Group SAS Code/DecisionSciences/aa) ; MLOGIC(CHK_DIR): Beginning execution. MLOGIC(CHK_DIR): Parameter DIR has value home/sas/permanent/BI Group SAS Code/DecisionSciences/aa MLOGIC(CHK_DIR): %LOCAL RC FILEREF MLOGIC(CHK_DIR): %LET (variable name is RC) SYMBOLGEN: Macro variable DIR resolves to home/sas/permanent/BI Group SAS Code/DecisionSciences/aa SYMBOLGEN: Macro variable FILEREF resolves to #LN00035 MLOGIC(CHK_DIR): %IF condition %sysfunc(fexist(&fileref)) is FALSE MLOGIC(CHK_DIR): %SYSEXEC mkdir &dir SYMBOLGEN: Macro variable DIR resolves to home/sas/permanent/BI Group SAS Code/DecisionSciences/aa MLOGIC(CHK_DIR): %PUT %sysfunc(sysmsg()) The directory has been created. WARNING: Physical file does not exist, /opt/biserver/Lev1/SASApp/home/sas/permanent/BI Group SAS Code/DecisionSciences/aa. The directory has been created. MLOGIC(CHK_DIR): %PUT &fileref SYMBOLGEN: Macro variable FILEREF resolves to #LN00035 #LN00035 MLOGIC(CHK_DIR): %LET (variable name is RC) MLOGIC(CHK_DIR): Ending execution. 31

mdavidson · ‎06-18-2012

Thanks, this is good to know when I'm using base but in this case I'm using EG. Good to know!

mdavidson · ‎06-18-2012

Thanks, this worked great. I'm a little embarrassed it was that simple. Also, I'm not sure what you mean when you say "which" with regards to the full path.

mdavidson · ‎06-15-2012

Hello -- I know how to do this in a Windows environment, but sadly I have no idea how to do the same on a UNIX environment. Can anybody assist? %macro chk_dir(dir=) ; options noxwait; %local rc fileref ; %let rc = %sysfunc(filename(fileref,&dir)) ; %if %sysfunc(fexist(&fileref)) %then %put NOTE: The directory "&dir" exists ; %else %do ; %sysexec md &dir ; %put %sysfunc(sysmsg()) The directory has been created. ; %end ; %let rc=%sysfunc(filename(fileref)) ; %mend chk_dir ; %chk_dir(dir=c:\temp) ; %* <== your directory specification goes here ; %chk_dir(dir=c:\temp\sascode) http://www.sas.com/offices/europe/uk/support/sas-hints-tips/ht1_mar04.html

mdavidson · ‎04-06-2011

Thanks Vince and Graham. I've got Don's example working -- only one small thing I'd like to change and I'm not sure exactly how to do it. Is there any way to change the style of Don's message? I don't believe I can change the default _ODSSTYLE value since the %STPBEGIN and %STPEND macro variables are turned off, as turning them on would cause a problem with the _WEBOUT file being in use.

mdavidson · ‎04-04-2011

I think you should have the security set up in management console in your metadata, but here is a list of automatic variables available for stored procedures. Maybe metauser, or metaperson would help you. http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/reserved.html

mdavidson · ‎04-04-2011

Hello, I have a stored process that I'd like to stream results back to the user. I'd like to display a few messages to the user, something like: 1) Your process has been submitted. 2) Your query is processing. 3) (display results) The problem that I'm having is that I can't seem to overwrite the previous _webout file. SAS seems to simply append to the previous _webout file by default. Is there any way to override this?

mdavidson · ‎01-05-2011

This will subtract 24 hours from your date field. Change the -24 to whatever you want in order to add/subtract any number of hours from a date time. intnx('hour', **insert your date field here**, -24);

Online Status	Offline
Date Last Visited	‎09-11-2023 01:36 PM

Forecasting Cumulative Sales Data

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Reading Data Into OPTMODEL Procedure

Re: Reading Data Into OPTMODEL Procedure

Re: Getting %if to evaluate if a macro variable is BETWEEN two numbers

Re: Getting %if to evaluate if a macro variable is BETWEEN two numbers

Re: How to do first. and last. with missing data (retain/lag?)

Re: How to do first. and last. with missing data (retain/lag?)

Re: Reading Data Into OPTMODEL Procedure

Getting %if to evaluate if a macro variable is BETWEEN two numbers

Re: Basic SAS: printing out a table based on last names

Re: Remove leading zeros ODS output

Re: How to calculate time difference (minutes) between two datetime fi...

XML Namespace Issue (%gettweet macro)

Re: Filename Statement Hanging

Filename Statement Hanging

Re: Autocall Library and Stored Process Server

Vehicle VIN Decoding

Re: Autocall Library and Stored Process Server

Autocall Library and Stored Process Server

Re: Create a directory on UNIX

Re: Create a directory on UNIX

Re: Create a directory on UNIX

Create a directory on UNIX

Re: Overwrite _webout file for multiple outputs

Re: Accessing User Identity metadata from within stored process

Overwrite _webout file for multiple outputs

Re: Format 20101222 15:59:57.94