Help using Base SAS procedures

PROC SQL and non formatted values

Accepted Solution Solved
Reply
Contributor
Posts: 57
Accepted Solution

PROC SQL and non formatted values

Hi everybody,

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

Thanking you in advance,

Best


Accepted Solutions
Solution
‎05-30-2013 12:33 PM
Super User
Posts: 19,770

Re: PROC SQL and non formatted values

Or apply a format that overrides it.

proc sql;

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

from sashelp.class;

quit;

View solution in original post


All Replies
Super User
Posts: 19,770

Re: PROC SQL and non formatted values

What do you mean by 'non formatted values'?

Respected Advisor
Posts: 3,156

Re: PROC SQL and 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

Solution
‎05-30-2013 12:33 PM
Super User
Posts: 19,770

Re: PROC SQL and non formatted values

Or apply a format that overrides it.

proc sql;

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

from sashelp.class;

quit;

Contributor
Posts: 57

Re: PROC SQL and non formatted values

Thanks a lot for your answers!

Reeza, it is exactly what I need.

Best,

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 220 views
  • 3 likes
  • 3 in conversation