Hi there,
I'm having an issue with a formatted put statement I'm using to write a csv file.
Basically I'm writing out a csv from a dataset.
I have a macro variable such as:
%let c = +(-1) ',';
and in my put statement I'm calling the following:
put myDateVar : yymmddS10. &c
someTxt1 &c
someTxt2 &c
etc etc..
It writes out the file fine but on one random row each time I run this it will cause an issue. In the middle of some variable it will restart the line..so row becomes mis-alligned and doesn't have the proper data and actually ends up with more data than it should. the log shows no error or warning message. This seems to happen on UNIX only. I run the exact same thing under windows and it works perfectly.
the output might look something like this for example:
2009/01/01,some text1,some text1
2009/01/02,some text2,some text2
2009/01/03,some text2009/01/03,some text3,some text3
2009/01/04,some text4,some text4
Has anyone ever seen anything like this before?
Thank you in advance!
Faisal