topic How resolve variable issue in SAS Programming

How resolve variable issue

thanikondharish — Thu, 13 Dec 2018 08:59:22 GMT

I have to import one excel sheet in that sheet one column name is "monthly wise and year wise number'
When I am importing this sheet it is showing error like length is more than 32 characters .
So how to resolve that error

Re: How resolve variable issue

RW9 — Thu, 13 Dec 2018 09:12:59 GMT

Use named literals:

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000998953.htm

I.e.

libname excel "....xlsx";

data want;
  set "monthly wise and year wise number"n;
run;

An make sure once you imported it to change its name to use SAS naming so you dont have to code that each time.

Or drop Excel as a datasource, which generally sorts a lot of issues.

Re: How resolve variable issue

thanikondharish — Thu, 13 Dec 2018 09:15:47 GMT

I am asking variable name

Re: How resolve variable issue

PeterClemmensen — Thu, 13 Dec 2018 09:16:57 GMT

If I were you, I would change the variable name directly in the Excel workbook. Get rid of spaces and keep it shorter and simpler 🙂

Re: How resolve variable issue

Kurt_Bremser — Thu, 13 Dec 2018 09:18:48 GMT

@thanikondharish wrote:

When I am importing this sheet it is showing error like length is more than 32 characters .

Use a shorter name in Excel, or use a sustainable data transfer process that does NOT rely on the Excel file format. Column names in SAS are hard limited to 32 characters, there's no way around it.

SAS 9.6 or 10 (or whatever the next major version will be called) might provide the capability for longer names, but at the moment the (in my opinion VERY reasonable) limit of 32 is in place.

For a reliable import process, use a proper file format like CSV or any character-delimited or fixed-width text file. In the data step, YOU define the names, and you do not have to work around the crazy ideas of lusers.

Re: How resolve variable issue

RW9 — Thu, 13 Dec 2018 09:27:50 GMT

This post makes no sense. I have provided a link to the mechanism that SAS uses to access names which are not SAS compliant. If you have further questions, please elaborate in full with examples so I don't need to guess what you mean.

Re: How resolve variable issue

thanikondharish — Thu, 13 Dec 2018 09:41:47 GMT

Sorry I got the data that is SAS teachnical issue
So I closed the SAS and again opened and run the program

Re: How resolve variable issue

Reeza — Thu, 13 Dec 2018 16:19:35 GMT

@thanikondharish wrote:
Sorry I got the data that is SAS teachnical issue
So I closed the SAS and again opened and run the program

Please mark this question as closed.