topic Re: numbered range variable list in SAS Programming

numbered range variable list

SuperSaiyan — Thu, 21 Dec 2017 19:02:41 GMT

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)?

Re: numbered range variable list

novinosrin — Thu, 21 Dec 2017 19:12:54 GMT

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

Re: numbered range variable list

SuperSaiyan — Thu, 21 Dec 2017 19:18:08 GMT

infile 'test.txt';

Re: numbered range variable list

SuperSaiyan — Thu, 21 Dec 2017 19:21:05 GMT

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

Re: numbered range variable list

Astounding — Thu, 21 Dec 2017 19:26:39 GMT

Try it this way:

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

Re: numbered range variable list

SuperSaiyan — Thu, 21 Dec 2017 19:30:59 GMT

Thank you! It worked!