comp.soft-sys.sas - The SAS statistics package.
Hi I just upgraded to V9 and I need to change my work library from c: to another drive, but when I search for the config file, I don't see anything I recognise. I find the following 3 files: itconfig.exe config.tem sas.report.config.jar can someone point me in the right direction here? thanks in advance, Machelle
> From: z.chrysalis8 > Subject: how to control library permission if the library is > assigned in autoexec > > I am having problem giving read/ write permission to a library in SMC. > I gave read only access to a user for a library. But when the user > login using EG, the user is able to read and write to the library. I > suspect is because of the library assignment in autoexec file as when > the library assignment is removed from autoexec, the permission given > is working alright. > > The problem is the library assignment in autoexec is needed for other > SAS programs. It would be troublesome to change this. Is there other > workaround to control library permission with library assignment in > autoexec? > that may be more trouble that it is worth you will have to unassign the libref and then reassign it with permissions: libname library clear; run; libname library '<...>' <permissions>; and the problem you will have are that the libref library contains catalogs that options refer to. iirc it is (next to/nearly) impossible to deallocate a libref which contains a reference to compiled and stored macro catalogs without jumping thru hoops. Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
Amar, Sounds like the file already exists. If you have the correct write permission, you might succeed with including the REPLACE option. HTH, Art ----------- On Feb 12, 2:39 am, Amar Mundankar < XXXX@XXXXX.COM > wrote: > Hi all, > While executing following code, I am getting error as : > ERROR: Execute: Unable to insert row : > > What can be the reason???? > > Below is the CODE and LOG. > > CODE: > > LIBNAME SD2 "G:\AppData\InfoOne_SAS\adhoc\IMP\CV\SASDATA"; > DATA TEST_PAY; > SET SD2.FPR_ECS_DIST; > WHERE substr(DISTRICT,1,4)= '4Z17'; > RUN; > > PROC EXPORT DATA = TEST_PAY dbms=excel2000 OUTFILE = "\\tsclient\G > \PUBLIC\! Warning - Files In This Directory are Deleted every 15 days > \Sample\FPR_QC\ECSPAYDIST"; RUN; > > LOG: > /*===============================================*/ > LIBNAME SD2 "G:\AppData\InfoOne_SAS\adhoc\IMP\CV\SASDATA"; > NOTE: Libref SD2 was successfully assigned as follows: > Engine: V9 > Physical Name: G:\AppData\InfoOne_SAS\adhoc\IMP\CV\SASDATA > 2 DATA TEST_PAY; > 3 SET SD2.FPR_ECS_DIST; > NOTE: Data file SD2.FPR_ECS_DIST.DATA is in a format native to another > host or the file encoding > does not match the session encoding. Cross Environment Data > Access will be used, which may > require additional CPU resources and reduce performance. > 4 WHERE substr(DISTRICT,1,4)= '4Z17'; > 5 RUN; > > NOTE: There were 122700 observations read from the data set > SD2.FPR_ECS_DIST. > WHERE SUBSTR(DISTRICT, 1, 4)='4Z17'; > NOTE: The data set WORK.TEST_PAY has 122700 observations and 47 > variables. > NOTE: DATA statement used (Total process time): > real time 40.21 seconds > cpu time 14.75 seconds > > 6 > 7 PROC EXPORT DATA = TEST_PAY dbms=excel2000 OUTFILE = "\\tsclient\G > \PUBLIC\! Warning - Files > 7 ! In This Directory are Deleted every 15 days\Sample\FPR_QC > \ECSPAYDIST"; RUN; > > NOTE: New file "\\tsclient\G\PUBLIC\! Warning - Files In This > Directory are Deleted every 15 > days\Sample\FPR_QC\ECSPAYDIST.XLS" will be created if the export > process succeeds. > ERROR: Execute: Unable to insert row > WARNING: File deletion failed for _IMEX_.TEST_PAY.DATA. > ERROR: Export unsuccessful. See SAS Log for details. > NOTE: The SAS System stopped processing this step because of errors. > NOTE: PROCEDURE EXPORT used (Total process time): > real time 15.63 seconds > cpu time 11.07 seconds > /* ===========================================*/ > > Regards, > Amar Mundankar.
i am using sas for win 8.2. is there some line of code i can insert into my program that will clear the contents of the work library without having to quit the sas program? this would be the code equivalent to going into the explorer window, opening up the work folder and right clicking on each temp data set and choosing delete. thank you doyle