Snipplr

(Other) insert page breaks in oocalc spreadsheet - thefamousnomo

Thu, 17 Jan 2013 20:56:51 GMT

page break inserted when first letter of first cell in row changes

(SAS) Default Macro Values - webonomic

Sat, 13 Oct 2012 00:28:05 GMT

Quite often it is necessary to set a default value for a macro parameter that is passed to a program. If the program is a macro, the %IF statement can be used to check if the value is provided and provide a default value if not. Since %IF statements are not allowed outside of macros, that technique won't work for a non-macro program (e.g., a file/program that is %INCLUDEd). The following code snippet demonstrates the use of the COALESCEC function to assign a default value. since macro is a text manipulation facility, the coalesceC function is used regardless of whether the expected value for the parameter is numeric (i.e., everything in macro is interpretted as a character string).

(Objective C) Macro to use HEX color - Gretzki

Wed, 16 May 2012 20:54:41 GMT

OBJC macro to use HEX color values to init UIColor objects

(VB.NET) Use OLEDB To Read An Excel File - brettville

Mon, 20 Dec 2010 17:00:53 GMT

Doesn't do any validation, you would want to check if a

(Lua) Quick Target - ad5qa

Fri, 17 Dec 2010 02:25:29 GMT

Thi sis a test of comments...

(SAS) Macro to create an ordering (for PROC REPORT) - sandman7OR

Wed, 27 Oct 2010 09:07:56 GMT

(VB.NET) PowerPoint Timer - wesalvaro

Thu, 05 Aug 2010 06:39:16 GMT

Select a shape with text of any kind inside. Run the macro. A timer is generated. Change the macro to switch counter resolution, length, up/down, etc. Modified original to make it work in PPT 2007.

(Emacs Lisp) kmacro-call-macro without the message for the repeat key - bigfaceworm

Fri, 28 May 2010 10:54:25 GMT

From Emacs 23.1, an edited version of kmacro-call-macro that removes the call to message reminding the user that they can repeat the macro with a single key.

(SAS) How to create a macro variable containing a list of variables in a DATA set - sarathannapareddy

Mon, 26 Apr 2010 19:49:45 GMT

Sometimes it is very handy to have a macro variable contanining the variables names of the dataset. Here are the 2 different ways you can create a macro variable with list of variables names ...

(Lua) Blood spec rotation macro - tseven

Sat, 24 Apr 2010 15:24:57 GMT

(Scheme) Change list in place : scheme/impromtu - magicrebirth

Thu, 04 Feb 2010 06:27:51 GMT

set-car! and set-cdr! change a list 'in-place'. But, if you like the pointer metaphore... you could use macro's instead of procedures... stupidly simple example...

(SAS) SAS Macro to get the number of observations in a dataset... - sastechies

Tue, 26 Jan 2010 14:31:32 GMT

(SAS) SAS Macro to create a delimited text /csv file from a SAS data set.. - sastechies

Tue, 26 Jan 2010 14:27:27 GMT

(SAS) SAS Macro to Cleanup your WORK directory - sastechies

Tue, 26 Jan 2010 14:22:04 GMT

(Visual Basic) Remove Hyperlinks from Excel document - a1ias

Tue, 26 Jan 2010 02:12:52 GMT

(SAS) SAS Macro to add a prefix to some or all variables in a data set... - sastechies

Fri, 11 Dec 2009 12:09:27 GMT

Often we need to add a prefix to some or all variables in a dataset before we might have to merge datasets that have similar column attributes...This macro would allow you to do that.... Try it for yourself....

(SAS) find the nth business day of a given month and year in SAS - sastechies

Fri, 11 Dec 2009 11:54:12 GMT

(Visual Basic) Find duplicate cells in excel column - a1ias

Tue, 24 Nov 2009 09:46:27 GMT

(Objective C) Detailed NSLog() via a Preprocessor Macro - zingo

Tue, 20 Oct 2009 22:51:49 GMT

Ever needed to see more context surrounding your NSLog statement to help you debug in the console?

(SAS) Macro IN Operator - sarathannapareddy

Sun, 16 Aug 2009 14:52:53 GMT

Have you ever come across a situation where you have to write a macro program where a macro variable has more than one value? Writing a macro program in this case involves so many different conditions and to connect each condition you generally use OR operator as below… %macro test; %if &dsn=ae or %if &dsn=ds or %if &dsn=co or %if &dsn=cm %then %do; Some---SAS—Statements; %end; %test;