I would like to use column header as frq_-1 but it gives error for'-' ,Is there any way to use it on column statement in proc report. Thanks you. ... View more

I tried self join but its not working.can anyone tell me how to convert it 1 obs per usubjid   obs usubjid wt wtu temp tempu 1     100      70  kg 2     100                 34       c 3     101      77  kg 4     101                 30       c       ... View more

data have; input @1 subject 3. @4 code $1. @6 result 3. ; datalines; 101 A 120 101 A 130 101 B 129 102 C 45 102 C 124 103 D 222 103 D 234 103 E 123 103 E 123 ; run;   expected ouput i want like this where i am adding new obs for average of each unique subject and code.I tried using first.subject and first.code but its still retaining previous avg value in new subject.Can anyone help how to achieve it. Thanks. subject code result average 101       A     120 101       A     130 101                        125 101       B     129 101                        129 102      C      45 102      C     124 102                        84.5 103      D      222 103      D      234 103                        228 103      E      123 103      E      123 103                        123 ... View more

I am planning to appear sas exam soon.I have doubt as looking some questions on google if its mentioned while writting answer that dont put leading and trailing space what should we do 1]RETAIN AGENUM 2]RETAINAGENUM WHICH OPTION IS CORRECT? ... View more