topic Re: Blank table and permissions in SAS Programming

Blank table and permissions

anare — Thu, 26 Oct 2017 13:23:40 GMT

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

Re: Blank table and permissions

Kurt_Bremser — Thu, 26 Oct 2017 13:28:41 GMT

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.

Re: Blank table and permissions

anare — Thu, 26 Oct 2017 14:09:50 GMT

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.?

Re: Blank table and permissions

Reeza — Thu, 26 Oct 2017 14:52:23 GMT

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

Re: Blank table and permissions

AlanC — Thu, 26 Oct 2017 22:10:47 GMT

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.