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

Proc template can handle next case?

by Quartz | Level 8 in SAS Procedures
‎12-31-2013 05:15 AM
‎12-31-2013 05:15 AM
Hi , I need to create XML document from SAS data step,this XML should have simple structure: <Table>     <RECORD id=1>         <Table1>                //columns tegs1         </Table1>         <Table2>              //columns tegs2         </Table2>     </RECORD>     <RECORD id=2>         <Table1>             //columns tegs1         </Table1>         <Table2>              //columns tegs2         </Table2>     </RECORD> ... </Table> and it can be easy build by hard coding tags in data step: filename out '...result.xml'; data _null_;     set sashelp.class end=last;     file out;     if _N_=1 then do;         put '<Table>';     end;     str=catt('    <RECORD id=',_N_,'>');put str;         put '        <Table1>';             str=catt('            <Name>',Name,'</Name>'); put str;             str=catt('            <Sex>',Sex,'</Sex>'); put str;                    put '        </Table1>';         put '        <Table2>';             str=catt('            <Age>',Age,'</Age>'); put str;             str=catt('            <Height>',Height,'</Height>'); put str;                str=catt('            <Weight>',Weight,'</Weight>'); put str;                        put '        </Table2>';         put'    </RECORD>';     if last then do;         put '</Table>';     end; run; : So result XML should looks like <Table>     <RECORD id=1>         <Table1>             <Name>Alfred</Name>             <Sex>M</Sex>         </Table1>         <Table2>             <Age>14</Age>             <Height>69</Height>             <Weight>112.5</Weight>         </Table2>     </RECORD>     <RECORD id=2>         <Table1>             <Name>Alice</Name>             <Sex>F</Sex>         </Table1>         <Table2>             <Age>13</Age>             <Height>56.5</Height>             <Weight>84</Weight>         </Table2>     </RECORD> ... </Table> I briefly read about proc template and XML and I found out that it had some issues with grouping etc., so I have small doubds that I whould be able build next XML via it,so my question is if proc template can build next XML, and if yes, if this functionality will work fuster then data step works. Real source table will have more then 100 columns and thousandth of records, so speed of work is very important. Thanks! ... View more

Re: ARM logs miss general records(I,E,G)

by Quartz | Level 8 in SAS Data Management
‎12-16-2013 03:39 AM
‎12-16-2013 03:39 AM
Hi Fried, Thanks, now ARM facility works correct:). ... View more

Re: ARM logging

by Quartz | Level 8 in SAS Programming
‎12-04-2013 04:49 AM
‎12-04-2013 04:49 AM
Hi, I've already implemented such solution on SAS 9.1 and actually work on making it works on SAS 9.3, if you still need it I'll provide you with some helpful info. ... View more

ARM logs miss general records(I,E,G)

