One obvious item is your SAS comment syntax. If you start the comment with an asterisk character, the comment will not be terminated until the next semi-colon -- you have an asterisk and slash which is treated as part of the comment. So, I would say that your code is not executing, which would be the cause of your symptom. Consider adding the following self-diagnosis statement in your program for debugging purposes: putlog '>diag00>' / _all_; Scott Barry SBBWorks, Inc. ... View more

The option MINOPERATOR is new with SAS 9.2. MINOPERATOR System Option http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/a003092012.htm Scott Barry SBBWorks, Inc. ... View more

Basic question: was there any difficulties at all with the install process, presuming you were the individual who did the install on your machine? Has SAS ever been installed previously on the same machine? And do you have an account with ADMIN authority for the machine? Otherwise, I would recommend contacting SAS Technical Support to open an issue. Scott Barry SBBWorks, Inc. ... View more

With the DATA step approach and SYMPUT, you would use the PUT function in the SYMPUT call to generate a "formatted" value. And with the PROC SQL approach, the FORMAT= keyword is added to the SELECT to generate a formatted value. Scott Barry SBBWorks, Inc. ... View more

This is a SAS software architecture limit - here is the current DOC that mentions the particulars: Names in the SAS Language http://support.sas.com/documentation/cdl/en/lrcon/61722/HTML/default/a000998953.htm Scott Barry SBBWorks, Inc. ... View more

Also, consider the presence or lack of a RUN; statement within each macro will have an impact on whether your SYMPUT SAS macro variables are GLOBAL or LOCAL. Check the SAS MACRO documentation link below on this topic, as well as other SAS support website http://support.sas.com/ technical reference material on the topic. Special Cases of Scope with the CALL SYMPUT Routine http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/tw3514-symput.htm Scott Barry SBBWorks, Inc. ... View more

I would suggest using %SYSFUNC and the SAS INDEX function, given what you have shown for code. Scott Barry SBBWorks, Inc. ... View more

SAS support website http://support.sas.com/ SEARCH facility has several technical documents and conference papers on this topic - also, I did a Google advanced using the argument below to find reference items related to your post: append sas data to oracle table site:sas.com However, there is at least one SAS TECHNOTE with a related HOTFIX - see link below, in case it may apply: Problem Note 16338: Using PROC APPEND to insert rows into an Oracle table may report an error as a note http://support.sas.com/kb/16/338.html Scott Barry SBBWorks, Inc. ... View more

You can either tailoring the -work option in sasv9.cfg member or it can be changed at SAS invocation time. You will want to review the SAS v9.2 companion document for your particular OS platform. Here is a link to a SAS conference paper on SAS v9.2 with particular references: http://support.sas.com/rnd/papers/sgf2008/opsys92.pdf Scott Barry SBBWorks, Inc. ... View more

Off-topic: do consider that DEFRAGs these days in z/OS, other than increasing first-extent sizes, is pretty much unnecessary, what with DFSMS and 3rd party software like STOPX37. Also, I would encourage you to code a higher FRAGI parameter to cut-back on the number of excessive defrags that re-claim even 1 extent. Scott Barry SBBWorks, Inc. ... View more

Thanks to data _null_; for info about the TERMSTR= option -- I was unfamiliar with using it. Regards, Scott ... View more

Your input data shows a trailing period character (note the SAS diagnostic mentions column 5-15). The problem is in your input data, not having the expected delimiter character or an end-of-record condition. Scott Barry SBBWorks, Inc. ... View more

You're making an assumption that forum subscribers have awareness on this topic, with very little details contributed with your question? Scott Barry SBBWorks, Inc. ... View more

Do consider that you are posting to a general forum, although Cynthia is quite an incredible individual with her time and effort and dedication to tracking posts, replies and the like. Please provide some additional diagnostic information, please, such as adding a command: IF _N_ LE 5 THEN PUTLOG '>DIAG>' _ALL_ / _INFILE_; which will dump your input record to the SASLOG for the first 5 input records. But first, consider: from the diagnostic message, can you confirm that your "date field" is in the expected input format, as you have defined with the INFORMAT statement? Scott Barry SBBWorks, Inc. ... View more

You might be in the wrong neighborhood - the Google search argument below revealed some better destinations to pose your question/issue/problem: attachmate vba programming forum Scott Barry SBBWorks, Inc. ... View more