Load .WPD file to SAS as SAS7BDAT

Reply
Occasional Contributor
Posts: 10

Load .WPD file to SAS as SAS7BDAT

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

Super User
Super User
Posts: 7,430

Re: Load .WPD file to SAS as SAS7BDAT

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.

Occasional Contributor
Posts: 10

Re: Load .WPD file to SAS as SAS7BDAT

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
Super User
Super User
Posts: 7,430

Re: Load .WPD file to SAS as SAS7BDAT

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?

 

 

Super User
Posts: 17,949

Re: Load .WPD file to SAS as SAS7BDAT

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. 

Super User
Posts: 10,549

Re: Load .WPD file to SAS as SAS7BDAT

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.

Occasional Contributor
Posts: 10

Re: Load .WPD file to SAS as SAS7BDAT

@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?
Super User
Posts: 17,949

Re: Load .WPD file to SAS as SAS7BDAT

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. 

Super User
Posts: 17,949

Re: Load .WPD file to SAS as SAS7BDAT

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;

 

Ask a Question
Discussion stats
  • 8 replies
  • 934 views
  • 0 likes
  • 4 in conversation