Load .WPD file to SAS as SAS7BDAT

[SambitNandi]

Hi,

I am trying to load a .WPD file (created using WPS) into SAS.

Please let me know how to do it. Any help appreciated

Thanks

[RW9]

What does the file format actually look like.  Never heard of this WPS, so I don't expect an out of the box solution.  I would save from your original application to an open easy to read file format - CSV, XML etc. - then read that in.

[SambitNandi]

I found a solution in another forum, but did not make much sense to me.

http://www.talkstats.com/showthread.php/56302-How-to-read-a-.wpd-file-inot-sas-data-set

[RW9]

That doesn't make much sense because they are talking about two different things.  The OP is talking about reading in a proprietary external file, the responder is talking about setting up a libary to a dataset.  Different things.  Again, I don;t know what the file format is, you need to get it into a useable format, probably from the delivering person.  Or maybe it is a text file already, have you tried opening it in Notepad?

[Reeza]

WPS allows you to save a sas7bdat file. I rcommend using WPS to create a new file instead of trying to get the WPS file read. I'm not sure it's possible to read a WPS file into SAS. 

[ballardw]

Likely best bet would be to open in a word processor and save as text. I believe WPD means a fairly old WordPerfect document. Then try importing that.

But since word processor documents are not generally intended for data they tend to be poorly sturctured for turning into data sets.

[SambitNandi]

@Reeza Yes. I am also realizing that WPS can read SAS datasets but not the other way round. Is there any SAS documentation stating it is not supported?

[Reeza]

Not as far as I'm aware, but SAS suing WPS leads me to think they're not going to support it. 

I believe the WPS documentation does state that WPS datasets are not compatible with SAS. 

[Reeza]

Here's the code you can use in WPS to create a SAS7BDAT file.

FYI I still had issues with file even though its supposed to be SAS compatible.

libname out sas7bdat 'path to folder';

data out.mydataset;
set dataset;
run;

libname out;

[manojinpec]

Hi,

Could you please let me know what specific problems you have encountered when you create a SAS7BDAT  file from WPS.

Regards,

manoj Bansal

[RW9]

A minor issue might be this thread is from over a year ago.

[ChrisBrooks]

Also I'm not sure we should be helping people with WPS related problems given the history - "Just use SAS" would be my response...