Desktop productivity for business analysts and programmers

import error

Occasional Contributor
Posts: 5

import error

there are a  error when importing the file by script. (You can see row 107 - 120)

But it is alright when file is imported manually.

correct result from manual import

manual import.bmp

wrong result from script import

script import.bmp

import script


Super User
Posts: 8,214

import error

Posted in reply to DerekChan

Unless you've created a macro variable priror to the macro you showed, with the name yymmdd, I don't see how that code could run.

Super User
Posts: 10,848

import error

Posted in reply to DerekChan

I think you should post some contents of original file to judge .

Trusted Advisor
Posts: 2,127

import error

Posted in reply to DerekChan


I agree with Ksharp that we don't have enough information to help directly.  However, you could try the Enterprise Guide Data --> open task to get the spreadsheet into SAS.  EGuide has much better Excel data handling than PROC IMPORT.

Doc Muhlbaier


Ask a Question
Discussion stats
  • 3 replies
  • 4 in conversation