topic Re: recreate table in sas using an existing data set-reshaping of data-- in New SAS User

recreate table in sas using an existing data set-reshaping of data--

sdeswal — Sat, 06 Apr 2019 09:26:15 GMT

proc transpose gives me a table like in document...

I am trying to write a code so that i can have format like 341/367(93%)--- where 93% is % of row total &

367 is row total so i need: 341/367(93%) 26/367(7%) similar format for rest of table. i am able to do it as

a separate variable in table. but i want to replace value of cutoof60 & 61 in new dataset with new values.

i am making a mistake please help me to rectify the code...

Re: recreate table in sas using an existing data set-reshaping of data--

Kurt_Bremser — Sat, 06 Apr 2019 11:47:37 GMT

Please DO NOT use Office documents for posting such simple things as code, logs or textual data.

Use the "little running man" for code like this:

data tot1;
set tot_trsps;
if trgp_trt=1 then
 cutoff60= put(cutoff60,3.0)||'/'|| put((cutoff60+cutoff61),3.0)||'('||put((cutoff60/(cutoff60+cutoff61))*100,3.1)||'%)';
run;

It is obvious that you try to convert a variable "in place", which is not possible. SAS variables cannot be of type numeric and character within the same step or dataset.

Create a new variable:

cutoff60_char = put(cutoff60,3.0)||'/'|| put((cutoff60+cutoff61),3.0)||'('||put((cutoff60/(cutoff60+cutoff61))*100,3.1)||'%)';

Re: recreate table in sas using an existing data set-reshaping of data--

Kurt_Bremser — Sat, 06 Apr 2019 11:53:18 GMT

PS example data should NEVER be posted in pictures, as that forces everyone else to type data manually off the screen, which means unnecessary work and introduces opportunities for mistakes.

Use data steps with datalines instead:

data tot_trsps;
input trgp_trt cutoff60 cutoff61;
datalines;
1 341 26
2 367 22
;
run;

Re: recreate table in sas using an existing data set-reshaping of data--

sdeswal — Sun, 07 Apr 2019 03:31:23 GMT

Thanks a lot for solution and suggestion

i will keep in mind in next post...