topic Footnote Display in SAS Programming

Footnote Display

Nasya — Tue, 14 Aug 2018 18:28:22 GMT

Hi,

I am trying to write a code where the output has to displayed as per the footnotes which are given below.

(1) I = age >=55; II = non-smoking, no CAD;

(2) 1 = age>55,no CAD; 2= no death;

ID is the unique variable.

SLCT and SLCT1 are Char variables which are converted to Numeric.

Any help in suggesting where the code has to corrected is appreciated.

Thank you.

data step_01;
     set incl;
     by ID;
attrib SLCT_  SLCT1_length= 5;

/*Footnote (1)*/

      if SLCT= 'age>=55' then SLCT_=I;
      else if SLCT='non-smoking,no CAD' then SLCT_=II;
      
/*Footnote (2)*/

       if SLCT1= 'age>55,no CAD' then SLCT1_= 1;
       else if SLCT1='no death' then SLCT1_=2;
run;

Regards,

Nasya

Re: Footnote Display

ballardw — Tue, 14 Aug 2018 19:31:48 GMT

You are creating variables but I am not sure of the connection to "footnotes". In SAS Footnote usually refers to a Footnote statement which places text after the output of a procedure such as:

Title "This is a title to place at the top of output";
Footnote "Only 5 observations were selected for printing";
proc print data=sashelp.class (obs=5);
run;
/* turn off title and footnote*/
title; footnote;

Since you do not show how you are creating any output other than a data set you will need to provide more example of what you want.

This statement assigns the value of the variable I to SLCT_. Is that the desired action?

if SLCT= 'age>=55' then SLCT_=I;

Re: Footnote Display

Nasya — Thu, 16 Aug 2018 14:19:58 GMT

Hi ballardw,
Thank you for your response. I am not sure if that is a desired action, but I was trying to see if that will help me display the output as desired.

Below is how the dataset appears:

ID Case1 Case2
001 age >=55 age>55,no CAD
002 age >=55 no death
003 non-smoking, no CAD no death
004 non-smoking, no CAD age>55,no CAD

ID(Variable is ID)- Character
Case1(Variable is SLCT)- Character
Case2(Variable is SLCT1)- Character

Output Desired:
Foot notes:(1) I = age >=55; II = non-smoking, no CAD;(2) 1 = age>55,no CAD; 2= no death;

ID Case1 Case2
001 I 1
002 I 2
003 II 2
004 II 1

Will this information help you to understand what is expected? I appreciate your help.

Thank you,

Regards,
Nasya