topic Re: Importing excel file with multiple sheets into SAS DI Studio in SAS Data Management

Importing excel file with multiple sheets into SAS DI Studio

wellylly — Fri, 07 Dec 2018 08:16:20 GMT

Hi..
I wanted to import an excel file with multiple sheets into SAS DI Studio. Actually, it has 3 sheets but when i import it and sign a library with the excel file, there're 5 datasets created in the libary and some sheets have a duplicate with another name. Then i tried to use data validation to make sure the mapped columns, but when i registered the new table after validation, i run them all, then i got an error like this pict below. I have no idea to solve it.

I opened the log, then this is the error:

288 /* No validation to do - copy source table to target */

289 data bnimap.TestMoney;

290 set TRS3.MoneyF$;

200

ERROR: File TRS3.MoneyF.DATA does not exist.

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,

KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

.
.

Could anyone tell me the solution of this problem, please??

Thankyou..

Re: Importing excel file with multiple sheets into SAS DI Studio

AngusLooney — Tue, 11 Dec 2018 21:16:31 GMT

Not going to help, but wherever you can, avoid Excel as a transport medioum for data, it rarely ends well.

One tip I remember was using the library member to tell you the names of the sheets, then use an access methos that lets you go straight to the individual sheets rather than the whole file in one go. Can't remember exactly how we did it, it was a good few years back.

Re: Importing excel file with multiple sheets into SAS DI Studio

wellylly — Mon, 17 Dec 2018 09:57:27 GMT

okay, thank you for the suggestion. I've tried using script to import the excel file and finally it works for each sheet.
hehehe