how to export to a csv with an additional row header in SAS EG 4.2

[YW_CA]

I need to export a dataset adding an additional row to the data (csv file). For example, the dataset looks like this

ITEM, PRICE

AB, $50

CD, $40

I want to export the dataset with an additional row before the heading, so it will like:

purchaselist,,

item, price

AB,$50

CD,$40

is there a way to do this?

Thank you.

[art297]

Not quite point and click, but you could insert some code like that found at:

Google Groups

Just before where the code has you "put" the variable names, you could have it "put" your initial string.

[YW_CA]

Tried this before. The thing is I am running the process in SAS EG from a SAS server, not from local. so when I wrote data _null_, put, it always complained about Insufficient authorization to access

[art297]

if you run an export where are the files written?  Just indicate the same location (directory) in your file statement.  You have to have write ability somewhere.

[Cynthia_sas]

Hi:

  In addition to the other suggestions, instead of doing an EXPORT, using PROC EXPORT or the LIBNAME engine, you could use PROC REPORT and ODS (ODS CSVALL or ODS CSV). In the code below, I show ODS CSVALL (which would also put a SAS title into the output file).;

cynthia

data testdata;

  infile datalines dlm=',';

  input item $ price : comma.;

return;

datalines;

AB,$50

CD,$40

;

run;

title;

ods listing close;

ods csvall file='c:\temp\something.csv';

  proc report data=testdata nowd;

    column ('purchaselist' item price);

    format price dollar3.;

  run;

ods csvall close;