cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Paulnf
‎10-15-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS reading in and writing out empty table

by Calcite | Level 5 in SAS Programming
‎09-13-2018 10:48 AM
‎09-13-2018 10:48 AM
HI Reeza,   I described the issue wrongly.   The code above is what I ran, and there were no error or warning messages in the log.   According to the log, 0 records were read and zero records were written out.   Hope this helps,     ... View more

Re: SAS reading in and writing out empty table

by Calcite | Level 5 in SAS Programming
‎09-13-2018 10:19 AM
‎09-13-2018 10:19 AM
Its a basic data step. No conditional statements   data nn; set xxx(obs=1); run; ... View more

SAS reading in and writing out empty table

by Calcite | Level 5 in SAS Programming
‎09-13-2018 10:10 AM
‎09-13-2018 10:10 AM
Hi guys,   I have a quick question.   I have been trying to extract some fields from a table using SQL passthrough for SAS. The table is a Teradata table, and I have checked the table on Teradata and it contains records. However, when I extract the table in SAS, SAS returns an empty table.   Log reads: NOTE: There were 0 observations read from the data set XXXX.   Please does anyone understand why SAS retrieves zero rows, and how I can fix this?   Thanks,     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-15-2018 03:42 PM
Quick links