Blanks after variable in Output to XML file

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

Blanks after variable in Output to XML file

Im having a small issue creating an XML output.

Each variable in my put statement, generates and blank after it (which it shouldnt!).

Heres a small sample code:

data _null_;

set step2 end=eof;

output;

file  'c:\Data.xml';

if _n_=1 then do;

  put '<chart>';

end;

  put '<set label="'visityearweek'" value="'count'"/>';  <----- PROBLEM!

if (eof=1) then do;

  put '</chart>';

end;

run;

Current output:

<set label="2014-04 " value="2839 "/> <--- BLANKS after var..!

<set label="2014-05 " value="3232 "/>

<set label="2014-06 " value="2433 "/>

Anyone got an idea why this occurs? (i have tried to compress/strip the variables first without luck, theres no blanks in data).

Best

Kasper


Accepted Solutions
Solution
‎05-21-2014 07:43 AM
Super Contributor
Posts: 644

Re: Blanks after variable in Output to XML file

Try

put '<set label="'visityearweek+(-1)'" value="'count+(-1)'"/>';


Richard

View solution in original post


All Replies
Contributor
Posts: 29

Re: Blanks after variable in Output to XML file

Issue not resolved.

Solution
‎05-21-2014 07:43 AM
Super Contributor
Posts: 644

Re: Blanks after variable in Output to XML file

Try

put '<set label="'visityearweek+(-1)'" value="'count+(-1)'"/>';


Richard

Contributor
Posts: 29

Re: Blanks after variable in Output to XML file

Thanks - thats the (though its not logic why needed) solution.

Super Contributor
Posts: 644

Re: Blanks after variable in Output to XML file

The put statement by default adds a delimiting space at the end of each variable printed so list output does not run everything together. 

In this context the + is a pointer control, so +9 would move the pointer (the next printing position) 9 spaces further. 

There is no '-' pointer control so if you need to move back one space you need to advance the pointer control by (-1).

An alternative would be to place your text and values explicitly using the @ pointer, but you might have to calculate the length of the count variable each time.

Richard

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 210 views
  • 0 likes
  • 2 in conversation