topic Re: About prompts in SAS Programming

Prompts - how to load data with prompts

Mxmaverick — Wed, 19 Jun 2019 01:29:01 GMT

Hi everyone, I want to know if using the prompts I can load data directly to a dataset, and after that, a way that all this is showned inside the prompt, or something like a quick view of the table with the new data. Many thanks

Prompts to load data

Mxmaverick — Wed, 19 Jun 2019 01:28:05 GMT

Re: Doubt about prompts

heffo — Tue, 18 Jun 2019 23:36:50 GMT

I suspect that you want is in a prompt be able to dynamically show a list of values from a data set.

If so, then yes you can, but the table needs to be registered in the metadata. You can't dynamically point out the table in the prompt.

If you on the other hand just want a static list of values from a data set, then you can add (import) those when you create the prompt. But, of course, if the data changes, nothing changes in the prompt.

Re: About prompts

heffo — Wed, 19 Jun 2019 00:00:42 GMT

Please don't double post questions. 🙂

Re: Prompts - how to load data with prompts

Reeza — Wed, 19 Jun 2019 01:34:06 GMT

I've merged your questions and updated your subject, it was a bit vague.

Your question is unclear. Can you explain what you mean by load data directly to a data set? Are you intending to add records to a data set via a prompt? That is possible but not a great usage of macro variables.

Re: Prompts to load data

heffo — Thu, 20 Jun 2019 01:37:33 GMT

I don't fully understand what you want to do. But a prompt is mainly used to select input parameters for the rest of your code. It is not specifically used to feed a table with data.

The prompt generates macro variables that could be used in the dialog boxes in EG or in code. The code could of course use the macro to create data in a data set, but I don't think that you want this.

If you want a way to look at a new data set and figure out what it is about, then prompts are not the way to go.