by Quartz | Level 8 in SAS Data Management
‎12-04-2013 04:37 AM
‎12-04-2013 04:37 AM
Hi, Small code below (with ARM options) works correct on SAS 9.1 on Window OS:       /*Force ARM logs writes to file on server*/       filename armLog "...\ARM.log";       option  armloc=armLog;       /* Needed only general info = start/end of whole SAS code, start/end of each data step and procedure*/       option  armsubsys=(ARM_DSIO OPENCLOSE , ARM_PROC);             /*start SAS code*/             data test1;                   sl=sleep(3,1);             run;             data test1;                   sl=sleep(5,1);             run;             /*End SAS code*/             /*Redirect ARM logs into temporary work file*/       filename LogEND "...\ARM_end.log";             options armsubsys=(ARM_NONE) armLoc=LogEND; So SAS code higher ganarate expected result(ARM log) on SAS 9.1: I,1701768346.106000,4,29.296875,9.390625,SAS,userKode G,1701768346.106000,4,7,MVA_DSIO.OPEN_CLOSE,DATA SET OPEN/CLOSE,LIBNAME,ShortStr,MEMTYPE,ShortStr,MEMNAME,LongStr G,1701768346.106000,4,8,PROCEDURE,PROC START/STOP,PROC NAME,ShortStr S,1701768346.106000,4,8,21,29.296875,9.390625,DATASTEP S,1701768346.106000,4,7,22,29.296875,9.390625,WORK    ,DATA    ,TEST1                       P,1701768349.106000,4,7,22,29.296875,9.390625,0,WORK    ,DATA    ,TEST1                       P,1701768349.106000,4,8,21,29.296875,9.390625,0 S,1701768349.106000,4,8,23,29.296875,9.390625,DATASTEP S,1701768349.106000,4,7,24,29.296875,9.390625,WORK    ,DATA    ,TEST1                       P,1701768354.106000,4,7,24,29.296875,9.390625,0,WORK    ,DATA    ,TEST1                       P,1701768354.106000,4,8,23,29.296875,9.390625,0 E,1701768354.106000,4,29.296875,9.390625 But on SAS 9.3(AIX OS) results are different, general records("I" - initialization,"G"-GetId,"E"-End), are missed in result ARM file so ARM log on SAS 9.3 looks like: S,1701768346.106000,4,8,21,29.296875,9.390625,DATASTEP S,1701768346.106000,4,7,22,29.296875,9.390625,WORK    ,DATA    ,TEST1                       P,1701768349.106000,4,7,22,29.296875,9.390625,0,WORK    ,DATA    ,TEST1                       P,1701768349.106000,4,8,21,29.296875,9.390625,0 S,1701768349.106000,4,8,23,29.296875,9.390625,DATASTEP S,1701768349.106000,4,7,24,29.296875,9.390625,WORK    ,DATA    ,TEST1                       P,1701768354.106000,4,7,24,29.296875,9.390625,0,WORK    ,DATA    ,TEST1                       P,1701768354.106000,4,8,23,29.296875,9.390625,0 So can someone help me with delivering these general records into ARM log on SAS 9.3? Additional info: If run SAS code above first time on 9.3(first time after SAS session creation) - ARM log file miss only last "E" row, all rest needed row occurs in ARM log file: I,1701768346.106000,4,29.296875,9.390625,SAS,userKode G,1701768346.106000,4,7,MVA_DSIO.OPEN_CLOSE,DATA SET OPEN/CLOSE,LIBNAME,ShortStr,MEMTYPE,ShortStr,MEMNAME,LongStr G,1701768346.106000,4,8,PROCEDURE,PROC START/STOP,PROC NAME,ShortStr S,1701768346.106000,4,8,21,29.296875,9.390625,DATASTEP S,1701768346.106000,4,7,22,29.296875,9.390625,WORK    ,DATA    ,TEST1                       P,1701768349.106000,4,7,22,29.296875,9.390625,0,WORK    ,DATA    ,TEST1                       P,1701768349.106000,4,8,21,29.296875,9.390625,0 S,1701768349.106000,4,8,23,29.296875,9.390625,DATASTEP S,1701768349.106000,4,7,24,29.296875,9.390625,WORK    ,DATA    ,TEST1                       P,1701768354.106000,4,7,24,29.296875,9.390625,0,WORK    ,DATA    ,TEST1                       P,1701768354.106000,4,8,23,29.296875,9.390625,0 Next time when I run same code  - ARM log file again miss all general records -initial ("I", "G") and last "E" record. It probably means that on SAS 9.3 ARM logging don't finish(turn-off) correctly after setting options below: options armsubsys=(ARM_NONE) armLoc=LogEND; or options armsubsys=(ARM_NONE) armloc="_NULL_"; May be some additional options should be set to close it correctly? Thanks! ... View more

Re: DB2 to SAS appending issue. Retriview DB2 session log file.

by Quartz | Level 8 in SAS Programming
‎08-08-2013 07:03 AM
‎08-08-2013 07:03 AM
Hi Jaap, I still use SAS 9.1.3, your remark regarding numeric columns with many digits looks like possible reason of the issue... Now I'll working on script that will automatically find column in SAS dataset that has value biggest then maximal allowed for needed DB2 datatype(decimal, smallint etc.). Thanks for help! ... View more

Re: DB2 to SAS appending issue. Retriview DB2 session log file.

by Quartz | Level 8 in SAS Programming
‎08-08-2013 05:13 AM
‎08-08-2013 05:13 AM
Hi Linus, Thanks for the answer:)... DB2 DBA is on long vacation:) I've just made small script that replace all numeric values in table by "1" value, and tried append the test data to DB2 table - same error... I thought I'll simply exclude statements : "numColName=1;" from the script and in such way will define needed column, but looks like issue isn't so obvious as I thought...May be there are some problem with nulls,date(datetime) columns also... Will look deeper to the issue...I just feel that I spend time on things that can be done more efficient, but I'm not sure:) ... View more

DB2 to SAS appending issue. Retriview DB2 session log file.

by Quartz | Level 8 in SAS Programming
‎08-08-2013 04:59 AM
‎08-08-2013 04:59 AM
Hi, So I try to append SAS data set with a  lot of columns(~100) to DB2 table: LIBNAME db2Lib DB2  DBCOMMIT=10000  ...; proc append base=db2Lib.db2Tab data= SASData; run; For some portion of SAS data append works ok and add needed data to DB2 table, but for another portion - it failed with CLI error: ERROR: CLI execute error: [IBM][CLI Driver] CLI0111E  Numeric value out of range. SQLSTATE=22003 In SAS log file no info in what exact numeric column issue happened, I also don't like idea sequentially append separate columns for finding  needed one... On DB2 forums I found that the columns can be easy detected from DB2 session log, but I haven't appropriate rights for accessing DB2 log file, all what I can do - it's query(or insert,update) DB2 table from SAS. So if there are some smart way for detecting the column  in which similar issue happened? May be there is possibility somehow direct DB2 log into some SAS server folder etc.? I tried sastrace option but it didn't helped... Thanks! ... View more

Re: ODS PDF.Hide links.

by Quartz | Level 8 in ODS and Base Reporting
‎05-21-2013 04:06 AM
‎05-21-2013 04:06 AM
Hi Cynthia, Regarding small issue in examples in my code-yes, you are right, LNK should be replaced to Path etc., I just accidentally put wrote column names when typed second example. And your example is exactly what I need:) Thanks! ... View more

