https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/852003#M336780 <P>In addition to defining more of the question, as others have mentioned, it's very helpful if you will share the code you have tried, and describe the problems with it (errors, not desired results, etc.)&nbsp; As general advice, most folks recommend starting with working SAS code (DATA steps and procs) before trying to write a macro (which will generate the SAS code).&nbsp; Do you have SAS code that works like you want?</P> Tue, 03 Jan 2023 17:12:44 GMT Quentin 2023-01-03T17:12:44Z https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851907#M336749 If record doesn't exist then save it in excel file Tue, 03 Jan 2023 09:57:55 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851907#M336749 Gauri123-56 2023-01-03T09:57:55Z https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851912#M336752 Could I ask you to be more specific, please?<BR />--fja Tue, 03 Jan 2023 10:08:34 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851912#M336752 fja 2023-01-03T10:08:34Z https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851922#M336754 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/404913">@Gauri123-56</a>&nbsp;wrote:<BR />If record doesn't exist then save it in excel file<HR /></BLOCKQUOTE> <P>Yes, much more explanation is needed. In particular, you are saying if something doesn't exist then save it ... you can't save something that doesn't exist. That requires a very clearly worded statement of what you want.</P> Tue, 03 Jan 2023 16:30:08 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851922#M336754 PaigeMiller 2023-01-03T16:30:08Z https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851997#M336775 <P>How do you intend to search for "if the record exists"? Are you going to supply a specific value for a named variable? Multiple variables? Do you know the names of the variables before hand? Actual values?</P> <P>&nbsp;</P> <P>What exactly is an "input file"? What format are the files? Where to do the input files reside? Do you expect to read the input file into a SAS data set?</P> <P>&nbsp;</P> <P>What exactly is the output supposed to look like? A list of record definitions? All of the data?</P> <P>How many "input files" are we talking about? Is the name of the input file supposed to be part of the output?</P> <P>&nbsp;</P> <P>Just a few of the details that need to be addressed.</P> Tue, 03 Jan 2023 16:26:17 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/851997#M336775 ballardw 2023-01-03T16:26:17Z https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/852003#M336780 <P>In addition to defining more of the question, as others have mentioned, it's very helpful if you will share the code you have tried, and describe the problems with it (errors, not desired results, etc.)&nbsp; As general advice, most folks recommend starting with working SAS code (DATA steps and procs) before trying to write a macro (which will generate the SAS code).&nbsp; Do you have SAS code that works like you want?</P> Tue, 03 Jan 2023 17:12:44 GMT https://communities.sas.com/t5/SAS-Programming/I-want-to-create-a-macro-to-check-record-exist-in-each-input/m-p/852003#M336780 Quentin 2023-01-03T17:12:44Z