topic Re: sas enterprise gui in New SAS User

sas enterprise gui

jayasubbareddy — Sat, 23 Mar 2019 17:05:53 GMT

i have 1000 csv files i need to import all files at a time by using both using macro statements

Re: sas enterprise gui

VDD — Sat, 23 Mar 2019 17:11:56 GMT

before jumping to macro aspect do you have working code to read a single csv file?

you have to do the basic concept of getting the data into a SAS table before macro functions can be applied.

You have not given needed information in order to assist you.

Re: sas enterprise gui

jayasubbareddy — Sat, 23 Mar 2019 18:28:12 GMT

i have already knowledge on Base sas i am expected sas macro

Re: sas enterprise gui

Kurt_Bremser — Sat, 23 Mar 2019 19:12:57 GMT

Give us more information. Show the code you have for one import, and tell us if your csv files share the same structure or not. Also give us the necessary information about the filenames, so we can determine if wildcards could be helpful.

Big hint: one-liners like you posted are not likely to attract a quick solution. Help us to help you.

Re: sas enterprise gui

Reeza — Sun, 24 Mar 2019 23:21:07 GMT

@jayasubbareddy wrote:

i have already knowledge on Base sas i am expected sas macro

Then you're aware that you don't need a macro to import multiple text files in a single data step. That you can use FILEVAR to specify the different file names as one option, or use a wildcard to read all files at once? And that you can use FILENAME option to capture the file name as well to track which records comes from which files?

Show your current import code and we can help you to convert it to a macro if needed.

Re: sas enterprise gui

andreas_lds — Mon, 25 Mar 2019 13:50:21 GMT

Fortunately you are not the first one with such a problem, so you will find working code in the web.

If all files have the same structure, you don't need macro code, but wildcards in the infile statement. If you need to identify the files currently being processed, the infile-statemtn has an option for this.