Hi Community, Well this my code DATA ABC; INFILE DATALINES MISSOVER DSD; INPUT N1 N2 MS1$ MS2$; DATALINES; 10,12,MS, 10,12,MS 10,12, ,MS 10,12,MS, ; RUN; PROC SQL; CREATE TABLE WORK.BBC SELECT N1, N2, ms1, ms2, (CASE WHEN(N1<N2)THEN MS1 OR MS2 END) AS FINAL_MS FROM WORK.ABC; QUIT; IN BBC i want to create a new variable i.e. FINAL_MS in order to receive values from either ms1 or ms2 but it returning me logical value that is 1 as n1<n2. My need is it must receive either value from ms1 or ms2. How to do this ? thanks
... View more