topic Re: Load .WPD file to SAS as SAS7BDAT in SAS Programming

Load .WPD file to SAS as SAS7BDAT

SambitNandi — Thu, 25 Aug 2016 14:45:17 GMT

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

Re: Load .WPD file to SAS as SAS7BDAT

RW9 — Thu, 25 Aug 2016 15:25:28 GMT

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.

Re: Load .WPD file to SAS as SAS7BDAT

ballardw — Thu, 25 Aug 2016 15:26:56 GMT

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.

Re: Load .WPD file to SAS as SAS7BDAT

SambitNandi — Thu, 25 Aug 2016 15:32:56 GMT

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

Re: Load .WPD file to SAS as SAS7BDAT

RW9 — Thu, 25 Aug 2016 16:21:42 GMT

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?

Re: Load .WPD file to SAS as SAS7BDAT

Reeza — Thu, 25 Aug 2016 17:08:59 GMT

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.

Re: Load .WPD file to SAS as SAS7BDAT

SambitNandi — Thu, 25 Aug 2016 17:15:23 GMT

@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?

Re: Load .WPD file to SAS as SAS7BDAT

Reeza — Thu, 25 Aug 2016 17:40:10 GMT

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.

Re: Load .WPD file to SAS as SAS7BDAT

Reeza — Thu, 25 Aug 2016 18:24:14 GMT

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;

Re: Load .WPD file to SAS as SAS7BDAT

manojinpec — Wed, 06 Sep 2017 10:44:40 GMT

Hi,

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

Regards,

manoj Bansal

Re: Load .WPD file to SAS as SAS7BDAT

RW9 — Wed, 06 Sep 2017 10:56:44 GMT

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

Re: Load .WPD file to SAS as SAS7BDAT

ChrisBrooks — Wed, 06 Sep 2017 12:33:54 GMT

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