Help using Base SAS procedures

Where I can find DDE reference help for SAS and excel DDE?

Reply
Regular Contributor
Posts: 222

Where I can find DDE reference help for SAS and excel DDE?


Hello everyone;

whrer I can find the whole list of command help for SAS-Excel DDE ?  such as what 's the meaning of  "put '[error(false)]';?"

I didn't find a detail introduction of all  these commands.

Thanks

Mike

filename cmds dde 'excel|system';

data _null_;

file cmds;

/* Insert an graph */

put '[workbook.insert(2)]';

run;

data _null_;

file cmds;

/* Insert an Excel Macro Sheet */

put '[workbook.insert(3)]';

run;

Super User
Posts: 19,789

Re: Where I can find DDE reference help for SAS and excel DDE?

Posted in reply to Mike_Davis

DDE is basically using really old excel commands that are documented here

http://support.microsoft.com/kb/128185

They're excel 4.0 macro functions and NOT SAS functions.

Regular Contributor
Posts: 222

Re: Where I can find DDE reference help for SAS and excel DDE?

Thank you,I download the macrofun file and found the help for my question:

ERROR(enable_logical, macro_ref)
Enable_logical    is a logical value or number that selects or clears error-checking.

If enable_logical is FALSE or 0, all error-checking is cleared. If error-checking is cleared and an error is encountered while a macro is running, Microsoft Excel ignores it and continues. Error-checking is selected again by an ERROR(TRUE) statement, or when the macro stops running.

WORKBOOK.INSERT(type_num)
WORKBOOK.INSERT?(type_num)
Type_num    specifies the type of sheet to insert.

Type_num Type of sheet

1 Worksheet
2 Chart
3 Excel 4 Macro Sheet
4 Excel 4 International Macro Sheet
5 (Reserved)
6 Microsoft Excel Visual Basic Module
7 Dialog
quoted text Template

If omitted, the type of the active sheet is used.
If the current selection contains one sheet, then only one sheet is inserted. If the selection contains more than one sheet and the active sheet is a worksheet, then an equal number of sheets is inserted to the left of the selected group of sheets.

Also ,I get another question:

Could we use our user defined excel macro in the put [] command? that would be very interesting. I will try this later.

Thanks

Mike

PROC Star
Posts: 7,471

Re: Where I can find DDE reference help for SAS and excel DDE?

Posted in reply to Mike_Davis

The macrofun helpfile, that Fareeza pointed you to, is the official documentation.  You can find a lot of SAS-related insights, though, if you read Koen Vyverman's papers.  You can find them at: Koen Vyverman: SAS Related Papers

Ask a Question
Discussion stats
  • 3 replies
  • 499 views
  • 6 likes
  • 3 in conversation