DATA Step, Macro, Functions and more

Total observations

Accepted Solution Solved
Reply
Contributor
Posts: 69
Accepted Solution

Total observations

Hello

 

I have a sas file of 4345 lines of observations while it is written to me in the output that the total lines are 8386 (the difference are lines with dots). I do not understand what made it but my question is how to delete these lines

 

Thanks a lot for any help


Accepted Solutions
Solution
‎05-30-2016 05:04 AM
Super User
Posts: 17,829

Re: Total observations

Did you import the file from a text or excel file? If so, you'll want to fix that step so it imports correctly. 

 

if you have a key variable you can check if that's present and delete otherwise. 

 

If missing(key_var) then delete;

View solution in original post


All Replies
Solution
‎05-30-2016 05:04 AM
Super User
Posts: 17,829

Re: Total observations

Did you import the file from a text or excel file? If so, you'll want to fix that step so it imports correctly. 

 

if you have a key variable you can check if that's present and delete otherwise. 

 

If missing(key_var) then delete;
Contributor
Posts: 69

Re: Total observations

thanks
☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 195 views
  • 0 likes
  • 2 in conversation