About sas_9

sas_9 · ‎08-26-2013

I have ran proc datasets lib=sasuser kill memtype=data to kill datasets under 'SASUSER' library (c:\.....) it ran successfully but didn't cleanup datasets, no error in the log. I took a look into system security and figured that userid this batch job running with is in not 'ADMINISTRATOR' group. userid is in 'SAS SERVER USER' group list but not in 'ADMINISTRATOR' group...and that might the case it ran but didn't cleanup datasets...it also might possible i am running this batch job from 'f:\', share drive, and trying to clean something in 'c:\' drive...

sas_9 · ‎08-20-2013

i have created some sas data sets and views in test library and below code is deleting sas datasets only, leaving view undeleted - but still is it safe to run this code in as BAT file? and will it delete sas data sets in 'SASUSER' library which is 'READ' only? libname xyz 'f:\xyz'; proc datasets lib=xyz kill memtype=data; run; quit;

sas_9 · ‎08-20-2013

Hi Japp - i have chcked it and its running using 'ussasadmin' user id only. property if the library (SASUSER) is as follow; server=sasmain engine- v9 readonly - yes temporary - no so i think wourkaround might be - forcing directory to delete sas data sets by putting some special character in command line and then may need to provide new library to users to save their work...rather than use 'SASUSER' library to storing eg session/work Thanks!

sas_9 · ‎08-20-2013

I am familiar with that process but i am not sure if it will delete 'profile file' and 'registry files' too...I don't want to delete those files since this is 'SASUSER' library...

sas_9 · ‎08-19-2013

try this error note if its helps at some point... 17108 - "Microsoft Office Excel encountered a problem and needs to close" afterSAS Add-In for Microsoft Office 2.1 installed

sas_9 · ‎08-19-2013

Hello community we are running SAS application (eg) on server machine only. users used to save their work (temporary kind of work) on 'SASUSER' library (eg session work) and i have tried to clean only sas data sets (.sas7bdat) (I think this library is not temporary as well as not permanant where we can save work all the time...and that is y i planned to clean that up on weekly bases on WINDOWS environment). I ran following command in BAT file but it failed to clean it, however i don't see anything wrong in command line... can anyone please suggest/help on this how can i cleanup 'SASUSER' library with sas data sets only (.sas7bdat) on server itself... -------------------------------------------------------------- set LogDir="f:\prodn\log" c: cd \ DEL C:\Documents and Settings\ussasadmin\My Documents\My SAS Files\9.1\*.sas7bdat echo cleanup has been done at 'C:\Documents and Settings\ussasadmin\My Documents\My SAS Files\9.1' >>%logdir%\temp_cleanup.log date /t >> %logdir%\temp_cleanup.log time /t >> %logdir%\temp_cleanup.log echo. >> %logdir%\temp_cleanup.log exit -------------------------------------------------------------- Thanks all!

sas_9 · ‎08-08-2013

I got it - Thanks all for your time and your input... Sandip

sas_9 · ‎08-08-2013

Jaap - this is not about only SAS Disck cleanup handler utility - i have created bat file which will take care of that part - my question is more about another folder (x) where i want to delete sas datasets but i am not sure to DELETE OR KEEP this extension too ('.sas7bitm', and '.sas7bcat') --- so basically i am waiting for GO or NO-GO decision... Thanks!

sas_9 · ‎08-07-2013

Hi Barry - Not only temporary work library folder (i have written BAT file which will clear everything under temporary work folder: subfolder, files and datasets and evreything) but also other folder where users are used to store some temporary datasets and i am going to add below command in same BAT file. so simply, i am wondering is it okay to delete all these file (regstry.sas7bitm, profile.sas7bcat, profile2.sas7bcat) along with .sas7bdat extension for 'X' folder or i have to keep all these files. As i have added below code in the BAT file it will delete only ".sas7bdat" extension but i was wondering if its okay to delete every extensions (.sas7cdat, .sas7bitm). del x:\Documents and Settings\9.1\*.sas7bdat Basically I am planning to handle two things at a time, cleaning temporary 'work' folder and cleaning only .sas7bdat extension in 'X' folder...in one BAT file... thanks!

sas_9 · ‎08-03-2013

Hi Jaap - i really appreciate your type - my only concern is i am planning to make one BAT file which would clear datasets (.sas7bdat) in particular folder and i am not sure if i have to delete below files along with data sets in that folder or have to keep it...(and this is not sas 'work' folder i am taking about, this folder is located @ "x:\Documents and Settings\9.1") thanks... regstry.sas7bitm profile.sas7bcat profile2.sas7bcat

sas_9 · ‎08-02-2013

is following command will work to delete only sas7bdat extension and leave all rest 3 files extensions (.sas7bitm, .sas7bcat)? :: to delete only .sas7bdat extension del x:\Documents and Settings\9.1\*.sas7bdat :: to clear temp folder rmdir c:\work\temp /s /q Thanks!

sas_9 · ‎08-02-2013

Hi Jaap - if i understand you correctly i cannot delete all these files under 'X' folder same as i can do with 'WORK' folder, right? i would rather write a SAS code to delete just sas datasets under 'X' folder? Thanks!

sas_9 · ‎08-02-2013

Hi friends - i am making one BAT files which will clear SAS 'WORK' folder, I am also planning to include one more folder path in same BAT file which would clear 'x' folder which has SAS DATASETS as well as below three files... regstry.sas7bitm profile.sas7bcat profile2.sas7bcat I don't think BAT files will keep these files in place once i set it up, it will clear everything including above files...so is it okay to clear above files in 'X' folder too, becasue i have seen same files as above in SAS temporary 'WORK' folder where we can delete these. Thanks!

sas_9 · ‎07-31-2013

This will help you! http://support.sas.com/kb/45/592.html http://support.sas.com/kb/49/873.html

sas_9 · ‎07-26-2013

Hey J - you can write program - right click on it and choose option 'run locally' from server selection option or direct option... this way you can check if its running or not - if not describe error message, someone can explain

Online Status	Offline
Date Last Visited	‎04-18-2019 08:51 AM

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

How do I read multiple space delimited file?

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: starting/stopping services on grid

Re: Importing a file with multiple delimiters per record

Re: importing csv file by changing multiple different characters.

Re: "An error occurred executing the workspace job"

Re: How to Write a SAS Dataset to a Pipe Delimited Text File (Not Usin...

Re: How to ODBC SQL Server with multiple database?

Re: If I Pre-Assign an Oracle Library with the Management Console, It ...

Re: How to ODBC SQL Server with multiple database?

Re: cleaning 'sasuser' library

Re: cleaning 'sasuser' library

Re: cleaning 'sasuser' library

Re: cleaning 'sasuser' library

Re: Trouble with EG and AMO (Excel 2013)

cleaning 'sasuser' library

Re: making BAT file to delete SAS dataset

Re: making BAT file to delete SAS dataset

Re: making BAT file to delete SAS dataset

Re: making BAT file to delete SAS dataset

Re: making BAT file to delete SAS dataset

Re: making BAT file to delete SAS dataset

making BAT file to delete SAS dataset

Re: Left join problem

Re: How to run a program in EG5.1 without connecting to a server