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

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

YW_CA — Mon, 22 Oct 2012 22:55:32 GMT

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.

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

art297 — Mon, 22 Oct 2012 23:48:09 GMT

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.

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

YW_CA — Tue, 23 Oct 2012 00:01:22 GMT

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

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

art297 — Tue, 23 Oct 2012 00:45:11 GMT

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.

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

Cynthia_sas — Tue, 23 Oct 2012 01:38:04 GMT

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;