cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Yura2301
‎01-28-2022
  • 179 Posts
  • 10 Likes Given
  • 0 Solutions
  • 5 Likes Received

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 08:56 AM
‎06-03-2014 08:56 AM
Hi Scott, Your macro looks like has more features, including one that I need, but guys here provide also solutions in one line, so I'll probably will go to study UNIX:) Thanks! ... View more

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 08:54 AM
‎06-03-2014 08:54 AM
Hi Kurt, yep, after a few tests it looks like this line solve the task, works quick and not demage any spec. character in file. Thanks! ... View more

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 08:49 AM
‎06-03-2014 08:49 AM
Hi Ksharp, I need to create code that will do it in loop for many files(>100 sas codes), so if VI editor is just similar to N++(maybe with more features) it anyway not ok due I need to apply changes to batch of files. Anyway thanks! ... View more

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 07:14 AM
‎06-03-2014 07:14 AM
Hi Jaap, As I replied to Kurt - I split tasks related to file manipulations on two parts - simple and complicated, simple task I implement using SAS functions etc., complicated - using X command, bat files, vbs scripts etc. But innitially I supposed that this concrette task belongs to simper part, du it just replace one word to another in file, but now I'm not sure that I was right, suppose will really need use some unix commands better. Thanks! ... View more

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 07:10 AM
‎06-03-2014 07:10 AM
Hi Kurt, Company is moving from Windows to AIX, so I'm new in UNIX. Offcource SAS isn't best tool for seriosu file manipulations but if the goal is more-less simple why not use SAS? On Windows I used VBS scripts+X command when I need to made some serious code related with file system etc., but when I had to just copy/rename etc. file I think SAS can be used. I supposed that replace one word to another in file and save previous file formatting is belong to those "easier" part of tasks, but suppsoe I was wrong due all replier here advise rid of SAS for this task. Anyway thanks. ... View more

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 05:30 AM
‎06-03-2014 05:30 AM
Ok, clear. So I have variant of implementation without SAS, that is nice but I still hope that maybe there is some SAS way, maybe some cool option that I just need to put in my macro and everything will work correctly:) Thanks! ... View more

Re: Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 05:20 AM
‎06-03-2014 05:20 AM
Hi Rw9, Not sure if VBA will work under AIX(on Windows it works for sure). I also not sure if I'll be able to install that enchanced tool for texts formatting, due security reasons:) But anyway thanks, will take a look for that text tool that you propose. ... View more

Replace in file, universal solution.

by Quartz | Level 8 in SAS Programming
‎06-03-2014 04:56 AM
‎06-03-2014 04:56 AM
Hi all, I would like to create some macro that will replace any string in input file(actually formatted file with sas code) to any other string. I quickly created small code that ,as I thought initially,will solve the task. %macro replaceInFile(inFileName,outFileName,from,to);       data _null_;             length str strNew $32767;             infile &inFileName dsd dlm='0D'x lrecl=32767;             input str;             strNew=tranwrd(str,"&from","&to");             file &outFileName lrecl=32767;                  put strNew;       run; %mend replaceInFile; The macro simply use/in out filenames to read one file and create copy of it with replace strings. Replace I made usingt tranwrd function, and it works ok  - in new file all strings that had to be replaced were actually replaced. But during further tests I experienced another issues - for some files disappears formtting(start spaces or tabs) and also character ' in some cases also disppear in new file. In attached file is example of such cases. If you'll execute that macro for this file - new output file will looks like nigtmare - no formatting, char ' disappears for some expressions etc. So now I hesitate if it's possible to create some general universal solution for such goals. Maybe there are some ready smarter approaches for such cases? Thanks! ... View more

Re: Mask Unicode: 0x1a character.

by Quartz | Level 8 in SAS Programming
‎03-24-2014 10:19 AM
‎03-24-2014 10:19 AM
Hi Tom, It was my initial idea, but the problem isn't so obvious probably. I have small SAS table with ~20 rows. When I send whole this table - issue occurs. When I eliminate one row - issue doesn't occurs, but then, if I resend this one row - issue also doesn't occurs. This character probably isn't visible: http://www.utf8-chartable.de/unicode-utf8-table.pl?utf8=0x And I can't just visually separate it in data. I'm actually a little bit confused why the issue is happend and if this spec character at all is in SAS data, maybe it occurs on stage when SAS create XML from SAS table. I also tried to find this char directly in XML file via n++, but can't see it also. Thanks! ... View more

Mask Unicode: 0x1a character.

