DATA Step, Macro, Functions and more

numbered range variable list

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

numbered range variable list

[ Edited ]

Hello is there a way to shorten this?
data have;
infile ;
@5 var1 1.
@6 var2 1.
@7 var3 1.
@8 var4 1.
@9 var5 1.
@10 var6 1.
@11 var7 1.
@12 var8 1.
@13 var9 1.
@14 var10 1.
@15 var11 1.
@16 var12 1.
@17 var13 1.
@18 var14 1.
@19 var15 1.
@20 var16 1.
@21 var17 1.
@22 var18 1.
@23 var19 1.
@24 var20 1.
;
run;

 

the data im trying to export has no delimiters hence the width and column number.

I tried @5 var1-var20 but getting errors, how do I use the numbered range variable list with data that has no delimiters (i.e 1234567891011222222267)?


Accepted Solutions
Solution
‎12-21-2017 02:31 PM
Super User
Posts: 6,934

Re: numbered range variable list

Posted in reply to SuperSaiyan

Try it this way:

 

input @5 (var1-var20) (1.);

View solution in original post


All Replies
Super User
Posts: 2,061

Re: numbered range variable list

Posted in reply to SuperSaiyan

My obs:

1. export to where?

2. What kind of external file

3. what kind of delimiters you want to separate data

4. choice of statements such as file(routing to external file) and put is missing, why?

5. have you considered export procedure?

6. what is the null infile statement doing

and many more

Occasional Contributor
Posts: 14

Re: numbered range variable list

Posted in reply to novinosrin

infile 'test.txt';

 

Occasional Contributor
Posts: 14

Re: numbered range variable list

Posted in reply to novinosrin
the data on the txt file has no delimiters (meaning no spaces or whatever) example 12345678910 each has name var1 var2 var3 var4 .... and so on, but this is too long, iwant to use var1-varn, but cannot get it
Solution
‎12-21-2017 02:31 PM
Super User
Posts: 6,934

Re: numbered range variable list

Posted in reply to SuperSaiyan

Try it this way:

 

input @5 (var1-var20) (1.);

Occasional Contributor
Posts: 14

Re: numbered range variable list

Posted in reply to Astounding
Thank you! It worked!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 164 views
  • 0 likes
  • 3 in conversation