About Billybob73

Billybob73 · ‎02-03-2018

Hi, I have a sas dataset with 2 variables. I would like to accomplish below. If the value of VAR2 is part of the string in VAR1 FIND needs to be 1, if not 0. How can I do this ? I've been trying out FINDC, CAT, INDEXC but none of these work. Many thanks ! VAR1 VAR2 FIND \TEST1\IPN R1\2012\2013\CLEARPATH-COMMANDS.TXT IPN R1\2012\DOCUMENT 0 \TEST2\IPN R1\2009\DOCUMENTEN\TRIGGERS DATA_ACCES.TXT IPN R1\2009\DOCUMENT 1 \TEST3\IPN R1\2006\DOCUMENTATION\VIEW SCH_RGL_GPH.SQL IPN R1\2006\DOCUMENT 1

Billybob73 · ‎02-02-2018

Hi Kurt, Thanks Unfortunately this is not working Rgds B

Billybob73 · ‎02-02-2018

Hi, The & is the reason I'm using a %nrstr I've made some progress, but still not working unfo.. %let path=%nrstr(G:\TEST\R&D); options noxsync noxwait noxmin; x rd /S /Q "&path"; options xwait; something in the syntax is still not right........

Billybob73 · ‎02-02-2018

Hi, You're right about that. I've been assigned as sysadmin to get listings of files for our sas user community. I'm running this : %let path = %nrstr(G:\TEST\R&D); options noxwait ; x "rmdir &path. /s /q"; options xwait; Thanks

Billybob73 · ‎02-02-2018

I combined both, but there's still a problem that remains. Folders which did not have files in them were not deleted. General question : How can I delete empty folders with empty sub folders from SAS ? Is this possible ? I tried x commands but they don't work despite path authorization and XCMD switched on.

Billybob73 · ‎02-02-2018

I used these. Rather than x commands. Thanks !

Billybob73 · ‎02-02-2018

Hi, Is it possible to delete a complete folder with files in it with one singe statement ? Or do you first need to remove the files and then the folders ? Thanks B

Billybob73 · ‎02-01-2018

Hi, I have. For the moment I've skipped it. Luckily enough there was only 1 file 🙂 However, I think I need to build in something to prevent this specific file and similar files from being scanned for metadata. I should try to open it. If it can't be opened, it should be skipped. First thing that comes to mind is : %SYSFUNC(FOPEN(file ref)); Don't know if this works for datasets... but i 'll check.

Billybob73 · ‎02-01-2018

Hi Kurt, This is the way to do it ! Thanks !! Rgds B

Billybob73 · ‎02-01-2018

Hi I have a program that reads all metadata of all SAS datasets that reside in the network and the SAS server. The program automatically assigns libraries for all paths in which datasets have been stored. At the same time it reads the dataset properties in a step where dictionary.columns is used. This happens successfully, however I bumped into a corrupt dataset that cannot be opened and then below happens. Program stops with this error just for 1 dataset. How can I circumvent that ? Thanks! ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [SQL (2)] ERROR: Write Access Violation SQL (2) Exception occurred at (00D2968F) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 0000000000D2968F 000000000E20C960 tkmk:tkBoot+0x1794F 0000000000D278C0 000000000E20C9C0 tkmk:tkBoot+0x15B80 00000000022F5947 000000000E20C9C8 sashost:Main+0x1E4B7 000000000995BDF4 000000000E20CA58 sasyoio:tkvercn1+0x1ADB4

Billybob73 · ‎01-30-2018

Hi, I'm in a situation that I've thousands of SAS datasets scattered all over both the LAN and the SAS Server. These datasets are not necessarily in SAS libraries. Is there a way to get their metadata in a loop ? In a huge table I need information per dataset such as variable, type, length, varnum, format Thanks ! Regards B.

Billybob73 · ‎01-23-2018

Thanks Reeza!

Billybob73 · ‎01-23-2018

Thanks very much Chris !

Billybob73 · ‎01-23-2018

Hi, The outcome of my query should be the following : gender score outcome 1 48 1 1 48 1 1 45 2 1 56 3 2 50 1 2 50 1 2 41 2 2 51 3 This is my script : data students; input gender score ; cards; 1 48 1 48 1 45 1 56 2 50 2 50 2 41 2 51 ; run; I've tried this : proc sort data = students; by gender score; run; data students2; set students; by gender score; if (first.gender and first.score) then outcome + 1; run; But this is not the solution. Can anybody help out ? Thanks B

Billybob73 · ‎01-23-2018

Hi Chris, Thanks for sharing this. It appears we have M1. For Base SAS Software ... Custom version information: 9.4_M1 Image version information: 9.04.01M1P120413 It's a huge relief. For a moment I really thought I would go crazy 😉 Is there another way to get file details from files within zip files ? Thanks again ! Rgds B

Online Status	Offline
Date Last Visited	‎02-26-2023 07:47 AM

default maximalized pop up window SAS VA

drill down from visual SAS Visual analytics

Re: SAS VA hierarchy in report filter

SAS VA hierarchy in report filter

Error: Integration technologies failed to submit the code. Character s...

Get metadata info of a SAS DI Studio Job (jobs & tables)

iSAS stored proces web input form

How to zip a complete folder from SAS with 7Zip

zip with password from SAS

options sasautos does not work

Re: Proc Metadata to get Dependent Objects

Re: Local host in SAS Enterprise Guide standalone

Re: file properties of zip file members SAS

check if the contents of a variable is in another variable

Re: delete folders with files from SAS

Re: delete folders with files from SAS

Re: delete folders with files from SAS

Re: delete folders with files from SAS

Re: delete folders with files from SAS

delete folders with files from SAS

Re: Dictionary.columns useless for corrupt dataset

Re: Loop through thousands of SAS datasets for metadata

Dictionary.columns useless for corrupt dataset

Loop through thousands of SAS datasets for metadata

Re: combined counter for 2 variables

Re: combined counter for 2 variables

combined counter for 2 variables

Re: file properties of zip file members SAS