Hi everybody,
Would it be possible to select non formatted values via SELECT in PROC SQL?
Thanking you in advance,
Best
Or apply a format that overrides it.
proc sql;
select age format=8., sex format=$8.
from sashelp.class;
quit;
What do you mean by 'non formatted values'?
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
Or apply a format that overrides it.
proc sql;
select age format=8., sex format=$8.
from sashelp.class;
quit;
Thanks a lot for your answers!
Reeza, it is exactly what I need.
Best,
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.