topic Re: PROC SQL and non formatted values in SAS Procedures

PROC SQL and non formatted values

AnalytX — Thu, 30 May 2013 15:21:04 GMT

Hi everybody,

Would it be possible to select non formatted values via SELECT in PROC SQL?

Thanking you in advance,

Best

Re: PROC SQL and non formatted values

Reeza — Thu, 30 May 2013 16:01:25 GMT

What do you mean by 'non formatted values'?

Re: PROC SQL and non formatted values

Haikuo — Thu, 30 May 2013 16:05:24 GMT

You need to do something pretentiously to the variable, for example:

data test;

dt="01may2013"d;

format dt date9.;

run;

proc sql;

create table want as

select dt+0 as dt from test;quit;

If it is char, depending on the contents, you can choose to use compress(), trim(), cats() etc. I prefer to using substr(var,1), seems more robust to me.

HTH,

Haikuo

Re: PROC SQL and non formatted values

Reeza — Thu, 30 May 2013 16:33:54 GMT

Or apply a format that overrides it.

proc sql;

select age format=8., sex format=$8.

from sashelp.class;

quit;

Re: PROC SQL and non formatted values

AnalytX — Fri, 31 May 2013 09:17:54 GMT

Thanks a lot for your answers!

Reeza, it is exactly what I need.

Best,