About Billybob73

Billybob73 · ‎02-13-2019

Hi, I'd like to add column3. How do I do that in SAS ? No sorting on column 2 ! It needs to be in the exact same order as below. Can this be done in an SQL statement too ? If so , how ? Thanks for your help !! Rgds B COLUMN1 COLUMN2 COLUMN3 A ABC 1 A ABC 1 A DEF 2 A DEF 2 A DEF 2 A DEF 2 A GHI 3 A GHI 3 A GHI 3 A GHI 3 A ABC 4 A JKL 5 A JKL 5 A JKL 5 A JKL 5

Billybob73 · ‎12-06-2018

Hi, I wonder if it's possible to create a zip file with a password on a SAS Linux server. Right now I have a process that first creates a CSV file on the SAS Linux server, then zips it and then sends it automatically to an e-mail receiver. This process works and I'm satisfied about. However, my company requires me to password protect the ZIP file ? I know how this works on a SAS Windows server, but no idea how this works on UNIX / Linux. Anybody ? Thanks !! Regards Billy

Billybob73 · ‎04-24-2018

Another thing...although I was able to succesfully manipulate the project.xml file the results DO NOT show in the code that was in my EG. In the EGP was a non-embedded program (one that was saved to a network location). I made a change to a libname path, but although it was changed in the project.xml file the results did not show in the programs within the EGP project. Is there anything I forgot ? Thanks Rgds B

Billybob73 · ‎04-24-2018

Shen / Kurt, This is it ! By default it encodes to ANSI. with this option to utf 16. Why does this not work when I tried this ? filename zip pipe "zip %superq(zipmap)\&zipfile %superq(zipmap)\*"; data _null_; infile zip encoding="utf-16"; input; put _infile_; run;

Billybob73 · ‎04-24-2018

Hi, As you will know when unzipping an EGP file you get a project.xml file. When I change this project.xml file in Windows explorer and then zip it again to an EGP file the EGP file opens perfectly in SAS. However...........when I read project.xml file in SAS, do the same change in SAS, then write a dataset with the change as project.xml file to the network, rezip again to EGP, SAS Enterprise Guide won't open the file! (message : There was an error reading the project file , the format is invalid or not correct). This is the code I use to read : data programds1; infile "g:\mylocation\project.xml" ; length progtext $32000; input; progtext = _infile_; run; This is the code I use to write : data _null_; file "g:\mylocation\project.xml"; set work.programds1; put (progtext) (+(-1)); run; I'm using SAS EG 6.1 64bits. Thanks ! B

Billybob73 · ‎04-23-2018

Hi Kurt, Thanks for this ! This code is reading into the sas dataset with the blanks included, which is good ! What if I changed some code in the resulting SAS dataset and then re-export it as a txt file. How would i get the blanks again in the TXT file ? I presume this is what is blocking the opening of the XML file. I'm getting everything left aligned......... No luck with this : data _null_; file &filename.; set work.programds2; put (progtext) (+(-1)); run; Thanks! B

Billybob73 · ‎04-23-2018

The solution lies in how to read a txt file keeping every single line in a dataset record. For instance if I have this : </SubmitableElement> <CodeTask> <IncludeWrapper>True</IncludeWrapper> <Embedded>False</Embedded> <DNA><DNA> <Type>LocalFile</Type> <Name>testprog13_met_EURTLD.sas</Name> <Version>0</Version> <Assembly /> <Factory /> How to make sure that read them into a dataset containing 10 records ? At the moment I'm not reading correctly. This line : <?xml version="1.0" encoding="utf-16"?> is converted to <?xml Can't figure out why.. Rgds B

Billybob73 · ‎04-23-2018

It's not because I forgot to re-include the result.txt file in the EGP, so I notice. Something is wrong about this code. After renaming the XML extension to TXT i perform the following. Apperently re-exporting this as TXT file and the renaming it to XML causes the XML file to be corrupt. Not sure how to proceed now.... %macro changeprog (mysourcefolder, mysourceprog, olditem1, newitem1, olditem2, newitem2, mydestfile, mydestfolder); data programds1; infile "&mysourcefolder.\&mysourceprog." dlm = ';'; length progtext $ 30000 ; input progtext; run; data programds2; set programds1; progtext = tranwrd(progtext,"&olditem1.","&newitem1."); progtext = tranwrd(progtext,"&olditem2.","&newitem2."); run; %let newdir = %sysfunc(dcreate(&datum ,&mydestfolder.\)); %let filename= "&mydestfolder.\&datum.\&mydestfile..txt"; data _null_; file &filename.; set work.programds2; put (progtext) (+(-1)); run; %mend;

