topic Re: Using prompt to populate table with two columns in SAS Procedures

Using prompt to populate table with two columns

camfarrell25 — Wed, 22 Aug 2018 14:17:49 GMT

Hello,

I am trying to add a prompt that would allow the user to populate the following table using the prompt instead of manually adjusting the code.

Ideally, the user would be able to input multiple names and the associated gender.

The two variables:

Name $30

Gender $6



DATA gender_names_v2_add;

set gender_names_v1 (drop= datetime);

INPUT NAME GENDER; 

DATALINES;

PIEROLIVIER M

RUN;

Re: Using prompt to populate table with two columns

Reeza — Wed, 22 Aug 2018 15:13:22 GMT

So what is the question you need help with?

What are your parameter names and what's not working? I see no reference to your parameters in your code for starters.

@camfarrell25 wrote:

Hello,

I am trying to add a prompt that would allow the user to populate the following table using the prompt instead of manually adjusting the code.

Ideally, the user would be able to input multiple names and the associated gender.

The two variables:

Name $30

Gender $6
DATA gender_names_v2_add;

set gender_names_v1 (drop= datetime);

INPUT NAME GENDER; 

DATALINES;

PIEROLIVIER M

RUN; 

Re: Using prompt to populate table with two columns

camfarrell25 — Wed, 22 Aug 2018 15:35:24 GMT

I am not sure how to have the prompt be a table essentially, allowing the user to input name and gender.

Is that something that is feasible?

Re: Using prompt to populate table with two columns

VDD — Wed, 22 Aug 2018 18:58:10 GMT

Have you looked at SAS Screen Control Language examples?

Re: Using prompt to populate table with two columns

Reeza — Wed, 22 Aug 2018 19:26:26 GMT

@camfarrell25 wrote:

I am not sure how to have the prompt be a table essentially, allowing the user to input name and gender.

Is that something that is feasible?

Sure, register your table in the metadata server, then select Prompt Type as Text. Then for Method select User selects from static/dynamic list. If it's a dynamic list, you can add the source to be a table (if it's registered in the metadata server) or you can manually create your list in the prompt.

I suspect we're dealing with an XY type problem here and if you could explain your requirements more we may be able to suggest different options.

XY problem: http://xyproblem.info/