I have a scenario as follows:   data have; input id var1 var2; datalines; 1  .  5 2  3  4 3  4  5 5  0  6 6  9  8 ; run;   %let nvar = 2; %let v1 = 5; /*Condition for var1*/ %let v2 = 8; /*Condition for var2*/ When i run this array , i am getting error. data want; set have; array var{2} var1 : var&nvar; array flag{2} flag1-flag&nvar; do i = 1 to 2; if var{i} >= 5 then flag{i} = 1; else flag{i} = 0; end; drop i; run; This above code run correct but what i need is that instead of var{i} >= 5  i have to replace by var{i} >= &v{i} so i make  the condition to change as i changes. However this modification does not work ,saying it can not resolve &v{i}. Any suggestion ? Thank you. ... View more

Hello, I need to create a series of macro variables to assign each year between two given years. For instance, without using any loop I have to assign them one by one: %let yr1= 2020; %let yr2= 2021; %let yr3= 2022; However, this is not very efficient , if range becomes wider. My idea is : %let start = 2010; %let end =  2012;   ............................. .............................   Thank you.     ... View more

Hi, I have dataset as follows: data have; input x $3. y $4.; datalines; yes no - yes yes ; run;  Using  survey freq procedure,(proc surveyfreq) i am able to take the distribution of each variable. Missing category , is represented as space. Is anyway i can replace that space with the word "Missing" , to have something as follwos:      Table of x Missing(not just space)   1 .... no                                           1 ... yes                                         2 Total                                      4  Thank you .   ... View more

Hello, i have a dataset as follows: data have; length number $ 54; input number $; datalines; 44991.65 run; This number which is coming as character in SAS, represents in excel  3/6/23 3:29 PM So the question is, how to extract only the date part from this number? ... View more