BookmarkSubscribeRSS Feed
harryg
Calcite | Level 5
Can someone recommend a table maintenance application (or process) for updating SAS(and/or SQL) datasetes? What we're looking to accomplish is some basic add/change/delete operations on simple tables and datasets without alot of user interface programming.

Using the Microsoft Office Add-In we can read the tables and dataset into a speadsheets for end user review. The issue is when we want to make some new additions, changes or deletions to the data, it seems like we've got to go thru several steps to get the data back into the shared SAS datasets or SQL tables.

What am I missing? What are some options or paths to pursue?
2 REPLIES 2
Flip
Fluorite | Level 6
If it is simple editing, why not just use the SAS VIEWTABLE editor?
deleted_user
Not applicable
HarryG

if you have licensed the module SAS/FSP, you'll find [pre] proc fsedit data= your.sastable screen= sasuser.your.sastable ; run; [/pre]provides a customisable form view for updating YOUR.SASTABLE, and [pre] proc fsview data= your.sastable formula= sasuser.profile.sastable ; run;[/pre]provides a similarly customisable table view enabling update of YOUR.SASTABLE.
There are equivalent SAS Display Manager commands.
The convenience, customisability and speed of the interface makes it worth the licence fee for SAS/FSP.
I build it into the SAS explorer actions. Storing and generalising the syntax there means I have the form or table access for edit/browse/update in the layout prefered for each table, available at a mouse click.

just imho
. . . . . . . FSP rocks

PeterC

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 2 replies
  • 640 views
  • 0 likes
  • 3 in conversation