BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi

I have Created A prompt on my date field column which automatched_date and the format is ddmmyy10.
There are two prompts start and end date.
I have craeted these promts using parameter manager in Enterprise Guide.
when I run my project it runs sucessfully but when i create an Stored Process i getting the error

The parameter 'Automatched Date To' is defined to be enclosed in quotes; however, this is not supported by the stored process parameter model.

The parameter 'Automatched Date From' is defined to be enclosed in quotes; however, this is not supported by the stored process parameter model.


kindly tell me the solution
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
As a rule of thumb, I hardly ever specify my Enterprise Guide parameters to be enclosed in quotes, as I prefer to modify my program code accordingly -- use quotes where they're needed or don't use quotes where they're not needed. It seems to me that your best bet for help with this is to contact Tech Support. You have two issues -- how parameters work inside the world of EG and then how input parameters work in stored processes. The fact is that you may have to slightly modify your code when you create a stored process from your EG parameterized task.

Partly, Tech Support will have to look at the selection code in your stored process and help you figure out the best way to specify the parameter. Even if you specify the Date type for your input parameter (in the stored process) in order to get the little calendar box to come up (for the stored process prompting), the value that's being sent will still be a text string. (01OCT2007 versus 17440 -- which is the "internal" number for today as a SAS numeric date value);

This may be slightly different than how you were dealing with things in the parameter manager in EG. But, the bottom line is that you probably want to uncheck the box for automatic quoting and deal with the need for any quotes in your code or your generated code (by inserting code into your task). Tech Support can help you with that task by identifying the correct type of the variable in your comparison and they can help you set up the input parameters for the stored process the correct way.

cynthia

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 526 views
  • 0 likes
  • 2 in conversation