BookmarkSubscribeRSS Feed
14sas
Calcite | Level 5

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 .

7 REPLIES 7
Reeza
Super User
I don't understand your question. What are you having issues with?
14sas
Calcite | Level 5
name date place gender
abcdef,09/09/2001,losangeles,male

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

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

 

What format do you want to see in wordpad?

14sas
Calcite | Level 5
they are not in prorper rows i ,e date is not under date coilumn and so on
Reeza
Super User

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

 

 

14sas
Calcite | Level 5
If I don't include commas in header column ,
The output would be :
Abcdf,9:9/2001,losangeles n so nn
Reeza
Super User
Please try it.
If _n_ =1 then Put 'name, date, place, Gender';

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 2238 views
  • 0 likes
  • 2 in conversation