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


Esteemed Advisor
Posts: 7,294

import error

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.

Grand Advisor
Posts: 9,578

import error

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

Valued Guide
Posts: 2,111

import error


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