topic XML output Using Customized Tagset in ODS and Base Reporting

XML output Using Customized Tagset

hari1109 — Fri, 10 Jun 2011 22:11:24 GMT

Hi all,

Thank you in Advance.
I am ceating a customized tagset to generate xml output which is as follows

In the above code Object count = 1 i am using a default value 1 for the row count, i tried to increment the count value other than the default value but it didn't work.
I am using the below proc template to generate the above xml :
Further is there any way to reference the destination file path in the xml.

Re: XML output Using Customized Tagset

hari1109 — Fri, 10 Jun 2011 22:11:49 GMT

code i am using to generate xml :

define event EmitMeta;
start:
put '<' $LIBRARYNAME '>' CR CR ;
putq '<' "Header Version =" '"' 1.0 '"' ' ' "Datecreated=" DATE ' ' "Timecreated=" TIME ' ' "Author=" AUTHOR "Comments=" nl nl;
putq '<' "Knowledgeobjects count=" '"' 1 '"' '>' nl;
put ' ' '<' "Knowledgeobjects" '>' nl ;
put ' ' '<' "KnowledgeDocuments Count=" '"' 1 '"' '>' nl;
putq ' ' '<' "Knowledge Document Doc Ref=" nl;
put ' ' '' nl nl;
break;
finish:
put ' ' '' nl ;
put ' ' '' nl ;
put '' ;
break;
end;

define event EmitRow;
ndent;
putq '' nl ;
ndent;

eval $index 1;
iterate $col_names ;
do /while _value_;
set $name _value_ ; trigger EmitCol;
next $col_names;
eval $index $index+1;
done;

xdent;
put "" nl nl;
xdent;
break;
end;

define event EmitCol;
unset $value;
set $value $col_values[$name];
putq '' nl ;
break;
end;

Thank you.

Re: XML output Using Customized Tagset

Cynthia_sas — Sat, 11 Jun 2011 02:55:52 GMT

Hi:
I am guessing that the code snippet we see is not the complete code you are using. When any code you post has < or > symbols, the forum posting software frequently truncates the post because it tries to interpret the < and > as HTML tags.

The way around it is to use < or > (ampersand-lt-semicolon or ampersand-gt-semicolon) for purposes of posting the code.

However, before you go to all that effort to modify your code, your best bet is to open a ticket with Tech Support and provide them information or code about:
1) how are you invoking the tagset template: SAS XML Libname Engine or as ODS TAGSETS.?????? invocation. The method by which you invoke the tagset template does make a difference because the events could be different if generated for procedure output versus generated for data.

2) provide them with a sample copy of the SAS data set which is input to your process

3) provide them with a good copy of the XML you need to replicate

4) provide them the code you plan/want to use to invoke the tagset template.

I believe the solution for the counter issue will depend on how your count gets incremented. It will depend on where the incrementing is happening - -if it happens within the tagset template process, then you will need an event to trigger the incrementing of the variable. If it happens within a DATA step program, then you will likely need to retain the counter variable across iterations of the DATA step.

Tech Support is your best resource for help on this front.

cynthia