DATA Step, Macro, Functions and more

No results in Sorting

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

No results in Sorting

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;


1.png

Accepted Solutions
Solution
‎02-23-2017 06:48 PM
Super User
Posts: 19,855

Re: No results in Sorting

Posted in reply to ayushupadhyay22

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

View solution in original post


All Replies
Solution
‎02-23-2017 06:48 PM
Super User
Posts: 19,855

Re: No results in Sorting

Posted in reply to ayushupadhyay22

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

PROC Star
Posts: 7,487

Re: No results in Sorting

Posted in reply to ayushupadhyay22

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

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 114 views
  • 0 likes
  • 3 in conversation