topic Re: output in csv format in ODS and Base Reporting

output in csv format

14sas — Fri, 08 Jan 2016 17:35:13 GMT

I need an output in csv ,and my program is :

data_null_;

filename;

set;

file

delimiter=',' dsd 1rec1 = 350;

if_n_1 = 1

then do ;

put 'name'

'date'

'place'

'gender'

;

end;

put name

date

place

gender

;

run;

now my issue is when i open the ouput file either in excel or word pad

name date place gender

abcdef,09/09/2001,losangeles,male

how to arrange or reformat .,where there is no mention of size of variables in requiremnt .

Re: output in csv format

Reeza — Fri, 08 Jan 2016 17:36:43 GMT

I don't understand your question. What are you having issues with?

Re: output in csv format

14sas — Fri, 08 Jan 2016 17:38:32 GMT

name date place gender
abcdef,09/09/2001,losangeles,male

This how it appears when i try to open in word pad .

Re: output in csv format

Reeza — Fri, 08 Jan 2016 17:40:13 GMT

That's what a CSV file looks like, Comma Separated Values

What format do you want to see in wordpad?

Re: output in csv format

14sas — Fri, 08 Jan 2016 17:42:16 GMT

they are not in prorper rows i ,e date is not under date coilumn and so on

Re: output in csv format

Reeza — Fri, 08 Jan 2016 17:46:24 GMT

You didn't include comma's in your header column. Add comma's between the variable names and then open the file in Excel, it should look fine. If you want it to line up in columns in word pad that is NOT a CSV file, its a fixed width file format, that I would recommend avoiding.

Also, you can use proc export instead of manually writing your datastep export if you'd like.

proc export data=have outfile="mycsv.csv" dbms=csv replace; run;

How do I write out a fixed-format file in SAS?

http://www.ats.ucla.edu/stat/sas/faq/write_fixedformat.htm

Re: output in csv format

14sas — Sat, 09 Jan 2016 15:10:39 GMT

If I don't include commas in header column ,
The output would be :
Abcdf,9:9/2001,losangeles n so nn

Re: output in csv format

Reeza — Sat, 09 Jan 2016 18:10:27 GMT

Please try it.
If _n_ =1 then Put 'name, date, place, Gender';