Take a look at http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000279245.htm http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000998953.htm#a000998933   ... View more

data have; input var $25.; datalines; ABC00000012365948952321 ABC00000000000948952321 ABC00000000025369214558 ;   data want; set have; new_var=compress(var,'abcdefghijklmnopqrstuvwxyz0'); run;   Regards, Naveen Srinivasan ... View more

Hi, is inputn necessary to read a number which is not a formtted date value/character value? Or am i missing something   %put %sysfunc(putn(21033,date9.));   I am wondering how can a worddate18. informat be used to read 21033 ... View more

Hi, I noticed you have missed out an = sign in a %let statement. %let is a macro assignment statement just like a variable assignment statement in a datastep.  Secondly you can copy paste @ballardw solution   Correction:   %LET date9=01AUG2017;     ... View more

The logic: Since you mentioned two tables, I created two sample tables each containing a variable as you may have noticed var1 in table1 and var2 in table2. Typically, the entire SAS programming revolves around the following major concepts: 1. Bring the record into PDV(memory) area where you process 2. Reset values in PDV by editing, copying or computing any values of any variables. So the new variable var takes the value of var1  3. Before resetting again, make sure to use an explicit output so that you don't miss out on the requirement to have the alternative values 4. reset the value of var again this time with value if var2 5. Use another explicit output statement to get the values written to the dataset.   Important concepts in SAS: 1. Implicit pass/output and return 2. Explicit output overriding implicit output still implicit return 3. Zipping through the dataset in memory with a loop(do until eof) 4. Zipping through by groups in memory with a loop(do until(last.by_variable) 5. Look above and Look ahead. (Lag, retain, merge with firstobs=2 and so on) 6. Look up the entire table, column for multiple values-- easy way hashes 7. Familiarise with functions however i don't emphasise this as I believe the above 6 will lead you look for functions or even create your own   Hope that helps ... View more

That's the reason I reset the values to var instead of var1 and var2 in my example above. var=var1;  output;  var=var2;  output;   This makes sure the output is in single column var  Please run my eample, you will get it ... View more

Hi, The answer has been provided to you with proc means. However, I am just curious to understand what you meant by using a do-loop when the objective seems like to merely summarize. Did you mean a one full pass of the dataset as one implicit loop without a "do statement" or you wanted to experiment Ian's DOW-do until(last.by_variable) ... View more