how to fix length exported data

deleted_user — Mon, 20 Apr 2009 05:28:14 GMT

I have sas data set to export to text but i want to fix lenght it ex.

var1 var2 var3 var4 var5
A, B , C, 100, 15000

I would like to fix lenght var1 = 1, var2 = 2 , var3 = 1 var4 = 9 var5 = 9
how i do ?

command

data _null_ ;
set a;
file '.....' dlm = ';' ;
put var1 var2 var3 var4 var5 ;
run;

output doesn't fix length
A;B;C;100;15000
i want fix length
A;B ;C;000000100;000150000 or
A;B ;C; 100; 150000

thanks in advance

Re: how to fix length exported data

LinusH — Mon, 20 Apr 2009 07:32:24 GMT

By using @ you can specify fixed positions in your output (as well as input when reading files). And you will probably not need a delimiter if your file has fixed width fields.

data _null_ ;
set a;
file '.....';
put @1 var1 @10 var2 @39 var3 @40 var4 @45 var5 ;
run;

/Linus

topic Re: how to fix length exported data in SAS Programming

how to fix length exported data

Re: how to fix length exported data