ODS PDF.Hide links.

by Quartz | Level 8 in ODS and Base Reporting
‎05-20-2013 10:36 AM
‎05-20-2013 10:36 AM
Hi all, In ods html very easy hide link under some short label: data input;     length pgmfield $500;     name="name1";     pgmfield= '<a href=http://translate.google.com/>'||name||'</a>';     output;     name="name2";     pgmfield= '<a href=http://google.com/>'||name||'</a>';     output;     name="name3";     pgmfield= '<a href=\\C:\...\test.docx>'||name||'</a>';     output; run; proc report data = input; column  name pgmfield; define name/   noprint; define pgmfield/' link_text'; run; I need make the same in pdf, so in pdf document create link also possible: data input;     length lnk pgmfield $500;     name="name1";     path="http://translate.google.com";     output;     name="name2";     path="\\C...\test.docx>";     output;     name="name3";     path="http://translate.google.com/";     output; run; ods pdf file='...test.pdf'; proc report data = input; column   name path ; define name/   noprint; define lnk/' lnk '; compute path;         Call Define(_col_,'Url',path); endcomp; run; ods pdf close; But how to hide full url(or path to some file) under short name(label) as it was in first example(ods html)? Thanks! ... View more

Re: ODS tagsets.htmlpanel. Is it possible convert Proc gplot Graphic t...

by Quartz | Level 8 in Graphics Programming
‎04-10-2013 09:25 AM
‎04-10-2013 09:25 AM
Hi Again, I fixed the problem using ODS options path and file, also I made small corrections of target html file afterwords(Firefox form path to image differ than IE), -replace absolute path to png image to relative ... src="gplot.png". Thanks! ... View more

Re: ODS tagsets.htmlpanel. Is it possible convert Proc gplot Graphic t...

by Quartz | Level 8 in Graphics Programming
‎04-10-2013 08:39 AM
‎04-10-2013 08:39 AM
Hi again, Actually this SAS code will run in STP session, so I'll be able use _webout instead of hardcoded html file on server, but I've just checked and looks like problem still actual... Strange that png file with Chart stores in different folder that I set in body option of ODS statement. But anyway, thanks for help:)! ... View more

Re: ODS tagsets.htmlpanel. Is it possible convert Proc gplot Graphic t...

by Quartz | Level 8 in Graphics Programming
‎04-10-2013 08:29 AM
‎04-10-2013 08:29 AM
Hi Robert, Thanks for your advice, In my example I put png device as one of ODS option, but looks like I should initialize device option in goption statement. So now in EG it works correct but when I try open it manually from server - Chart isn't presented there, becouse Chart image stored in EG SAS work session instead of folder on server that I mentioned in ODS body option... So I will try to redirect(or just copy) chart image from WORK library to needed folder on server, or may be there are some better solution? Thanks! ... View more

ODS tagsets.htmlpanel. Is it possible convert Proc gplot Graphic to im...

by Quartz | Level 8 in Graphics Programming
‎04-10-2013 07:57 AM
‎04-10-2013 07:57 AM
Hi, below is simple example of proc gplot that finally create html file test.html on some folder on server: ODS tagsets.htmlpanel device=png body="...test.html"; proc gplot data=sashelp.class;      plot height*weight / vaxis=axis1;      axis1 label=(angle=90 "please change angle"); run; ODS tagsets.htmlpanel close; Graphic in html file is correctly presented only in IE browser, because ActiveX is mandatory for Charts representing. But I'd like to open the Chart in Firefox, for example. So can I somehow convert this graphic(chart) to Image(png,gif) on fly, to make it possible see the Chart image in Firefox?Probably should be applied some ods options etc... Thanks! ... View more

Re: Mark specific graph Node in proc GPLOT?

by Quartz | Level 8 in Graphics Programming
‎03-19-2013 10:30 AM
‎03-19-2013 10:30 AM
Hi Anca, It's exactly what I need, thanks! ... View more

Mark specific graph Node in proc GPLOT?

by Quartz | Level 8 in Graphics Programming
‎03-19-2013 10:07 AM
‎03-19-2013 10:07 AM
Hi, I'm new in SAS/GRAPH facility so I need small help with simple SAS graph: DATA: Date:          Time: 05.02.2013 10:01:29 14.02.2013 11:02:01 25.02.2013 10:10:16 03.03.2013 10:24:08 18.03.2013 9:27:40 18.03.2013 9:56:19 18.03.2013 12:18:50 01.04.2013 11:02:41 SAS code:       symbol1 ci=Blue c=Red i=join v=dot  l=1 w=2;       proc gplot data=&InTable;             plot startTime*startDate=1/ AUTOHREF  AUTOVREF;       run; Result Graph in attached image. So what I need is just mark last Graph node in Bold(or in another color etc.) else I'd like automatically add some label to this last Graph node , this label will have concattenated Date and Time value:"01.04.2013 11:02:41" 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