Now , I wanna achieve the same results but with 2 macro variables table_nm and dt . After I add single quote around macro variables, the issues got resolved and desired file generated sucessfully. Thanks a lot for your sugguestion. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 44.93k OS Memory 5156.00k Timestamp 05/18/2014 12:09:55 PM Page Faults 0 Page Reclaims 21 Page Swaps 0 Voluntary Context Switches 0 2 The SAS System 12:09 Sunday, May 18, 2014 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 39 +/* This is a user defined autoexec file for */ 40 +/* SAS Enterprise Guide users. */ 41 +/* */ 42 +/* Place user defined autoexec options here */ 43 +/* */ 44 + NOTE: %INCLUDE (level 2) ending. NOTE: %INCLUDE (level 1) resuming. NOTE: AUTOEXEC processing completed. 1 2 options symbolgen mlogic mprint; 3 %let table_nm=abc1; 4 %let dt=abc2; 5 6 7 data _null_; 8 call system (" cd /prod/user/home/gyb420/check/bck "); 9 call system (" ksh check.ksh '&table_nm' '&dt' "); SYMBOLGEN: Macro variable TABLE_NM resolves to abc1 SYMBOLGEN: Macro variable DT resolves to abc2 10 %put &table_nm ; SYMBOLGEN: Macro variable TABLE_NM resolves to abc1 11 %put &dt; SYMBOLGEN: Macro variable DT resolves to abc2 12 run; NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 440.03k OS Memory 5668.00k Timestamp 05/18/2014 12:09:55 PM Page Faults 0 Page Reclaims 434 Page Swaps 0 Voluntary Context Switches 33 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 0.27 seconds user cpu time 0.02 seconds system cpu time 0.04 seconds memory 4709.75k OS Memory 5672.00k 3 The SAS System 12:09 Sunday, May 18, 2014 Timestamp 05/18/2014 12:09:55 PM Page Faults 0 Page Reclaims 8536 Page Swaps 0 Voluntary Context Switches 1131 Involuntary Context Switches 25 Block Input Operations 8 Block Output Operations 112
... View more