- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-23-2023 06:40 AM
(510 views)
When we created a stored procedure from sas eg using a code, we can create a propt by using utility,
For eg , if we create a Text, date or number type input promt, we can handle the value by using macro variable of same name as promt name.
Like if we create run_date prompt then we can us its value using &run_date.
So of i want to create a file or directory type of input for taking a xlsx file as input from input prompt, how that file need to be handled in code.
For eg , if we create a Text, date or number type input promt, we can handle the value by using macro variable of same name as promt name.
Like if we create run_date prompt then we can us its value using &run_date.
So of i want to create a file or directory type of input for taking a xlsx file as input from input prompt, how that file need to be handled in code.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
simply use the macro variable that refers to the xlsx file in double quotes:
LIBNAME xl XLSX "&yourPromptPath..xlsx";
________________________
- Cheers -