DATA Step, Macro, Functions and more

Blank table and permissions

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Blank table and permissions

[ Edited ]

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


Accepted Solutions
Solution
3 weeks ago
Frequent Contributor
Posts: 119

Re: Blank table and permissions

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.

View solution in original post


All Replies
Super User
Posts: 7,866

Re: Blank table and permissions

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 13

Re: Blank table and permissions

Posted in reply to KurtBremser

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

 

 

Super User
Posts: 19,878

Re: Blank table and permissions


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. 

Solution
3 weeks ago
Frequent Contributor
Posts: 119

Re: Blank table and permissions

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 143 views
  • 0 likes
  • 4 in conversation