There are 2 variables A and B, and I create variable C using + operator, variable D using sum function and E using sum statement. What will be result? I know the difference between "+" and SUM function. "+": If there are any missing values it returns missing result. SUM function: It doesn't consider missing values and averages the remaining data. Some information about SUM statement is, it has default functionality as RETAIN statement.  I want to know how it is working. Can any one give me a scenario? Thankyou! ... View more

For example, a variable LABCAT has values like "Hematology", "Chemical", "Urinalysis".....    and variable lab parameter PARAM has values like "WBC", "RBC", "BASOPHILS", ...so on like 100. I have 100 values for PARAM.  Example Look-up Table: PARAMN       PARAM                   PARAMCD            ATYPE            LBCAT               LBTESTCD 1                Potassium)mmol/L)     K                           num             CHEMISTRY          K 2                Albumin(g/L)                ALB                      num             CHEMISTRY          ALB 3                Creatinine(umol/L)       CREAT                 num             CHEMISTRY          CREAT 4                Basophils(10^9L)         BASO                   num             HEMATOLOGY      BASO 5                Prothrobin Time           PT                         num             HEMATOLOGY      PT 6                Color                            COLOR                 char             URINALYSIS          COLOR 7                pH                                PH                         char             URINALYSIS          PH ......... . . .   How do I create macro  where it directly takes the PARAM values for 100 different values automatically and creates the output table. In simple, I want to create a macro in such a way that I want to call that macro and I should get all the 100 outputs/ reports/ tables. For your reference I am also attaching a mock table output that I want for 100 tables.   Please let me know if you need any additional information.     ... View more

I was trying to create a SDTM Domain using macros. I wanted to give a permanent path to store. I use %let path = "Locaton of the path"; and then %include "&path\Location of the path"; and i get an error  7 option mprint mlogic symbolgen source source2; 8 %let path = C:\Users\jasti\OneDrive\Desktop\Sdtm\DS; 9 %include "&path/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas"; SYMBOLGEN: Macro variable PATH resolves to C:\Users\jasti\OneDrive\Desktop\Sdtm\DS WARNING: Physical file does not exist, C:\Users\jasti\OneDrive\Desktop\Sdtm\DS\C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas. ERROR: Cannot open %INCLUDE file C:\Users\jasti\OneDrive\Desktop\Sdtm\DS/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas.   I just started learning  macros. I know i am doing dumb wrong here. Can anyone help me where am going wrong in giving the path ?  option mprint mlogic symbolgen source source2; %let path = C:\Users\jasti\OneDrive\Desktop\Sdtm\DS; %include "&path/C:\Users\jasti\OneDrive\Desktop\Sdtm\DS.sas"; This was the only code i started with and got error.      ... View more