Billybob73 · ‎04-23-2018

Hi Kurt, This sounds like a great idea, however when - I treat is as txt - then change something in the txt - then rename it back to XML - then zip the XML file - then rename the zip file to an egp file the EGP project won't open...... EG says : There was an error reading the project file. The format is invalid or not correct. Now when i unpacked the EGP file, there was also a "result.txt" file. Should I also involve this one again ? Thanks B

Billybob73 · ‎04-23-2018

Hi, I have over a 1000 EGP files and i want to change a minor thing in 1 particular program that is part of the EGP project. Every single one of them needs to be changed, so a 1000 changes. I took the following steps so far : 1. Convert EGP to ZIP 2. Unzip the file After action number 2. i have a project.XML file which I was hoping to import into SAS and then do the conversion and then output it again to XML, rezip it and then rename it to EGP. However reading in this XML file gives an error message : libname local "g:\mylocation"; LIBNAME xmlfile xmlv2 'g:\mylocation\project.xml' XMLTYPE=GENERIC;; DATA local.project; SET xmlfile.project; RUN; ERROR: PCDATA content found outside column/table boundary. content is false. ERROR: XML data is not in a format supported natively by the XML libname engine. Files of this type may require an XMLMap to be input properly. 2 questions : 1. Is my method right ? 2. Why can't i read the XML file ? Thanks for your help !! Rgds B

Billybob73 · ‎03-20-2018

Hi, I'm looking for a way to only delete folders (and sub folders) which do not contain any files. For example let's say that c:\2013 (and all of its underlying folders and files) do not contain any files, just folders, how can I get rid of c:\2013 as a whole ? c:\2012 and c:\2014 should remain just like they are. Situation before deleting empty folders c:\2012 c:\2013 c:\2014 Situation after deleting folders c:\2012 c:\2014 Thanks B

Billybob73 · ‎03-08-2018

Hi, I'd like to convert the macro variable sasdate to date9. format, but I can't get this to work. I get the message below and i don't know what this message means. Anyone ? Thanks very much ! 21 %let sasdate=%sysfunc(intnx(year,%sysfunc(today()),0)); 22 %let otherdate = %sysfunc(INPUTN(&sasdate., YYMMDD8.), date9.); WARNING: Argument 1 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.

Billybob73 · ‎03-05-2018

Hi RW9, This is it ! Thanks ! I noted my predecessor had set the options nosource somewhere.

Billybob73 · ‎03-05-2018

Hi, Sometimes, and I do not know for what reason, it seems my sas log only shows the notes that are generated because I run something. For instance, I'm running this : data test; i=1; run; And I get this in the log : 1 The SAS System 09:01 Monday, March 5, 2018 NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR NOTE: Compression was disabled for data set WORK.TEST because compression overhead would increase the size of the data set. NOTE: The data set WORK.TEST has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Which option do I need to (re)set to also get the datastep in the log ? Thanks B

Billybob73 · ‎03-01-2018

Hi, Just managed to find solution below. The -p parameter did work though, Dave 😉 Thanks everybody x "cd c:\temp\test"; filename zip pipe "zip -r -p split.zip * " ; data _null_; infile zip; input; put _infile_; run; Regards 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

grouped ascending sorting

zip file with password SAS Linux server

Re: change project.XML from SAS EG within SAS

Re: change project.XML from SAS EG within SAS

change project.XML from SAS EG within SAS

Re: Read XML URL from SAS EG

Re: Read XML URL from SAS EG

Re: Read XML URL from SAS EG

Re: Read XML URL from SAS EG

Read XML URL from SAS EG

deleting empty folders

sysfunc to convert SAS date does not work

Re: SAS Log only shows NOTES

SAS Log only shows NOTES

Re: filename zip pipe wrong target path is used