I am using SAS 9.4   Hello all,   I have a data set that is similar to this:   ID Med Opioid NSAID Diuretic Steroids 1 A 1 0 0 0 1 B 1 0 0 0 1 C 0 1 0 0 1 D 0 0 1 0 1 E 0 0 0 1 2 D 0 0 1 0 2 C 0 1 0 0 3 A 1 0 0 0 3 I 0 1 0 0 3 J 0 0 0 1 3 D 0 0 1 0 4 A 1 0 0 0 4 B 1 0 0 0 4 N 0 0 1 0   and I would like to transform the data set into something that looks like this:   ID Opioid NSAID Diuretic Steroids 1 1 1 1 1 2 0 1 1 0 3 1 1 1 1 4 1 0 1 0   How would I go about doing this?  Thank you in advance!   ... View more

  Hello Everyone,   I have a data set called metabolic and I would like to calculate the median value of a specific variable sysbp. I would then like to create a new variable in metabolic called median, and give all observations the same median value calculated in med data set.  From this I want to calculate the absolute difference between sysbp and median.  I need to automate this as I will eventually need to create a marco.   This is the code that I have been playing with in SAS 9.4:   proc univariate data=metabolic noprint; var sysbp; output out=med mean=mean median=median run;   data new; merge metabolic med(keep=median); diff = abs(sysbp - median); run;   Med data set     mean  median 1 130   134   Metabolic data set     ID  SYSBP 1   11   135 2   12   102 3   13   145 ...    n   nn   101     Wanted: New data set     ID  SYSBP Median 1   11   135    134 2   12   102    134 3   13   145    134 ...    n   nn   101    134     Incorrect data set that I keep getting      ID  SYSBP Median 1   11   135    134 2   12   102    . 3   13   145    . ...    n   nn   101    .   I have also tried this code and it did not give me the right data set either data new; merge metabolic med(keep=median); if first.habcid then median2=median; else median2=first.median; diff = abs(sysbp - median2); run;   I am very rusty with SAS so any help in tweeking the code is greatly appreciated! ... View more

Hello,    I am very new to proc sql and currently trying to concatenate several very large tables.   I used the code:    proc sql; create table inptadm as select * from raw.inptadm2002 union select * from raw.inptadm2003 union select * from raw.inptadm2004 union select * from raw.inptadm2005 union select * from raw.inptadm2006 union select * from raw.inptadm2007 union select * from raw.inptadm2008 union select * from raw.inptadm2009 union select * from raw.inptadm2010 union select * from raw.inptadm2011 union select * from raw.inptadm2012 union select * from raw.inptadm2013 union select * from raw.inptadm2014 ; quit;   and examples of my tables look similar to these below   raw.inptadm2002     var1 var2 var3 var4 a c d u s u d l e g w b         raw.inptadm2003     var1 var2 var3 var4 d g i k w f h k w g r b         …               raw.inptadm2014     var1 var2 var3 var4 e h l u g u r l e w w k   I want a new table like this:    var1 var2 var3 var4 a c d u s u d l e g w b d g i k w f h k w g r b …       e h l u g u r l e w w k   I keep getting this error codes in my log similar to    WARNING: A table has been extended with null columns to perform the UNION set operation. ERROR: Column 13 from the first contributor of UNION is not the same type as its counterpart from the second. ERROR: Column 15 from the first contributor of UNION is not the same type as its counterpart from the second. ERROR: Column 17 from the first contributor of UNION is not the same type as its counterpart from the second.   and I do not know what I am doing wrong.    I ran code similar to this in the past with no issue so I am not sure how to troubleshoot this problem.    ______________________ Also, when I try to list the specific variables that I want in each table using  the following code   proc sql; create table enrl as select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2002 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2003 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2004 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2005 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2006 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2007 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2008 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2009 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2010 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2011 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2012 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2013 union select enrolid, dtstart, dtend, AGE, AGEGRP, DOBYR, ENRMON, MSA, REGION, SEX, state from enroll2014 ; quit;   I also get these error messages:  ERROR: Ambiguous reference, column AGE is in more than one table. ERROR: Ambiguous reference, column AGEGRP is in more than one table. ERROR: Ambiguous reference, column DOBYR is in more than one table. ERROR: Ambiguous reference, column ENRMON is in more than one table. ERROR: Ambiguous reference, column MSA is in more than one table. ERROR: Ambiguous reference, column REGION is in more than one table. ERROR: Ambiguous reference, column SEX is in more than one table. ERROR: Ambiguous reference, column state is in more than one table. ... View more