topic Re: Using the input from a prompt to define a file path using a macro in SAS Programming

Using the input from a prompt to define a file path using a macro

AJChamberlain — Mon, 17 Dec 2018 15:27:54 GMT

Greetings SAS persons,

I have a prompt I am using in Enterprise Guide which requires the user to add a month in the input field in YYYYMM format, so for example '201811' for November 2018.

My code is creating a file which is exported as an excel file and I want to put into a folder, depending on the YYYYMM that is filled in.

So for example if the user puts 201811 in the prompt then the file needs to get written to:

"C:\My Directory\201811\MyExcelFiles_201811"

If the user puts in '201812' it will go into:

"C:\My Directory\201812\MyExcelFiles_201812"

and so on.

I think I can define this with a macro in the code, but I am not sure how can anyone help please?

Thanks

Andy

Re: Using the input from a prompt to define a file path using a macro

Astounding — Mon, 17 Dec 2018 15:35:14 GMT

Do you have working code that does not use macro language? For example, if you knew that the user was going to enter 201812, do you have a program that would export the file to the proper folder?

Re: Using the input from a prompt to define a file path using a macro

AJChamberlain — Mon, 17 Dec 2018 15:46:13 GMT

Unfortunately not. I don't have to use a macro to solve this, if there's another way I'll take that!

Thanks

Re: Using the input from a prompt to define a file path using a macro

Reeza — Mon, 17 Dec 2018 15:58:42 GMT

Here's some references that may help you.

In general, just replace the value with the prompt with a & in front of it and period after. If you need to create a folder that doesn't already exist, you'll need to use DCREATE() to create the directory first with the file path and then use the path below to export it to.

"C:\My Directory\&Prompt_Value.\MyExcelFiles_&prompt_value..pdf"

https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/

@AJChamberlain wrote:

Greetings SAS persons,

I have a prompt I am using in Enterprise Guide which requires the user to add a month in the input field in YYYYMM format, so for example '201811' for November 2018.

My code is creating a file which is exported as an excel file and I want to put into a folder, depending on the YYYYMM that is filled in.

So for example if the user puts 201811 in the prompt then the file needs to get written to:

"C:\My Directory\201811\MyExcelFiles_201811"

If the user puts in '201812' it will go into:

"C:\My Directory\201812\MyExcelFiles_201812"

and so on.

I think I can define this with a macro in the code, but I am not sure how can anyone help please?

Thanks

Andy

Re: Using the input from a prompt to define a file path using a macro

AJChamberlain — Mon, 17 Dec 2018 17:57:10 GMT

Thanks guys that's worked A