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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.