topic How to import large number of variables from excel sheet? in New SAS User

How to import large number of variables from excel sheet?

rajeshalwayswel — Tue, 23 Oct 2018 16:05:49 GMT

How to import large number of variables from excel sheet above 256 variables . Variables range in excel sheet range ah:gg100 .

I'm getting error as name "xx" is too long for sas name in this context.

Re: How to import large number of variables from excel sheet?

Reeza — Tue, 23 Oct 2018 16:07:29 GMT

Convert it to CSV is the fastest method. You can do that manually or there's a script on here somewhere that can automate that if necessary. It's VBS though, so you would need permissions to run it.

Re: How to import large number of variables from excel sheet?

ballardw — Tue, 23 Oct 2018 16:17:30 GMT

Is it an actual ERROR or a WARNING that a name has been truncated? There is a difference. SAS has a limit of 32 characters for a variable name. If your source file has more than 32 characters SAS has to do something which may involve truncating a name or if you have multiple variables with the same leading 32 (+) characters you may get a name of VAR plus the column number.

Re: How to import large number of variables from excel sheet?

Reeza — Tue, 23 Oct 2018 16:19:12 GMT

Upon re-reading, your subject doesn't match your actual question. Or are you having both issues? The 256 limit depends on the engine being used (DBMS) and the xx too long, is the SAS limitation of 32 characters. That's usually a note that it will convert it though.

Re: How to import large number of variables from excel sheet?

Ksharp — Wed, 24 Oct 2018 13:15:01 GMT

Using RANGE= option .