topic Re: proc sql length in SAS Programming

proc sql length

deleted_user — Wed, 10 Mar 2010 04:05:41 GMT

How do I specify the length of v?

proc sql noprint;
select rate
into :v
from test1;
quit;

Re: proc sql length

deleted_user — Wed, 10 Mar 2010 10:00:39 GMT

hi, you can try the system option of MVARSIZE, see http://support.sas.com/documentation/cdl/en/hostwin/61924/HTML/default/win-sysop-mvarsize.htm

Re: proc sql length

sbb — Wed, 10 Mar 2010 12:14:03 GMT

Most likely you will want to use a FORMAT= on the SELECT clause, specified after the SAS variable name -- this would be if you are attempting to truncate a CHARACTER variable or if you want to "format" the output of a NUMERIC variable.

Scott Barry
SBBWorks, Inc.

Re: proc sql length

DanielSantos — Wed, 10 Mar 2010 12:28:54 GMT

Simply as this:
[pre]
proc sql noprint;
select rate length=8
into :v
from test1;
quit;
[/pre]
But I suspect that's not what you need.
As Scott suggested, I'm guessing you want to format rate in some specific way.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: proc sql length

Peter_C — Wed, 10 Mar 2010 17:19:30 GMT

same as normal
format the source, and that is what appears in the destination
proc sql noprint;
select rate format= best20.
into :v
from test1;
quit;

of course, if you want to remove leading/trailing blanks

%let v = &v ; Message was edited by: Peter.C trim lead/trailing blanks

Re: proc sql length

deleted_user — Wed, 10 Mar 2010 18:56:33 GMT

This is what I want.
I just used format=5.2 instead of best20.
Thanks.