How about the following code ,please advise me, Thanks! Mike data one; set notexist; run; %let ee=&syserr; %macro diablo3(monk); data a(%if &monk=1 %then %do; replace=no %end; %else %do; replace=yes %end); set one; run; %mend diablo3; %diablo3(monk=&ee); ... View more

Maybe I am misunderstanding you, but the usual meanings of the terms batch and interactive are unrelated to what program code you have. Batch jobs are when you execute some SAS code from an operating system command. In a batch job, you wouldn't see the usual SAS windows. Interactive means that you have launched the SAS application, you have some SAS code in the program editor (or enhanced editor), and you submit the code via F3 or the submit icon. ... View more

"an error happened how we can stop running the rest program immediately " Check some system options such as abend ... "and have the error information recorded in a macro variable for the future reference?" The &SYSERRORTEXT automatic macro variable contains the text of the last error message formatted for display on the SAS log. Ksharp ... View more

However, if the OP is using the BI Platform, then the %WINDOW statement will not be available for several reasons: 1) the %WINDOW statement will not work in Enterprise Guide or any of the client applications in the BI Platform (since all stored processes and task/wizard code are essentially submitted in batch mode) 2) using webAF (the BI web services java beans) and Eclipse is the way to create interactive applications using the BI Platform. On the other hand, if the OP is using the BI Platorm, then the prompting interface is built to allow for user input -- not so much between steps in a stored process -- but to collect input from the end user in order to have flexible programs. cynthia ... View more

Or, you can simply do something like: log "color warning green reverse" continue; log "color error red reverse" continue; ... View more

%put %str(This is  Tom%'s car) ; This is Tom's car Ksharp ... View more

Has to do with name literals and telling SAS how to read a name with spaces in it. If you want to see what you should call the sheet I usually run access my excel workbook via a libname statement, ie libname myxlfile excel 'C:\abc.xls'; Check the abc library in the explorer now and you can see how to reference your worksheets. ... View more

Never noticed that before, but tried it It submits the program when you open it. ... View more

Hi, I followed the direction to create a favorite folder and my folder did not disappear after I re- open SAS: Using Search Folders and Favorites Folders Search folders (new with SAS 9.3) are represented by the following icon: . The Search tab in SAS Management Console, which is also new with SAS 9.3, enables users to search for metadata objects based on object names, locations, descriptions, object types, creation or modification dates, keywords, and responsibilities. After performing a search, click the Save button on the Search tab to specify a folder and location in which to store the search criteria. Opening a search folder causes the search to be rerun and updated search results to appear. Favorites folders (new with SAS 9.3) are represented by the following icon: . Favorites folders enable users to store references to often-used metadata objects. To create a Favorites folder, right-click a folder in the SAS Folders tree (for example, your personal folder), select New Favorites Folder, and specify a folder name. Users can further organize favorites by selecting New Favorites Group when a Favorites folder is selected. To store a favorite, right-click the Favorites folder (or Favorites group), select Add Favorite, and navigate to the object that you want to reference. | ... View more

Does your table name contain some special character , such as white blank $ # ? And use libname option reserve_table_names=yes can update and display it. Ksharp ... View more

http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001355231.htm ... View more

Hi, I think generation data sets could be helfpul to you (GENMAX= option). See e.g.: http://www.nesug.org/Proceedings/nesug11/cc/cc05.pdf --Q. ... View more

Like: OPTIONS NOSYMBOLGEN NOMPRINT  NOMLOGIC ; ... View more

Of course.Don't forget to set it back OPTIONS OBS=MAX ; ... View more