by Quartz | Level 8 in SAS Programming
‎03-24-2014 09:47 AM
‎03-24-2014 09:47 AM
Hi all, Have issue with XML created from SAS , will be appreciate for any help. So I create XML from SAS using standard libname engine: filename &filLibName "...temp.xml" ;       LIBNAME &filLibName XML  XMLTYPE=GENERIC ;       data &filLibName..TEST_XML;          set TEST_DATA;       run; Then XML goes to validation on java side.For majority of data validation pass ok, without issue,but for some set of data issue occurs, and XML rejects with reason: An invalid XML character (Unicode: 0x1a) was found in the element content of the document. It looks like some invalid character come with SAS data and java validation tool reject XML due this character. XML should be in UNICODE format so I tried to changed libname to : LIBNAME &filLibName XML  XMLTYPE=GENERIC XMLENCODING='utf8'; And this step changed XML header to: .<?xml version="1.0" encoding="utf-8" ?> Some special character occurs before first tag and it again crashed validation on java side, so I changed it in code(just hardcoding), so XML header after this looks like: <?xml version="1.0" encoding="utf-8" ?> But the problem still exists, XML message still rejects with same error. I browsed and found that java developers fixed this issue simply by replacing this char to another allowed character: http://stackoverflow.com/questions/8505816/streamexception-an-invalid-xml-character-unicode-0x1a It's also ok for me, but I should realize it on SAS and I actually can't find this character in SAS table,so queston is if there are some smart way to search and replace this symbol in SAS data? Maybe there are also some way to predict similar issues?I supposed enough should be set option  XMLENCODING='utf8' to libname, but as I experienced it's not enough. I'm using SAS 9.1.3. Thanks! ... View more

Re: Proc template can handle next case?

by Quartz | Level 8 in SAS Procedures
‎01-03-2014 04:00 PM
‎01-03-2014 04:00 PM
Hi Vince, Actually when I read documentations about proc template I also had similar feeling about it, but I've just spent hour on briefly overview proc template possibilities so I couldn't be sure that it can't easily handle my task, that's why I actually asked for help here. So, if not only me considered that for this task data step is probably ok solution for SAS 9.1.3 - I'll choose this variant:) Thanks one more time for quick and clever feedback's! ... View more

Re: Proc template can handle next case?

by Quartz | Level 8 in SAS Procedures
‎01-02-2014 10:33 AM
‎01-02-2014 10:33 AM
Hi again, I've just tried and as I wrote higher there is a problem related with the fact that I'm using older version of SAS(SAS 9.1.3), there is no XML92 engine and error throws to the log file: ERROR: The XML92 engine cannot be found. ERROR: Error in the LIBNAME statement. But in general I reviewed XML map and SAS code that you've made and it actually exactly what I need and expect, but I use SAS 9.1.3 and need some workaround, I tried replace XML92 to XML but another message was throwed to the log: ERROR: XMLMap= has been specified on the XML Libname assignment. The output produced via this option will change in upcoming        releases. Correct the XML Libname(remove XMLMap= option) and resubmit. Output generation aborted. So ,as you mentioned on your post, your solution works but only starting from SAS 9.2. I can probably initially load simple XML from SAS table, then made XML map similarly as you did and query this initial XML using this XML map with XPATH, but it's not optimal, in this case I'll make in fact two path throw the same data, that can make some performance issue(source table is huge and result XML will have a few hundreds mb.). Anyway thanks! ... View more

Re: Proc template can handle next case?

by Quartz | Level 8 in SAS Procedures
‎01-02-2014 10:18 AM
‎01-02-2014 10:18 AM
Hi Vince, Thanks for your efforts, I'll try it tommorow. You mentioned that example that you provided made on SAS 9.2, but I'm actually working on SAS 9.1.3, that probably can cause some issue. But before I made XML maps for querying XMLs loaded by proc metadata so XPATH and XML maps also works on SAS 9.1.3 but offcource can be some difference. I'll back when will have some results. Thanks one more time! ... View more

Re: Proc template can handle next case?

by Quartz | Level 8 in SAS Procedures
‎01-02-2014 04:49 AM
‎01-02-2014 04:49 AM
Hi Vince, You are absolutely right about XML tag naming, I've just accidentally made mistake when trying quickly write example of XML in Data step.I've fixed example data step and result XML in my initial post. Each SAS table record should be enclosed in separate tag similarly as you described in your post: <RECORD instance=1>subtags</RECORD> <RECORD instance=2>subtags</RECORD> ... <RECORD instance=3>subtags</RECORD> And source table columns are divided on two parts, first should be enclosed  in <table1> </table1> tags, and  rest columns(second subset ) should be enclosd in <table2> </table2> tags. Thanks! ... View more

Re: Proc template can handle next case?

by Quartz | Level 8 in SAS Procedures
‎01-02-2014 04:40 AM
‎01-02-2014 04:40 AM
Hi Cynthia, Thanks for reply, can you please describe what you mean about SAS XML limitation("one table in, one table out)? In my case I have only one input table, and for each row(that is enclosed in separate tag) first subset of table columns should be enclosed in <table1> </table1> tags, and  rest columns(second subset ) should be enclosd in <table2> </table2> tags. I just wonted to know some best practice in creating such type of XML from SAS data set, becouse I've created such XML for a few minutes using data step (example in post higher) and it ganarates quickly but I feel that it's not right way to form the XML, it has more-less simple structure and probably should be some simple way to also create it using proc template or smth. else, but I didn't succeed in it after brief read proc template functionality. Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-28-2022 05:12 AM
Likes given to
Likes from
View All
Quick links