If you want the summary output as a data set, you will also want to look into the Proc MEANS option STACKODSOUTPUT. You are summarizing data in different data sets (tbl=Y_TTT*|L_TTT*) you will need, at a minimum, one use of Proc MEANS per table. If the variables being summarized in the separate table are exclusive to a table, you probably want to stick to one MEANS per table. However, when producing output data for a wide audience, you would be well served to have the source data set name in the summary results. If the data set structures are similar enough in 'identity of measure (i.e. customer id and region)' and the measure are in different data sets, perhaps due to policy of splitting data by year or month, you can stack the data sets and use one Proc MEANS on the stack.  If you are stacking data sets it is good practice to incorporate the source data set name in the summary results if you need that temporality as a categorical variable.  The stacking can be a delivered through a view. With the proper hardware 2m x 100 summarization will happen quickly.   ... View more

ODS EXCEL has an option to put each BY group into a different worksheet.   ods excel file='myexcel.xlsx' options(sheet_interval='BYGROUP'); proc report data=xxx; by variablename; ... run; ... View more

Counting columns is skill and seems to be disappearing.   @Ronein wrote: Hello I want to ask about percent format. The format  PCT1 show .0574%  but I want it to show  0.0574% The format PCT2 show (.0574%)  but I want it to show (0.0574%) Data have; x1=1276; x2=-1276; total=2222151; pct1=x1/total; pct2=x2/total; format pct1 pct2 percent8.5; Run;  (0.0574%) is 9 characters. So does not fit well into any format defined to have a width of 8, i.e. the 8 in percent8.5. The Decimals of 5 the 5 in percent8.5 exceeds the number of decimals you actually want to show which is 4, 0574. The % symbol is not a decimal in the display. So using any .5 for the decimals may be problematic as to resulting appearances. Run this and see the results in the log: data _null_; x=-0.000574; put 'Format is percent8.5' x= percent8.5; put 'Format is percent9.5' x= percent9.5; put 'Format is percent9.4' x= percent9.4; run; See what happens with percent9.5? Forcing the extra decimal which is what the .5 does means that you get either and unwanted 0 or other value from rounding your calculated value as the fifth decimal.   ... View more

The ? and ?? modifiers suppress error messages.   32 is the maximum number of characters that the normal numeric informat can handle.   But if you don't specify the width to use for an informat then SAS will default to 12.  So your two statements are not equivalent as the first one reads the first 32 bytes of the character variable and the second only the first 12.   Note that BEST is the name of a FORMAT that tries to find the best way to represent a number in a fixed number of characters.  There is no equivalent meaning of the best way to represent a number as a number so using BEST as the name of an informat is just confusing.  If you do use it that way then SAS will just take at as an alias for the normal numeric informat, the one you used in your first statement.    You could try checking if the string only contains digits.  Or perhaps digits and period.  Or perhaps also include hyphen and plus sign.  But that would yield false positives for values with multiple periods. And it would yield false negatives for values in scientific notation. Note that the BEST format will generate strings in scientific notation when it has to.   One thing you might want to consider is using the COMMA (or perhaps COMMAX) informat instead or the normal numeric informat.  That will accept strings with commas in them (and also dollar signs). ... View more

Here is a similar post to what you are asking: https://communities.sas.com/t5/SAS-Programming/Ods-excel-right-to-left/td-p/877128   ... View more

You will need code similar to the following: filename mymail email from="Ron.Dave@gmail.com" TO=("Ron.Dave@gmail.com") subject="Update" type='text/html'; data _null_; file mymail; put '<html><body>'; put '<p>Hello</p>'; put '<p><font color="blue">Here is my report</font></p>'; put '</body></html>'; put '</html>'; run; ... View more

Hello, This code work well DATA CLASS(drop=sex rename=(_sex=sex)); SET sashelp.class; IF SEX='F' THEN _SEX='(a1) F'; else _Sex='(a2) M'; Run; ods output onewayfreqs=freq_tbl1; proc freq data=CLASS ; tables _all_ /**Name Age Height Weight Sex**//nocum ; run; ods output close; *technically unneeded but makes it more clear; data freq_tbl2(KEEP=var_name value Frequency Percent); retain var_name value Frequency Percent; set freq_tbl1; value = left(coalescec(of f_:)); var_name=scan(table,2); /**Take second word from field table**/ run; ... View more

Without VAR statement PROC TRANSPOSE only transposes the NUMERIC variables.   Note that there are special variable list keywords you can use to list all of the character or numeric variables. proc transpose data=cars name=Var_name out=char_vars(drop=_label_ rename=(COL1=char_value)) ; by seq; var _character_ ; run; proc transpose data=cars name=Var_name out=num_vars(drop=_label_ rename=(COL1=num_value) where=(upcase(var_name) ne 'SEQ') ) ; by seq; var _numeric_; run; ... View more

Your single dataset update step may look similar to this: In this example the step took a real time of 0.01 seconds. Set FILELOCKWAIT to a value in seconds greater than the real time of your update step.    ... View more

To prevent the macro from executing while call execute is trying to stack up the code to run later make sure to add %nrstr() macro quoting. call execute(catt('%nrstr(%RRR)(Var=',field,',Format=',fmt,')')); ... View more

You do not need a macro definition, BTW. A simple %IF %THEN %DO %END has been possible in "open code" for quite some time now. ... View more

Thank you ... View more

You're right, it's not the log, it's the results.   @Ronein use ODS statements to turn off all output first, then open a single destination to a file. ... View more

Here is another possible way to do this: data have; input tbl $ field $; cards; tbl1 x tbl1 y tbl1 z tbl2 w tbl2 x tbl2 v tbl2 y ; run; data have; set have; by tbl; if first.tbl then flag=0; flag+1; run; proc sort data=have; by flag tbl; run; proc transpose data=have out=want(drop=flag _name_); by flag; id tbl; var field; run; proc print data=want; run; ... View more