BookmarkSubscribeRSS Feed
DerekChan
Calcite | Level 5

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

3 REPLIES 3
art297
Opal | Level 21

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.

Ksharp
Super User

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

Doc_Duke
Rhodochrosite | Level 12

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 737 views
  • 0 likes
  • 4 in conversation