topic Re: File Reader Transformation - Record Count in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/File-Reader-Transformation-Record-Count/m-p/179337#M3607 <HTML><HEAD></HEAD><BODY><P>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&nbsp; 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.</P><P></P><P>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.</P></BODY></HTML> Wed, 16 Jul 2014 09:16:42 GMT LinusH 2014-07-16T09:16:42Z File Reader Transformation - Record Count https://communities.sas.com/t5/SAS-Data-Management/File-Reader-Transformation-Record-Count/m-p/179336#M3606 <HTML><HEAD></HEAD><BODY><P>In reference to generating external file for file reader transformation,<BR />just I wanted to know how to define the number of records (see attached snap ) if<BR />we are not aware of the record count? Because file count is not static as we<BR />receive the for every hour and the record count may vary for each file. </P><P></P><P></P><P>On a related point, how should I register my external file<BR />for file reader transformation if it is getting updated for every hour? <BR />Please note that my file will be delivered to same location in UNIX server with<BR />time stamp.</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/11863i1F909FC94EAAF6C7/image-size/large?v=1.0&amp;px=600" border="0" alt="Reading_External_File.png" title="Reading_External_File.png" /></BODY></HTML> Tue, 15 Jul 2014 09:02:19 GMT https://communities.sas.com/t5/SAS-Data-Management/File-Reader-Transformation-Record-Count/m-p/179336#M3606 RamKumar 2014-07-15T09:02:19Z Re: File Reader Transformation - Record Count https://communities.sas.com/t5/SAS-Data-Management/File-Reader-Transformation-Record-Count/m-p/179337#M3607 <HTML><HEAD></HEAD><BODY><P>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&nbsp; 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.</P><P></P><P>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.</P></BODY></HTML> Wed, 16 Jul 2014 09:16:42 GMT https://communities.sas.com/t5/SAS-Data-Management/File-Reader-Transformation-Record-Count/m-p/179337#M3607 LinusH 2014-07-16T09:16:42Z