**FMTLIB**to the PROC FORMAT statement displays a list of all the formats in your catalog, along with descriptions of their values.

libname library 'c:\sas\formats\lib';

proc format library=library fmtlib;

run;

Adding the keyword **FMTLIB **to the PROC FORMAT statement displays a list of all the formats in your catalog, along with descriptions of their values.

libname library 'c:\sas\formats\lib';

proc format library=library fmtlib;

run;

libname library 'c:\sas\formats\lib';

proc format library=library fmtlib;

run;

*** Output grand total of sales into a data set;

Proc means data=videos;

var sales;

output out=summarydat sum(sales)=grandtotal;

*** Combine the grand total with the original data;

data videosummary;

IF _N_=1 THEN SET summarydat;

SET videos;

percent=sales/grandtotal * 100;

Output:

sales grandtotal percent

1930 12880 14.9845

2250 12880 17.4689

...

Proc means data=videos;

var sales;

output out=summarydat sum(sales)=grandtotal;

*** Combine the grand total with the original data;

data videosummary;

IF _N_=1 THEN SET summarydat;

SET videos;

percent=sales/grandtotal * 100;

Output:

sales grandtotal percent

1930 12880 14.9845

2250 12880 17.4689

...

MERROR (default) | NOMERROR

When this option is on, SAS will issue a warning if you invoke a macro that SAS cannot find.

SERROR (default) | NOSERROR

When this option is on, SAS will issue a warning if you use a macro variable that SAS cannot find.

MLOGIC | NOMLOGIC (default)

When this option is on, SAS prints in your log details about the execution of macros.

MPRINT | NOMPRINT (default)

When this options is on, SAS prints in your log the standard SAS code generated by macros.

SYMBOLGEN | NOSYMBOLGEN (default)

When this options is on, SAS prints in your log the values of macro values.

When this option is on, SAS will issue a warning if you invoke a macro that SAS cannot find.

SERROR (default) | NOSERROR

When this option is on, SAS will issue a warning if you use a macro variable that SAS cannot find.

MLOGIC | NOMLOGIC (default)

When this option is on, SAS prints in your log details about the execution of macros.

MPRINT | NOMPRINT (default)

When this options is on, SAS prints in your log the standard SAS code generated by macros.

SYMBOLGEN | NOSYMBOLGEN (default)

When this options is on, SAS prints in your log the values of macro values.

ods escapechar='^';

ods listing close;

ods rtf file='c:\tests\test.rtf';

data test;

do i=1 to 50;

output;

end;

run;

proc print data=test noobs;

title 'Page ^{thispage} of ^{lastpage}';

footnote '^{pageof}';

run;

ods listing;

ods rtf close;

ods listing close;

ods rtf file='c:\tests\test.rtf';

data test;

do i=1 to 50;

output;

end;

run;

proc print data=test noobs;

title 'Page ^{thispage} of ^{lastpage}';

footnote '^{pageof}';

run;

ods listing;

ods rtf close;

%EVAL function only supports integer arithmetic values. Macro statements performing integer arithmetic calculations:

%let one=%eval (3+5);

%let two=%eval (5*2);

%let three=%eval (9/3);

%let four=%eval (5/2);

%put The value of one is &one;

%put The value of two is &two;

%put The value of three is &three;

%put The value of four is & four;

Open the Log file and see the results as follows:

The value of one is 8

The value of two is 10

The value of three is 3

The value of four is 2

The value for macro variable four, should be 2.5, instead it shows only two. That happens because if we perform division on integers, integer arithmetic doesn’t take the fractional part into account.

%let last= %eval (5.0+3.0); /*INCORRECT*/

The values here in the above statement have a period character to numeric values and because of that the macro processor stops evaluating and produces the following error message: “ ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 5.0+3.0 “

Evaluating Floating Point Operands

The %SYSEVALF function can perform arithmetic calculations with operands that have the floating point values.

%let test= %sysevalf(1.0*3.0);

%let final= %sysevalf(1.5+2.8);

%let last= %sysevalf(5/3);

%put The value of test is &test;

%put The value of final is &final;

%put The value of last is &last;

The %PUT statements display the following messages in the log:

The value of test is 3

The value of final is 4.3

The value of last is 1.66666666666666

%SYSEVALF function perform arithmetic calculations and the result of the evaluation can be a floating point value like in the final and last macro variable case, but as in integer arithmetic calculations, the result is always a text.

