Blank table and permissions

[anare]

Hi All,

I need to create a blank table in Backed and in front-end i should give permission to the team.

Can anyone suggest me how to create front-end.

Regards,

Naresh

[Kurt_Bremser]

Please be more specific:

- what constitutes a "blank" table?

- what is your "backend"?

- what is your "frontend"?

And use a more specific subjects for your posts. Base SAS in the Base SAS Programming forum is, ahem, not intelligent.

[anare]

Hi Thanks for the reply,

1) I have created a table called Student as back-end.

Data Student;
Input FName $ LName $ Class $5.;
Cards;
Madhu Shankar 8th
Ravi Shankar 10th
;
run;

2) Same from front-end prospective i need to give some forms or excel to the students to fill all the above details and class variable should be drop down till 10th.

Once if they submit data should be saved in the back-end.

Can anyone guide me  is it possible to created the above requirement.?

[Reeza]

---

@anare wrote:

Hi Thanks for the reply,

1) I have created a table called Student as back-end.

Data Student;
Input FName $ LName $ Class $5.;
Cards;
Madhu Shankar 8th
Ravi Shankar 10th
;
run;

2) Same from front-end prospective i need to give some forms or excel to the students to fill all the above details and class variable should be drop down till 10th.

Once if they submit data should be saved in the back-end.

Can anyone guide me  is it possible to created the above requirement.?

---

SAS isn't designed for data collection. If you're trying to collect data, build an MS Access Form or a web form. 

[AlanC · Accepted solution]

This is a very complex topic. For collecting data, you need to identify a technology. A website is a good start but you can use just about anything (windows app, cell, Excel, Access, etc.). Here is a suggestion to simplify it greatly. 

Search online for forms. Several sites will allow you to create them. Here is google's:

https://docs.google.com/forms/u/0/

Build a form, collect the results in delimited format, gather all of them and read them into SAS using a data step.