BookmarkSubscribeRSS Feed
RamKumar
Fluorite | Level 6

In reference to generating external file for file reader transformation,
just I wanted to know how to define the number of records (see attached snap ) if
we are not aware of the record count? Because file count is not static as we
receive the for every hour and the record count may vary for each file.

On a related point, how should I register my external file
for file reader transformation if it is getting updated for every hour?
Please note that my file will be delivered to same location in UNIX server with
time stamp.


Reading_External_File.png
1 REPLY 1
LinusH
Tourmaline | Level 20

Record count is not part of the external file metadata. Don't have access to DIS at the moment but if you don't specifically set  a max row count, you'll be fine. The record count in your screen shot is just for that dialog, will not be registered in metadata.

Do you mean that the file name will contain a time stamp? If so, the most common is to solve this by using a macro variable in the External File physical path, and build some logic to resolve it to an appropriate value at execution time.

Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 756 views
  • 0 likes
  • 2 in conversation