Hi Reeza, sorry about that 'guys' statement.. it is a thing i always use. Consider it a statement of concatenation of boys and girls, though this is also not possible! 😉 As for the export: Just consider the 2 given columns in the picture and the 2 rows, which need to be exported like on the picture where it says WANT. That's what I want to do. What I do to get these kind of table is (very simplified now): I import 2 csv files. Do some sorting and selection on them by proc sort and proc sql. After that I get a table which I have to transpose (thus getting automatically num and char columns). Till then everything is going okay. So supose then this is a very simplified transposed table which I get, and which I can succesfully export to my excel sheet: data x;
infile datalines delimiter=',';
input source $10. value;
datalines;
D_RangeH, 10
D_RangeL, 9
;
run;
proc sort data=x;
by source descending value;
run;
proc export data=x outfile="p:\temp\test.xlsx" dbms=xlsx replace;
run;
No problems so far. But now, dear friends, what I want to do is concat the 2 rows D_RangeH 10 D_RangeL 9 To 1 Row, like this: D_RangeLH 9 - 10 But I really dont have a clue where to start.. So any help with this step would be nice. Thank you in advance. I hope you understand what I mean now. If not, let me know again.
... View more