Re: Select * Bug - SAS Support Communities

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Select * Bug

Posted 04-11-2017 11:22 AM (606 views)

I just found the craziest bug. I have a query with a basic where clause and a join where if I use select * it returns one number of records if I spell out the column names it returns another. How is this possible? There are no other differences in the query.

This thread should be deleted.

2 REPLIES 2

Opal | Level 21

Opal | Level 21

Re: Select * Bug

Posted 04-11-2017 11:40 AM (595 views) | In reply to DavidPhillips2

David,

Post your code and an example data set that shows the discrepancy.

Art, CEO, AnalystFinder.com

Rhodochrosite | Level 12

Rhodochrosite | Level 12

Re: Select * Bug

Posted 04-11-2017 11:42 AM (590 views) | In reply to art297

Trying to delete this thread.