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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1815 views
  • 6 likes
  • 5 in conversation