08-25-2016 11:25 AM
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.
08-25-2016 12:21 PM
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?
08-25-2016 01:08 PM
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.
08-25-2016 11:26 AM
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.
08-25-2016 01:40 PM
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.
08-25-2016 02:24 PM
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;