What is the effect of the above error/warning as far as the rest of the data is concerned once this error is encountered?  Does SAS stop processing the rest of the data or does it continue to process?  I won't be concerned if it continues to process the rest of the data.  Returning null is fine.   Thank you! ... View more

hello,   below is a simplified version of my code.  what's wrong with it and how can I correct it?     %macro test(mydate); %put 1 &mydate.; proc sql; select * from xx where datepart(startdate) = &mydate.; *&mydate evaluates to '31AUG2018'd ; quit; /* calculate 1 year prior */ %let mydate = %sysfunc(intnx(year,&mydate,-1,same), date9.); %put 2 &mydate.; proc sql; select * from xx where datepart(startdate) = &mydate.; *&mydate evaluates to 31AUG2017 and doesn't work; quit; %mend test; %test('31AUG2018'd); ... View more

Hello,   Could someone help me with converting a date to yyyymm (numeric)?  Here's how I would like to use my code:   %let xdate = '01NOV2018'd; %let yymm = <code here to return 201811 as numeric>;   proc sql; select * from xx where timeframe = &yymm; quit;   Thanks. ... View more

Hello,   I have 10 variables in my dataset that are character.  9 of them should be numeric.  Is there a solution using array that would convert the 9 to numeric? like:   array xx _character_; do over xx;      <if variable is not what I want, leave it alone, else convert to numeric>; end;   Thanks! ... View more

Hello,   I have the following records from a proc import (excel): Variable Type Len Format Informat Value var1 Char 17 $17.00 $17.00 2106742.5 var2 Char 18 $18.00 $18.00 670637.14     then i run the following code: data y; set x; var3=input(var1, 8.); var4=input(var2, 8.); drop var1 var2; ; run;   the results however loses decimal numbers.  When I use proc compare they are not equal. Variable Type Len Format Informat Value Var3 Num 8     2106742 Var4 Num 8     670637.1   please help. ... View more

I want to use arrays but confused on how to create and use it.  While reading about arrays, I came across this explanation:   array newvars [3] test1-test3 (45 23 21); newvars[3] will return 21   while I get that newvars[3] returns 21, what I don't get is test1-test3. what are they for? it's not even needed since I can get the value from the array by referencing it, e.g. newvars[2].   more importantly, I am working on this logic:   I want to create an array of strings and use that array inside a do loop.  please help me create the array.  Here's my initial stab at it:   array oldarray[4] ('word1' 'two words' 'more words' 'still more words');   /* i don't need variables */ do i = 1 to 4;         *use oldarray[i] here to manipulate a variable; end;   please help.  I only need how to create the array. ... View more