PROC SQL and non formatted values

[AnalytX]

Hi everybody,

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

Thanking you in advance,

Best

[Reeza]

What do you mean by 'non formatted values'?

[Haikuo]

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

[Reeza · Accepted solution]

Or apply a format that overrides it.

proc sql;

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

from sashelp.class;

quit;

[AnalytX]

Thanks a lot for your answers!

Reeza, it is exactly what I need.

Best,