topic Re: change project.XML from SAS EG within SAS in SAS Programming

change project.XML from SAS EG within SAS

Billybob73 — Tue, 24 Apr 2018 07:29:15 GMT

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 !

Re: change project.XML from SAS EG within SAS

Kurt_Bremser — Tue, 24 Apr 2018 08:05:44 GMT

Use an advanced editor (notepad++, hex mode) to check the difference(s) between the manually edited XML file and the one edited with SAS.

Once we know the change induced by SAS, we can search for ways around it.

Re: change project.XML from SAS EG within SAS

ShenQicheng — Tue, 24 Apr 2018 08:52:42 GMT

Try this,

data programds1;
	infile "g:\mylocation\project.xml" encoding="utf-16";
	length progtext $32000;
	input;
	progtext = _infile_;
run;

and

data _null_;
	file "g:\mylocation\project.xml" encoding="utf-16";
	set work.programds1;
	put (progtext) (+(-1));
run;

Shen

Re: change project.XML from SAS EG within SAS

Billybob73 — Tue, 24 Apr 2018 11:13:32 GMT

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;

Re: change project.XML from SAS EG within SAS

Billybob73 — Tue, 24 Apr 2018 20:04:37 GMT

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

Re: change project.XML from SAS EG within SAS

ShenQicheng — Wed, 25 Apr 2018 00:02:54 GMT

@Billybob73 wrote:

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;

What is the purpose of this code? The usage of the unnamed pipe is not correct, I think.

If you want to read files in a zip file within SAS code, you can try FILENAME ZIP access method.

There are several blogs writen by Chris Hemedinger show how to use FILENAME ZIP access method.

Here are some URLs:

https://blogs.sas.com/content/sasdummy/2014/01/29/using-filename-zip/

https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/

Hope this helps.

Shen