topic Re: Coverting SAS datasets into .txt files and Vice versa in SAS Procedures

Coverting SAS datasets into .txt files and Vice versa

mvk_sas — Wed, 06 Mar 2013 13:28:40 GMT

Hi All,

Question A

I have situation where i need convert the SAS datasets into the flat files irrespective how many varaiables or how much data it has . ( i am trying out in such a way that if i give dataset name it should convert the data into flat file)

"One observation should be read as single like example i am going to assign varchar(3000) so on."

Question B

Coverting the flat file into the sas dataset even in this case also i am not about the size but should read the variables and coloums data.

Any help would really be apprciated .. I am trying out from end as well.

MVK

Re: Coverting SAS datasets into .txt files and Vice versa

LinusH — Wed, 06 Mar 2013 13:43:37 GMT

I'm not sure about your requirements, but try to start with PROC EXPORT/IMPORT, and see if they can do what you need.

Re: Coverting SAS datasets into .txt files and Vice versa

TomKari — Wed, 06 Mar 2013 13:51:39 GMT

Check out Chris' blog posting. Either you can use his Enterprise Guide task, or it may give you some ideas to do it yourself.

Tom

http://blogs.sas.com/content/sasdummy/2013/01/21/turn-your-data-set-into-a-data-step-program/

Re: Coverting SAS datasets into .txt files and Vice versa

mvk_sas — Wed, 06 Mar 2013 14:09:37 GMT

Just for understanding this what i am looking at

mydataset has following observation in that.

First_name Last_name Enumber

Mike Dell 1234

when i read the data into flat file i want it this way

First_name,Last_name,Enumber

Mike,Dell,1234

This what i am looking for??

Any help on this is apprciated.

MVK

Re: Coverting SAS datasets into .txt files and Vice versa

LinusH — Wed, 06 Mar 2013 14:14:25 GMT

PROC EXPORT!

Re: Coverting SAS datasets into .txt files and Vice versa

TomKari — Wed, 06 Mar 2013 18:44:17 GMT

Yes, the format that you are showing is termed "csv", for comma-separated-values. This is easy do to with SAS. As Linus suggests, check out PROC EXPORT.

Tom

Re: Coverting SAS datasets into .txt files and Vice versa

Peter_C — Wed, 06 Mar 2013 23:50:38 GMT

and if you don't like proc export

data _null_ ;

file 'your.csv' dsd lrecl=30000 ;

set your.data ;

put (_all_)(:) ;

run ;

Probably a good idea also to write the proc contents output data set into a matching csv

Then the reciever of the data has an idea about the datatypes.