Help using Base SAS procedures

help with proc convert or importing data.

Reply
Contributor
Posts: 40

help with proc convert or importing data.

Hi, I've been sent an SPSS data file in .por format which I can normally convert into sas using the proc convert procedure with no problems, however since our oganisation upgraded to SAS 9.2 with Enterprise Guide 4.2 the proc convert code we usually use doesn't seem to be working. I now get a "Read Access Validation in Task [convert (2)] Exception occurred at (06F3EA22)"

We then asked our supplier to use SPSS to convert the file to a SAS file rather than a por file and they sent us one with a file extension .sas7dbat when all our other files have the extension .sas7bdat.This file did not appear on the list of files that could be opened by SAS. Finally we asked them if SPSS allowed them to create sas7bdat files and they sent us one with this extension, however SAS now doesn't recongise it and says it cannot open it.

Does anyone have any suggestions that we can try or tell our supplier to try in SPSS?

My proc convert code is as follows:


libname health BASE 'C:\Lifestyles\HSE08';
libname health 'C:\Lifestyles\HSE08';

filename hse08ai 'C:\Lifestyles\HSE08\hse08ai.por';

proc convert spss=hse08ai out=health.hse08ai;

Many thanks
Nicola
run;
Trusted Advisor
Posts: 2,113

Re: help with proc convert or importing data.

You probably need to call tech support on this one.

If you are caught between "a rock and a hard place", you can use a third party product (StatTransfer, say) to do the conversion.

Doc
Contributor
Posts: 40

Re: help with proc convert or importing data.

Thanks, our suppliers managed to figure it out at their end so it now works!
Ask a Question
Discussion stats
  • 2 replies
  • 114 views
  • 0 likes
  • 2 in conversation