topic import error in SAS Enterprise Guide

import error

DerekChan — Thu, 29 Dec 2011 03:59:15 GMT

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

wrong result from script import

import script

import error

art297 — Thu, 29 Dec 2011 04:12:27 GMT

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.

import error

Ksharp — Thu, 29 Dec 2011 06:17:28 GMT

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

import error

Doc_Duke — Mon, 02 Jan 2012 15:59:00 GMT

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