DATA Step, Macro, Functions and more

Proc import

Reply
Frequent Contributor
Posts: 83

Proc import

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

 

Respected Advisor
Posts: 2,647

Re: Proc import


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.

--
Paige Miller
Frequent Contributor
Posts: 83

Re: Proc import

Posted in reply to PaigeMiller

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.

Super Contributor
Posts: 451

Re: Proc import

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.

Thanks,
Suryakiran
Frequent Contributor
Posts: 83

Re: Proc import

Posted in reply to SuryaKiran

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.

Ask a Question
Discussion stats
  • 4 replies
  • 60 views
  • 0 likes
  • 3 in conversation