write to .csv file with flipped order

Reply
Contributor
Posts: 36

write to .csv file with flipped order

Hi,

I have a dataset with 2 observations. I want to write them to a .csv file with the second observation first and the first observation second. E.g. my data looks like

var1   var2   var3   var4

b1     b2     b3      b4

a1    a2      a3      a4

I want my .csv looks like

a1,a2,a3,a4

b1,b2,b3,b4

I tried 'put' statement with _ALL_ instead of listing the variable names explicitly because there are thousands of variables, it writes 'var1=xxxxx   var2=xxxxx' which I don't like. I only want the values to be written in the .csv file.

Thank you very much for your help.

Super User
Posts: 10,490

Re: write to .csv file with flipped order

I would sort the data so that it is in the order you want and then try proc export.

If you want to reverse the order of the data set;

data want;

     set have;

     order= _n_;

run;

proc sort data=want out=sorted(drop=order); by descenting order; run;

then export to csv.

Ask a Question
Discussion stats
  • 1 reply
  • 131 views
  • 0 likes
  • 2 in conversation