For example, the unsorted data set looks like:   x            z 21         AL 22         ZA 9           BC 19         AL 21         BC 23         AL 9           ZA 11         BC     I did    proc sort data=data out=sorted ; by z x; run;     and tried this too proc sort data=data out=sorted ; by z; run; But what I got looks like:   x            z 19         AL 23         AL 9           BC 11         BC 9           ZA 22         ZA 21         AL 21         BC     Why is the bottom two lines not sorted properly? Help!   ... View more

I want the macro to have one parameter which is the path of the text files.   This is what I have now. I have 6 txt with name= NY2012.txt   NY2013.txt   NY2014.txt.....etc.      %macro data ; %let list= 2012 2013 2014 2015 2016 2017; data allData; delete;  (what should I put here?) run; %do i=1 %to 6; %let currItem = %scan(&list, &i); filename f&list "/folders/myfolders/NY&list.txt"; (should this be here?) data currentData; x = &currItem; infile f&list  truncover; input value $ 1-20; retain year; if _n_=1 then year=year_1; run; * Keeping adding things to the cumulative data set; data allData; set allData currentData; run; %end; %mend data; %data;   Then I should end up with a dataset for each year and one large dataset that included all the years. How should I fix this? Thank you. ... View more