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';

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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