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
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.
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?
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.
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.
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.
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;
Hi,
Could you please let me know what specific problems you have encountered when you create a SAS7BDAT file from WPS.
Regards,
manoj Bansal
A minor issue might be this thread is from over a year ago.
Also I'm not sure we should be helping people with WPS related problems given the history - "Just use SAS" would be my response...
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: