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: 
nravi
‎09-01-2015
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Strange behavior when double-ampersand macro variable needs a mult...

by Calcite | Level 5 in SAS Programming
‎09-27-2014 02:13 AM
‎09-27-2014 02:13 AM
1 When the macro has four dots, the order of resolution is: 2 &&_uniqDbTable&_n....clnt_nr 3 &_uniqDbTable1...clnt_nr (break down: two && to one & and 4 dots to 3 dots) 4 V_HM_CE_CUST_ATTR ..clnt_nr (break down: one & is dropped and 1 dot is dropped) - so result is two dots 5 When the macro has 3 dots, the order of resolution is: 6 &&_uniqDbTable&_n...clnt_nr 7 &_uniqDbTable1..clnt_nr (break down: two && to one & and 3 dots to 2 dots) 8 V_HM_CE_CUST_ATTR.clnt_nr (one & is dropped) -  so result is one dot Note: numbers on 1st position on each line designates line number. Observe that in line 3 when 3 dots are present, there is only one &, but, in line 6 when 3 dots are present, there are two &. Hope, that makes sense. ... View more

Re: date field length need to change from 8 byte to 4 byte.

by Calcite | Level 5 in SAS Programming
‎09-27-2014 01:30 AM
‎09-27-2014 01:30 AM
let's say you have data sets a (length of date_old=8) and b (length of date_old=4), data new (drop=date_old    rename=(date_new=date_old)); length date_new 4.; set a; date_new=date_old; run; data all; set new b; run; Keep posted to let us know, if it worked.. ... View more

Re: Problem to convert character to numeric

by Calcite | Level 5 in SAS Programming
‎09-27-2014 01:15 AM
‎09-27-2014 01:15 AM
Try this.. data a; input x $20.; datalines; 63,4 M€ 14 866 M€ ; run; data b; set a; y=input(compress(x,'123456789','k'),8.); run; ... View more

Re: Why doesnt decremental macro loop work?

by Calcite | Level 5 in SAS Programming
‎09-27-2014 12:59 AM
‎09-27-2014 12:59 AM
That worked. Thank you ... View more

Why doesnt decremental macro loop work?

by Calcite | Level 5 in SAS Programming
‎09-27-2014 12:11 AM
‎09-27-2014 12:11 AM
Hi, I am writing a %do loop with decreasing iterative value. But this doesn't work. Can anyone help? %macro loop; %do i=3 %to 1 by -1; data b_&i.; set a&i.; run; %end; %mend; %loop; ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 1 by -1 ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro LOOP will stop executing. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links