topic Re: Any fast way to show the width of the variables in column format? in SAS Procedures

Any fast way to show the width of the variables in column format?

VX_Xc — Wed, 14 Dec 2011 20:41:32 GMT

I want to apply column input in DATA step.

eg) INPUT Name $ 1-7 ;

and I'm sick of counting letters and spaces to determine when column starts and finishes.

Is there a simple editor that shows 'rulers' at the top?

Re: Any fast way to show the width of the variables in column format?

art297 — Wed, 14 Dec 2011 20:53:48 GMT

The list statement might provide what you are looking for. E.g.:

data test;

input;

list;

stop;

cards;

1234567890abcdefgh

xxxxxxxxxxxxxxxxxx

;

will produce something like:

RULE: ----+----1----+----2----+----3----+----4----+----5----+

15 1234567890abcdefgh

NOTE: The data set WORK.TEST has 0 observations and 0 variables.

Any fast way to show the width of the variables in column format?

FriedEgg — Wed, 14 Dec 2011 21:06:17 GMT

A good external tool for windows is called V (http://fileviewer.com/). It is not free, but's it's cheap and works well.

Any fast way to show the width of the variables in column format?

art297 — Wed, 14 Dec 2011 21:33:20 GMT

And a cheaper way to do the same thing is to use Wordpad rather than Notepad and make courier or new courier the default font. Wordpad has a built-in ruler.

Any fast way to show the width of the variables in column format?

VX_Xc — Wed, 14 Dec 2011 21:37:02 GMT

V is pretty neat. Have to get that.

Any fast way to show the width of the variables in column format?

SASKiwi — Thu, 15 Dec 2011 00:04:45 GMT

If you have SAS/FSP licensed and are using SAS Display Manager then you can use the FSLIST procedure.

In the command window: FSLIST 'example.txt'. Once the FSLIST window comes up enter the command COLS ON to get a ruler.

Any fast way to show the width of the variables in column format?

Ksharp — Thu, 15 Dec 2011 04:46:30 GMT

If you are using SAS/EG ,then at Import Wizard , you will see this ability.

Ksharp