topic Re: How to pass macro parameter to File reader transformation to read latest csv file? in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82876#M764 <HTML><HEAD></HEAD><BODY><H1><A _jive_internal="true" href="https://communities.sas.com/message/129597#129597">How to pass macro parameter to File reader transformation to read latest csv file?</A> </H1><P></P><P>Please I have this question in SAS DI 3.4.</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 14 Jun 2012 13:15:00 GMT SYN 2012-06-14T13:15:00Z How to pass macro parameter to File reader transformation to read latest csv file? https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82875#M763 <HTML><HEAD></HEAD><BODY><P><BR />I have one situation,</P><P>I have 3 different .CSV files and using file reader tranformation I have build the job for all 3 csv files.</P><P>I want to pass latest files every time using my user written code.</P><P></P><P>Can you please help me how to pass macro parameters.</P><P></P><P>Is there any simple way please let me know.</P><P></P><P>Thanks in advance. </P></BODY></HTML> Thu, 14 Jun 2012 13:09:11 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82875#M763 SYN 2012-06-14T13:09:11Z Re: How to pass macro parameter to File reader transformation to read latest csv file? https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82876#M764 <HTML><HEAD></HEAD><BODY><H1><A _jive_internal="true" href="https://communities.sas.com/message/129597#129597">How to pass macro parameter to File reader transformation to read latest csv file?</A> </H1><P></P><P>Please I have this question in SAS DI 3.4.</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 14 Jun 2012 13:15:00 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82876#M764 SYN 2012-06-14T13:15:00Z Re: How to pass macro parameter to File reader transformation to read latest csv file? https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82877#M765 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>DI 3.4 may not support my approach; I haven't checked. What I do in 4.x, in a nutshell, is to </P><P></P><P>1) define the CSV in the metadata with a macro variable reference as the filename&nbsp; (like &amp;csvfile). make certain the generated code wraps this in double quotes or you're stuffed. This may actually be the breaking point for 3.4.</P><P>2) define and load a table that holds files present in your input location and keeps track of their processed status, eg through a timestamp. </P><P>3) Then in a job process that table in the first step to find out which file must be processed. Stick that value in a macro var. As the next step process the external file you defined in the metadata. Give that step a parameter to transfer the result from step 1 into the macro variable that matches the filename of the CSV file from 1). As a last step (or a subsequent job) mark the file as processed in the table as defined in 2).</P><P></P><P>Good luck, Jan.</P></BODY></HTML> Thu, 14 Jun 2012 14:34:59 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82877#M765 jklaverstijn 2012-06-14T14:34:59Z Re: How to pass macro parameter to File reader transformation to read latest csv file? https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82878#M766 <HTML><HEAD></HEAD><BODY><P>Hi SYN,</P><P></P><P>Check this link..it might be helpfull</P><P></P><P><A _jive_internal="true" class="active_link" href="https://communities.sas.com/message/129750#129750">https://communities.sas.com/message/129750#129750</A></P><P></P><P>This will help you in making a parameter file and you can resolve that in you DI,One more thing you need to do is to get the latest file.</P><P></P><P>Thanks,</P><P>Shiva</P></BODY></HTML> Fri, 15 Jun 2012 13:02:48 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-pass-macro-parameter-to-File-reader-transformation-to/m-p/82878#M766 shivas 2012-06-15T13:02:48Z