BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
anare
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
AlanC
Barite | Level 11

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.

https://github.com/savian-net

View solution in original post

4 REPLIES 4
Kurt_Bremser
Super User

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
Calcite | Level 5

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
Super User

@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
Barite | Level 11

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.

https://github.com/savian-net

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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