Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 16

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


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.

Esteemed Advisor
Posts: 7,302

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

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.

Occasional Contributor
Posts: 16

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

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

Esteemed Advisor
Posts: 7,302

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

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.

SAS Super FREQ
Posts: 8,721

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

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;

Ask a Question
Discussion stats
  • 4 replies
  • 306 views
  • 0 likes
  • 3 in conversation