cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cbob
‎09-01-2015
  • 8 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

using excel dde in macro

by Calcite | Level 5 in SAS Programming
‎03-09-2012 08:31 AM
‎03-09-2012 08:31 AM
"put" worked..Thank you!! ... View more

using excel dde in macro

by Calcite | Level 5 in SAS Programming
‎03-08-2012 09:48 PM
‎03-08-2012 09:48 PM
Hi All, I have this below code which works fine. Option noxwait nosync symbolgen; x  "C:\Progra~1\Micros~2\office12\excel.exe"; Data _null_; rc=sleep(5); Run; Filename command dde "excel|system"; /* yyyy_mm format */ %let yyyy_mm = %sysfunc(TODAY(),YEAR4.)_%sysfunc(TODAY(),MMDDYY2..) /* File name is C:\Common 2012_03.xls */ %Let namexls = %Str(%'[open("C:\Common &yyyy_mm..xls")]%'); Data _null_; File command; put %Unquote(&namexls); Run; Data _null_; File command; put '[quit()]'; Run; The above code opens an excel file and writes the data w/o any issues. Now, i have 3 excel files(Jan12-Mar12) to read so i thought of wrapping the above code inside a macro.. /* Extract date in yymm format */ %Let yymm  = %sysfunc(putn(%sysfunc(intnx(month,%sysfunc(today()),-0,end)),yymmn4.)); %Let yymm1L  = %sysfunc(putn(%sysfunc(intnx(month,%sysfunc(today()),-1,end)),yymmn4.)); %Let yymm2L  = %sysfunc(putn(%sysfunc(intnx(month,%sysfunc(today()),-2,end)),yymmn4.)); Option noxwait nosync symbolgen; %Macro loop(yymm); x  "C:\Progra~1\Micros~2\office12\excel.exe"; Data _null_; rc=sleep(5); Run; Filename command dde "excel|system"; /* yyyy_mm format */ %let yyyy_mm = %sysfunc(year(%sysfunc(inputn(&yymm.,yymmn4.))))_%substr(&yymm,3.2); %Let namexls = %Str(%'[open("C:\Common &yyyy_mm..xls")]%'); Data _null_; File command; put %Unquote(&namexls); Run; Data _null_; File command; put '[quit()]'; Run; %Mend; %loop(&yymm) %loop(&yymm1L) %loop(&yymm2L) ; I don't get any error, but it says 0 records were written to file command. I guess I am doing something incorrect in the below data step Data _null_; File command; %put %unquote(&namexls); Run; Any thoughts?? ... View more

Macro Variable

by Calcite | Level 5 in SAS Programming
‎03-08-2012 04:55 PM
‎03-08-2012 04:55 PM
It worked!!!. Thanks Karl.. ... View more

Macro Variable

by Calcite | Level 5 in SAS Programming
‎03-08-2012 04:34 PM
‎03-08-2012 04:34 PM
Hi, I have the below macro variable which outputs 1202. %Let yymm = %sysfunc(putn(%sysfunc(intnx(month,%sysfunc(today()),-1,end)),yymmn4.)); Now I want to use the above macro variable(&yymm.) and  output ONLY the year in YYYY format(2012). %Let yyyy = %sysfunc(year(&yymm.)); I tried the above step and it is giving me 1963 as output. Can someone take a look? Thanks in advance!. ... View more

Re: ERROR: A Character operand was found in the %Eval function

by Calcite | Level 5 in SAS Programming
‎03-04-2011 06:41 PM
1 Like
‎03-04-2011 06:41 PM
1 Like
> Works fine: > > > 84 > 85 > 86 %let a = 0.967; > 87 %let b = 0.942; > 88 %let diff = %sysevalf(&a. - &b.); > 89 %Put diff = &diff.; > diff = 0.025 > 90 %Macro test; > 91 %if (0.01 LE &diff. LE 0.01) %then %put > &diff.; > 92 %else %put 'Out of Range'; > 93 %Mend; > 94 %test; > 'Out of Range' Thanks for your reply!. It blows up when the diff is negative.Also it is -0.01 in the below lower limit. It works absolutely fine with diff value being positive but if the diff is NEGATIVE it throws error. %if (-0.01 LE &diff. LE 0.01) %then %put Thanks, ... View more

Re: ERROR: A Character operand was found in the %Eval function

by Calcite | Level 5 in SAS Programming
‎03-04-2011 06:33 PM
‎03-04-2011 06:33 PM
Chang, Thanks for your response. I guess what I'm trying to do is to validate whether the difference between the two macro variables a& b is with in the boundary limits(-0.01 to 0.01) or not. %let a = 0.9377; %let b = 0.9570; %let diff = %sysevalf(&a - &b); %Put diff = &diff; %Macro test; %if ((-0.01) LE %sysevalf(&diff.) LE (0.01)) %then %put &diff.; %else %put 'Out of Range'; %Mend; %test; When i run the above code I am getting the below error ERROR: A Character operand was found in the %Eval function or %IF condition where a numeric operand is required. Thanks, Sridhar ... View more

Re: ERROR: A Character operand was found in the %Eval function

by Calcite | Level 5 in SAS Programming
‎03-04-2011 01:08 PM
‎03-04-2011 01:08 PM
> Hello Cbob, > > Your test is not displayed correctly. Please, check. > > Sincerely, > SPR Hello SPR, For some reason my msg didn't get fully displayed. Below is my actual code > %let a = 0.967; > %let b = 0.942; > %let diff = %sysevalf(&a. - &b.); > %Put diff = &diff.; > %Macro test; > %if (0.01 LE &diff. LE 0.01) %then %put &diff.; > %else %put 'Out of Range'; > %Mend; > %test; > > All I want to do is print the condition result in the > log. In this case I > want to print as Out of Range as the value of diff is > beyond the boundary > limits. > > I am getting this error "A character operand was > found in the %EVAL function > or %IF condition where a numeric operand is required. > The condition was: (0. 01 LE &diff. LE 0.01) ... View more

ERROR: A Character operand was found in the %Eval function

by Calcite | Level 5 in SAS Programming
‎03-04-2011 09:10 AM
‎03-04-2011 09:10 AM
Hello, Can anyone help me to solve this error? My Code: %let a = 0.967; %let b = 0.942; %let diff = %sysevalf(&a. - &b.); %Put diff = &diff.; %Macro test; %if (0.01 <= &diff. <= 0.01) %then %put &diff.; %else %put 'Out of Range'; %Mend; %test; All I want to do is print the condition result in the log. In this case I want to print as Out of Range as the value of diff is beyond the boundary limits. I am getting this error "A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: (0. 01 <= &diff. <= 0.01) Thanks, cbob ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes from
View All
Quick links