Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

/* Create test data for the PROC REPORT that will be run in the  */
/* CALL EXECUTE that follows.                                    */

data test;
  input Day :$9. customers;
datalines;
Monday 82 
Tuesday 100
Wednesday 76
Thursday 91
Friday 110
;

/* CALL EXECUTE can be used to generate code that does not execute until  */
/* the next step boundary.  Thus, it can be used to conditionally build   */
/* programming logic.  Care is needed when you pass a quoted string       */
/* containing apostrophes to CALL EXECUTE.                                */
/*                                                                        */
/* In the sample that follows, the argument passed to  CALL EXECUTE  is   */
/* surrounded by single quotes.  Without additional logic, the apostrophe */
/* in the label being created on the DEFINE statement will be interpreted */
/* as a closing single quote.                                             */ 
/*                                                                        */
/* To generate the PROC REPORT as desired                                 */
/*                                                                        */
/*  proc report data=test nowd;                                           */
/*    define customers / display "Joe's Cafe";                            */
/*  run;                                                                  */
/*                                                                        */
/* build the CALL EXECUTE parameter in multiple quoted strings.           */
 
data _null_;
  if _n_=1 then do;
    call execute( 'proc report data=test nowd; define customers / display ' 
                  || ' " ' || "Joe'"|| 's Cafe" ' || '; run; ' );
  end;
stop;
run;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

                Joe's
  Day             Cafe
  Monday            82
  Tuesday          100
  Wednesday         76
  Thursday          91
  Friday           110

Operating System and Release Information