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
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.
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.
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.?
@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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.