Desktop productivity for business analysts and programmers

import error

Reply
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

script.bmp

PROC Star
Posts: 7,433

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.

Super User
Posts: 9,867

import error

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

Trusted Advisor
Posts: 2,114

import error

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

Duke

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