No results in Sorting

[ayushupadhyay22]

I am trying to sort a file and copy the sorted contents to another file. After running the file the Address column has no observation. The log also shows no error. I have copied my code below. 

libname orion "/folders/myfolders/project";
proc sort data= orion.fullerton_edited out=orion.fullerton_edited1;
by Address;
run;

[Reeza · Accepted solution]

Missing is sorted to the first observation. Check further records in your data. 

[art297]

Look at the original file, see if there is a field called 'address' and whether that field has any data in it. All of the address fields you showed in your pdf were called site_address_whatever.

Art, CEO, AnalystFinder.com