write to .csv file with flipped order

swimmer — Mon, 12 May 2014 19:00:08 GMT

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.

Re: write to .csv file with flipped order

ballardw — Mon, 12 May 2014 19:40:46 GMT

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.

topic write to .csv file with flipped order in SAS Programming

write to .csv file with flipped order

Re: write to .csv file with flipped order