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?
A good external tool for windows is called V (http://fileviewer.com/). It is not free, but's it's cheap and works well.
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.
A good external tool for windows is called V (http://fileviewer.com/). It is not free, but's it's cheap and works well.
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.
V is pretty neat. Have to get that.
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.
If you are using SAS/EG ,then at Import Wizard , you will see this ability.
Ksharp
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.