topic Re: How do I convert a format into a string value? in SAS Procedures

How do I convert a format into a string value?

Tpham — Thu, 08 Jan 2015 18:06:23 GMT

So this is what I have right now

proc format;
  value namefmt 1="Experiment" 2="Control";
run;

data have;
input name  count;
datalines;
1 16
2 8
;
run;

data have;
set have;
format name namefmt.;
run;

data want;
set have;
wantvar=name||" (N="||count||")";
run;

So in my want database, my wantvar is showing up as "1 (N= 16)", where I want it to actually show up as "Experiment (N=16)".

How can I get it to show the formatted value and not the actual value without creating a new variable?

Re: How do I convert a format into a string value?

stat_sas — Thu, 08 Jan 2015 18:22:52 GMT

data want;

set have;

wantvar=put(name,namefmt.)||" (N="||count||")";

run;

Re: How do I convert a format into a string value?

FriedEgg — Thu, 08 Jan 2015 18:25:18 GMT

proc format;

value namefmt 1="Experiment" 2="Control";

run;

data have;

input name count;

want=catx(' ', put(name, namefmt.), cats('(N=', count, ')'));

datalines;

1 16

2 8

;

proc print;

run;

Re: How do I convert a format into a string value?

ballardw — Thu, 08 Jan 2015 18:25:31 GMT

To remove the space before the number on way:

wantvar=put(name,namefmt.)||" (N="||strip(count)||")";

Re: How do I convert a format into a string value?

user24feb — Thu, 08 Jan 2015 18:27:31 GMT

Try: Wantvar=Catt(Put(Name,namefmt.),' N=(',Count,')'); * I guess the others were much quicker though ..;

Re: How do I convert a format into a string value?

Steelers_In_DC — Thu, 08 Jan 2015 18:28:52 GMT

Tpham, you will want to use a put function:

proc format;

value $namefmt 1="Experiment" 2="Control";

run;

data have;

Input name $ count;

datalines;

1 16

2 8

;

run;

data want;

format name $ namefmt.;

set have;

wantvar= catx('',put(name,namefmt.),'(N=',count,')');

run;