selecting the contents of the table after selecting the date

[Gieorgie]

Sas enterprise guide sas eg im using

[Reeza]

This then?
https://video.sas.com/detail/video/3829767505001/create-and-use-prompts-in-queries-and-tasks

Or a written reference if you prefer that:

https://support.sas.com/resources/papers/proceedings13/028-2013.pdf

[Reeza · Accepted solution]

Is Date in mart_credit a SAS date? Numeric with a format?
What is the name of the prompt with the date and how does it resolve? You can check it with the following:

%put &promptVariable.;

If the date is numeric with a date format and promptVariableValue looks like '01Jun2021' then your code would look like:

where date = "&promptVariable"d;

[Gieorgie]

Ok, I created a prompt where I can select a list from the hints, how to enter a macro in the Program icon that will load me the date from the prom?

[Reeza]

Did you look at the video or paper referenced? It has instructions on how to create a prompt and then use it in your processes.

[Gieorgie]

%let gv_dateF=%sysevalf(%bquote('&datacorep.'d));
%let gv_date_hF=%sysevalf(%bquote('&datacorep_h.'d))%let gv_dateF=%sysevalf(%bquote('&datacorep.'d));
%let gv_date_hF=%sysevalf(%bquote('&datacorep_h.'d))

I created oromt and assigned to program, but i would like load data from promt like a above code and run code which will created table

proc sql;
create table NewDef as
select
spr_NRB,
spr_DEFAULT
from kredyty
where data danych = &gv_dateF;

but still not working 😞

[Reeza]

Because as someone else said, macro variables do not resolve in single quotes. Try double quotes instead for starters.

[Gieorgie]

Thanks for everyone its working 🙂