topic Re: Proc import in SAS Programming

Proc import

PhanS — Thu, 22 Feb 2018 16:36:41 GMT

Hello,

I have an issue re. proc import from SPSS. I have an actual data in SPSS. Appreciate all your help.

Phan S.


Phan S.proc import out=mosT4
  datafile='C:\Users\Desktop\Test.sav'
  dbms=SAV replace;
  run;


ERROR: Physical file does not exist, C:\Users\Phan S\Desktop\Test.sav.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.03 seconds

Re: Proc import

PaigeMiller — Thu, 22 Feb 2018 16:38:00 GMT

@PhanS wrote:

I have an issue re. proc import from SPSS. I have an actual data in SPSS. Appreciate all your help.

ERROR: Physical file does not exist, C:\Users\Phan S\Desktop\Test.sav.

This means that the file you are trying to import does not exist.

Re: Proc import

SuryaKiran — Thu, 22 Feb 2018 16:41:20 GMT

Hi,

Why does your code show one path and the error shows different path. Make sure you give the correct physical path because the log clearly says that file doesn't exist.

Re: Proc import

PhanS — Fri, 23 Feb 2018 02:20:43 GMT

Thank you. I deleted some of characters in the path - that is it is confused you.

I retested proc import - still does not work.

However, this link helped me https://kb.iu.edu/d/agau

I followed this ---- Open your data in SPSS. To create a SAS file, click File, and then Save As....
Change "Save as type" to SAS v9+ Windows (*.sas7bdat), and then click Save.

Re: Proc import

PhanS — Fri, 23 Feb 2018 02:21:27 GMT

Thank you. The file exists!

I retested proc import - still does not work.

However, this link helped me https://kb.iu.edu/d/agau

I followed this ---- Open your data in SPSS. To create a SAS file, click File, and then Save As....
Change "Save as type" to SAS v9+ Windows (*.sas7bdat), and then click Save.