Using prompt to populate table with two columns

[camfarrell25]

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; 

[Reeza]

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; 

---

[camfarrell25]

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?

[VDD]

Have you looked at SAS Screen Control Language examples?

[Reeza]

---

@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/