About Jim_O_CCCU

Jim_O_CCCU · ‎03-14-2019

Hi all, We opted for a hybrid approach in the end. 1. Used Base SAS to produce a dataset containing my key info fields and the blank fields that the users need to populate - output as an MS Access database table 2. Developed an MS Access front end, linked to the table from (1), hosted on a organisational shared drive to do handle the data input, access control, auditing and validation 3. Built and scheduled a SAS VA report over the MS Access table to give an up to date picture of data entry progress and MI on what the gathered data was telling us Thanks for your input on the other potential solutions Jim

Jim_O_CCCU · ‎10-06-2017

Hi jitz83, Thanks very much, that worked! Best regards Jim

Jim_O_CCCU · ‎10-03-2017

Bump - Hi Kurt, do you need more info? Thanks Jim

Jim_O_CCCU · ‎10-02-2017

OK Properties of the library are as follows: Type: Library Description: Visual Analytics library definition for LASR data Server: SASVA Engine: SASIOLA Location: /Products/SAS VA Admin Options: TAG=HPS HOST=myserverpath SIGNER:http://myserverpath:80/ SASLASRAuthorization PORT=10011 Libref: MYVALIB Read Only: No Temporary: No ++++++++++++++++++++++ Thanks Jim

Jim_O_CCCU · ‎10-01-2017

Thanks for coming back. Yes will, do. I'll pick this up again tomorrow once I'm back in the office. 🙂

Jim_O_CCCU · ‎09-30-2017

Hi, We don't have anything loaded to the public LASR, are you suggesting loading a table to that server as a test - permissions being lower or something? Thanks Jim

Jim_O_CCCU · ‎09-30-2017

Hi Nik, The forum was awesome thanks. I will check that out and PM you should it fit the bill. 😎 Jim

Jim_O_CCCU · ‎09-30-2017

Thanks for coming back. The dataset is pretty simple, about 800 obs, 20 variables with a primary key. I want users to populate 3 numeric variables, the rest are text, I will display around 10 of the text variables to assist users. Ideally, I'd like to show the 13 variables in a table, have the 3 numeric columns editable and have a save button to commit the changes back to the underlying SAS dataset. Regards Jim

Jim_O_CCCU · ‎09-29-2017

Hi all, Last week I attended the SAS UK forum and was blown away by the possibilities of stored processes (amongst other things). It has got me thinking about being a possible solution to a business need we have to allow editing/updating of a SAS dataset. Essentially, I want to show some of the columns in a dataset to the user via the web browser in a table, allow data to be entered into a column and then save that back to the underlying dataset. I have a fairly decent grasp of HTML, CSS and JavaScript to help in this. So, am i proposing the impossible? Your advice would be greatly appreciated. Thanks Jim SAS 9.4 M3

Jim_O_CCCU · ‎09-29-2017

EG:7.11 VA: 7.2 (Non-distributed) Dear all, I can drag a LASR table from it's libray (in the servers library tree) on to the process flow - which then opens for me to view the data, but am not able to access the same programmatically... data test; set myvalib.mytable; run; Throws the following: ERROR: Libref myvalib is not assigned I have done a right click-->Properties on the library in the tree and have verified that the libref is correct. Many thanks in advance Jim

Online Status	Offline
Date Last Visited	‎06-18-2019 08:32 PM

Re: Stored Process Server - Editable Dataset - Possible?

Re: Access LASR tables

Re: Stored Process Server - Editable Dataset - Possible?

Re: Access LASR tables

Re: Access LASR tables

Re: Access LASR tables

Re: Stored Process Server - Editable Dataset - Possible?

Re: Stored Process Server - Editable Dataset - Possible?

Stored Process Server - Editable Dataset - Possible?

Access LASR tables

Re: Access LASR tables

Re: Stored Process Server - Editable Dataset - Possible?

Stored Process Server - Editable Dataset - Possible?

Re: Stored Process Server - Editable Dataset - Possible?

Re: Access LASR tables

Re: Stored Process Server - Editable Dataset - Possible?

Re: Access LASR tables

Re: Access LASR tables

Re: Access LASR tables

Re: Stored Process Server - Editable Dataset - Possible?

Re: Stored Process Server - Editable Dataset - Possible?

Stored Process Server - Editable Dataset - Possible?

Access LASR tables