BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
VX_Xc
Calcite | Level 5

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?

1 ACCEPTED SOLUTION

Accepted Solutions
FriedEgg
SAS Employee

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

View solution in original post

6 REPLIES 6
art297
Opal | Level 21

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.

FriedEgg
SAS Employee

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

art297
Opal | Level 21

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.

VX_Xc
Calcite | Level 5

V is pretty neat. Have to get that.

SASKiwi
PROC Star

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.

Ksharp
Super User

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

Ksharp

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 2075 views
  • 6 likes
  • 5 in conversation