How to RUN in SAS/PC Batch mode?! how to save the LOG into a file? ... View more

this should be solution ... View more

I cannot turn on LOG since it quickly fills up and prompts. Try to turn on, and save LOG into file, not know how to  do that(it says error msg).   Using sleep() to debug, but too painful ... View more

Yes, it is the way to build up Macros. The thing is when you indeed do that, RUN and no ERROR surely.  BUT later change needed, and ERROR somewhere.  ... View more

The issue is that I do not know where the ERROR is happening(I turned off LOG, a must otherwise prompt).   Anything in SAS has breakpoint like C/C++?! ... View more

Thanks a lot! ... View more

Start with the dataset below data _temp; input tick $; datalines; 12 1234 654321 ; run;quit; ... View more

Thanks a lot still.  To CSum by var in a dataset, here are many ways to do so. The easiest one is the one with IML, which I do not use. I bet your way surely works also.    I am sticky with converting string-token line  into rows in a dataset, because that is a way I know how to systematically generate code line for variables. The variable names are fluid, not just var1/var2/var3/... and not just CSum   ... View more

Thanks a huge ... View more

The outcome I want is the top half. The issue is the bottom half is not working.    data _temp; input varname $ @@; datalines; var1 var2 var3 var4 var5 var6 ; run;quit; _______________________________________________ %let varlist=var1 var2 var3 var4 var5 var6 ; data _temp2; input varname $ @@; datalines; &varlist. ; run;quit; ... View more

Thanks a huge. Sorry I never touch IML before. ... View more

Thanks. But the code is not runable.   What I want is that turn the string line into a dataset, which has one string in one row.   %let varlist=var1 var2 var3 var4 var5 var6 ; ... View more