The %SYSEVALF function be used in conjugation with other functions like, INTEGER, CEIL, and FLOOR.

For example, the following %PUT statements return 3, 4 and 3 respectively:

%let val=3.8;

%put %sysevalf(&val,integer); *Value returns in the log is 3;

%put %sysevalf(&val,ceil); *Value returns in the log is 4;

%put %sysevalf(&val,floor); *Value returns in the log is 3;

Difference between %eval and %sysevalf functions can be understand better with the following example;

%let value=9;

%let value2=5;

%let newval=%sysevalf(&value/&value2);

%let newval1=%eval(&value/&value2);

%put &newval;

%put &newval1;

*Ans: newval=1.8;

*Ans: newval1=1;

%let one=%eval (3+5);

%let two=%eval (5*2);

%let three=%eval (9/3);

%let four=%eval (5/2);

%put The value of one is &one;

%put The value of two is &two;

%put The value of three is &three;

%put The value of four is & four;

Open the Log file and see the results as follows:

The value of one is 8

The value of two is 10

The value of three is 3

The value of four is 2

The value for macro variable four, should be 2.5, instead it shows only two. That happens because if we perform division on integers, integer arithmetic doesn’t take the fractional part into account.

%let last= %eval (5.0+3.0); /*INCORRECT*/

The values here in the above statement have a period character to numeric values and because of that the macro processor stops evaluating and produces the following error message: “ ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: 5.0+3.0 “

Evaluating Floating Point Operands

The %SYSEVALF function can perform arithmetic calculations with operands that have the floating point values.

%let test= %sysevalf(1.0*3.0);

%let final= %sysevalf(1.5+2.8);

%let last= %sysevalf(5/3);

%put The value of test is &test;

%put The value of final is &final;

%put The value of last is &last;

The %PUT statements display the following messages in the log:

The value of test is 3

The value of final is 4.3

The value of last is 1.66666666666666

%SYSEVALF function perform arithmetic calculations and the result of the evaluation can be a floating point value like in the final and last macro variable case, but as in integer arithmetic calculations, the result is always a text.

The %SYSEVALF function be used in conjugation with other functions like, INTEGER, CEIL, and FLOOR.

For example, the following %PUT statements return 3, 4 and 3 respectively:

%let val=3.8;

%put %sysevalf(&val,integer); *Value returns in the log is 3;

%put %sysevalf(&val,ceil); *Value returns in the log is 4;

%put %sysevalf(&val,floor); *Value returns in the log is 3;

Difference between %eval and %sysevalf functions can be understand better with the following example;

%let value=9;

%let value2=5;

%let newval=%sysevalf(&value/&value2);

%let newval1=%eval(&value/&value2);

%put &newval;

%put &newval1;

*Ans: newval=1.8;

*Ans: newval1=1;

Using YRDIF function:

“act/act” will gives us the actual interval between the two dates.

To know the interval between two dates in Years:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

years=yrdif(sdate,edate,'act/act');

put years;

run;

Output: 10.2535 yrs

Using DATDIF function:

To know the interval between two dates in Days:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

days=datdif(sdate,edate,'act/act');

put days;

run;

output: 3745 days

Using the INTCK function:

The INTCK function returns the integer count of the number of intervals in years, months or days between two dates.

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

years=intck(‘year’,sdate,edate);

put years;

run;

output:10 years

To know the interval between 2 dates in days:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

days=intck(‘days’,sdate,edate);

put days;

run;

result: 3745 days

To know the interval between 2 dates in months:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

months=intck(‘months,sdate,edate);

put months;

run;

result: 123 months

“act/act” will gives us the actual interval between the two dates.

To know the interval between two dates in Years:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

years=yrdif(sdate,edate,'act/act');

put years;

run;

Output: 10.2535 yrs

Using DATDIF function:

To know the interval between two dates in Days:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

days=datdif(sdate,edate,'act/act');

put days;

run;

output: 3745 days

Using the INTCK function:

The INTCK function returns the integer count of the number of intervals in years, months or days between two dates.

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

years=intck(‘year’,sdate,edate);

put years;

run;

output:10 years

To know the interval between 2 dates in days:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

days=intck(‘days’,sdate,edate);

put days;

run;

result: 3745 days

To know the interval between 2 dates in months:

data _null_;

sdate="12mar1998"d;

edate="12jun2008"d;

months=intck(‘months,sdate,edate);

put months;

run;

result: 123 months

Subscribe to:
Posts (Atom)