I was wondering if someone could help me with a simple but yet complex task that's driving me nuts. Thanks. My data set in excel dog cat mice camel pigeon cow goat fish horse donkey monkey lion rat 9 7 0.25 2534 0.57 2243 18 4 3456 3312 23 1544 0.69 I want to create two variables 'animals' and 'weight' to match each animal in columns with respective weight without modifying the data. Just by using proc import and or proc sort. proc import datafile='E:\Copy of final examination.xls' out=Animals dbms=xls replace;sheet=animals;run;
... View more