About srav2

srav2 · ‎03-22-2018

Why RFSTDTC, RFXTSDTC , RFENDTC and RFXENDTC are called record qualifiers in DM whereas __STDTC variables in other domains are called as timing variables?

srav2 · ‎12-20-2017

hi, The sample data is as below. In the final report i need to change the order of the observations in the variable race$. data out. dm; length region$ 15 ethnicity$ 25 Trtgrp$ 20; input studyid$ age height weight BSA region$ sex$ race$ ethnicity$ Trtgrp$; datalines; 001 50 112 60 2.3 NorthAmerica Men White Caucasian Trt1 002 66 123 62 2.1 NorthAmerica Women White AfricanAmerican Trt1 003 68 136 55 2.6 Europe Women Black Caucasian Trt1 004 70 128 69 1.9 Europe Men White Latino Trt1 005 78 130 74 1.6 NorthAmerica Men White Caucasian Trt1 006 76 124 66 1.8 Europe Women Black AfricanAmerican Trt2 007 77 126 64 2.4 Europe Men Black Caucasian Trt2 008 65 122 70 1.5 NorthAmerica Men White AfricanAmerican Trt1 009 67 132 73 1.3 Europe Men White Caucasian Trt1 010 69 128 76 1.4 NorthAmerica Women Black Caucasian Trt2 ; run; proc report data = out.Demographics nowd headline spacing = 10; columns _NAME_ trt1 trt2 total; define _NAME_ /display " " center; define trt1 /display "TRT1" center; define trt2 /display "TRT2" center; define total/display "Total" center; run;

srav2 · ‎12-19-2017

Hi, Can anyone please explain how to change the order of observations in proc report. I tried creating format and applied in proc report. But it is not working. I need the _NAME_ variable to be displayed in the order that is mentioned in the format. proc format; value $NAME "0"= "Age (yrs)" "1" = " Number" "2" = " Mean(SD)" "3" = " Median" "4" = " Min : Max" "5" = "Age group (yrs), N (%)" "6" = " <50" "7" = " 50-59" "8" = " 60-64" "9" = " >=65" "10" = "Gender, N (%)" "11" = " Female" "12" = " Male" "13" = " U" "14" = "Race, N (%)" "15" = " Black" "16" = " Asian/Oriental" "17" = " Causasian" "18" = " Other"; run; proc report data = dm nowd headline spacing = 10 split="~"; columns _NAME_ _0_3_MG_KG_IV _1_0_MG_KG_IV _2_0_MG_KG_IV _2_5_MG_KG_IV TOTAL; define _NAME_ /display " " style(column) = [asis=on] order = formatted format = $NAME.; define _0_3_MG_KG_IV/display "0.3 mg/kg~IV~(N=&cnt1)" center; define _1_0_MG_KG_IV/display "1.0 mg/kg~IV~(N=&cnt2)" center; define _2_0_MG_KG_IV/display "2.0 mg/kg~IV~(N=&cnt3)" center; define _2_5_MG_KG_IV/display "2.5 mg/kg~IV~(N=&cnt4)" center; define TOTAL/display "Total~IV~(N=&cnt5)" center; run; Thanks Thanks

srav2 · ‎12-19-2017

hi, I'm having the data like the table. I want to change the observations order of first column. I need the order like below. Age (yrs) Number Mean (SD) Median Min : Max Age group (yrs), N (%) <50 50-59 60-64 >=65 Gender, N (%) Female Male U Race, N (%) Black Asian/Oriental Caucasian Other 0.3 mg/kg IV(N=3) 1.0 mg/kg IV(N=5) 2.0 mg/kg IV(N=5) 2.5 mg/kg IV(N=2) Total IV(N=15) Age (yrs) Number 3 5 5 2 15 Mean (SD) 49.0(11.8) 61.4( 8.2) 61.4( 6.7) 51.0( 7.1) 57.5( 9.4) Median 46.0 59.0 63.0 51.0 58.0 Min : Max 39:62 52:74 53:68 46:56 39:74 Age group (yrs), N(%) 50-59 3( 60.0%) 2( 40.0%) 1( 50.0%) 6( 40.0%) 60-64 1( 33.3%) 1( 20.0%) 1( 20.0%) 3( 20.0%) <50 2( 66.7%) 1( 50.0%) 3( 20.0%) >=65 1( 20.0%) 2( 40.0%) 3( 20.0%) Gender, N (%) Female 1( 33.3%) 3( 60.0%) 4( 80.0%) 2( 100.0%) 10( 66.7%) Male 2( 66.7%) 1( 20.0%) 1( 20.0%) 4( 26.7%) U 1( 20.0%) 1( 6.7%) Race, N (%) ASIAN/ORIENTAL 1( 33.3%) 2( 40.0%) 1( 50.0%) 4( 26.7%) BLACK 2( 40.0%) 3( 60.0%) 5( 33.3%) CAUCASIAN 2( 66.7%) 3( 60.0%) 5( 33.3%) OTHER 1( 50.0%) 1( 6.7%)

srav2 · ‎12-19-2017

Hi, The output is displayed in this manner which is not present in format order. <50 2( 66.7%) 1( 50.0%) 3( 20.0%) >=65 1( 20.0%) 2( 40.0%) 3( 20.0%) 50-59 3( 60.0%) 2( 40.0%) 1( 50.0%) 6( 40.0%) 60-64 1( 33.3%) 1( 20.0%) 1( 20.0%) 3( 20.0%) Age (yrs) Age group (yrs), N(%) ASIAN/ORIENTAL 1( 33.3%) 2( 40.0%) 1( 50.0%) 4( 26.7%) BLACK 2( 40.0%) 3( 60.0%) 5( 33.3%) CAUCASIAN 2( 66.7%) 3( 60.0%) 5( 33.3%) Female 1( 33.3%) 3( 60.0%) 4( 80.0%) 2( 100.0%) 10( 66.7%) Gender, N (%) Male 2( 66.7%) 1( 20.0%) 1( 20.0%) 4( 26.7%) Mean (SD) 49.0(11.8) 61.4( 8.2) 61.4( 6.7) 51.0( 7.1) 57.5( 9.4) Median 46.0 59.0 63.0 51.0 58.0 Min : Max 39:62 52:74 53:68 46:56 39:74 Number 3 5 5 2 15 OTHER 1( 50.0%) 1( 6.7%) Race, N (%) U 1( 20.0%) 1( 6.7%)

srav2 · ‎12-19-2017

hi, The output I'm getting is as below in which order of the observations is not according to the format. Please help. 0.3 mg/kg IV(N=3) 1.0 mg/kg IV(N=5) 2.0 mg/kg IV(N=5) 2.5 mg/kg IV(N=2) Total IV(N=15) Age (yrs) Number 3 5 5 2 15 Mean (SD) 49.0(11.8) 61.4( 8.2) 61.4( 6.7) 51.0( 7.1) 57.5( 9.4) Median 46.0 59.0 63.0 51.0 58.0 Min : Max 39:62 52:74 53:68 46:56 39:74 Age group (yrs), N(%) 50-59 3( 60.0%) 2( 40.0%) 1( 50.0%) 6( 40.0%) 60-64 1( 33.3%) 1( 20.0%) 1( 20.0%) 3( 20.0%) <50 2( 66.7%) 1( 50.0%) 3( 20.0%) >=65 1( 20.0%) 2( 40.0%) 3( 20.0%) Gender, N (%) Female 1( 33.3%) 3( 60.0%) 4( 80.0%) 2( 100.0%) 10( 66.7%) Male 2( 66.7%) 1( 20.0%) 1( 20.0%) 4( 26.7%) U 1( 20.0%) 1( 6.7%) Race, N (%) ASIAN/ORIENTAL 1( 33.3%) 2( 40.0%) 1( 50.0%) 4( 26.7%) BLACK 2( 40.0%) 3( 60.0%) 5( 33.3%) CAUCASIAN 2( 66.7%) 3( 60.0%) 5( 33.3%) OTHER 1( 50.0%) 1( 6.7%)

srav2 · ‎12-19-2017

hi, I'm getting the following error. Please help. proc sort data = dm out=want; 780 sortseq=linguistic(Numeric_Collation=ON); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 781 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.WANT was not replaced because this step was stopped. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

srav2 · ‎12-19-2017

Thanks for your solution. But im having a doubt. which datset we need to take in proc sort data

srav2 · ‎12-19-2017

hi, I was trying to apply format in the proc report. But the order is not applied to the output. Below is my code.Please help. proc format; value $NAME "0"= "Age (yrs)" "1" = " Number" "2" = " Mean(SD)" "3" = " Median" "4" = " Min : Max" "5" = "Age group (yrs), N (%)" "6" = " <50" "7" = " 50-59" "8" = " 60-64" "9" = " >=65" "10" = "Gender, N (%)" "11" = " Female" "12" = " Male" "13" = " U" "14" = "Race, N (%)" "15" = " Black" "16" = " Asian/Oriental" "17" = " Causasian" "18" = " Other"; run; proc report data = dm nowd headline spacing = 10 split="~"; columns _NAME_ _0_3_MG_KG_IV _1_0_MG_KG_IV _2_0_MG_KG_IV _2_5_MG_KG_IV TOTAL; define _NAME_ /display " " style(column) = [asis=on] order = formatted format = $NAME.; define _0_3_MG_KG_IV/display "0.3 mg/kg~IV~(N=&cnt1)" center; define _1_0_MG_KG_IV/display "1.0 mg/kg~IV~(N=&cnt2)" center; define _2_0_MG_KG_IV/display "2.0 mg/kg~IV~(N=&cnt3)" center; define _2_5_MG_KG_IV/display "2.5 mg/kg~IV~(N=&cnt4)" center; define TOTAL/display "Total~IV~(N=&cnt5)" center; run; Thanks

srav2 · ‎11-22-2017

Could you please explain how this worked out.

srav2 · ‎11-22-2017

thanks a lot it worked..

srav2 · ‎11-22-2017

its a question asked in interview. I tried different ways but couldnt get the result. will try this.

srav2 · ‎11-22-2017

Hi, I'm having a dataset shown as below and all the variables are characters. I need a output in which TERM variable is having the values of both TERM and WORD. PLease help Thanks in advance. INPUT: TERM WORD Cold chills Fever HIgh temperature Headache dizziness OUTPUT: TERM Cold chills fever high temperature Headache dizziness

Online Status	Offline
Date Last Visited	‎03-28-2018 05:46 AM

rfstdtc

Re: PROC Report

PROC Report

Re: Proc report

Re: Proc report

Re: Proc report

Re: Proc report

Re: Proc report

Proc report

Re: how to merge two columns into single column

how to merge two columns into single column

rfstdtc

Re: PROC Report

PROC Report

Re: Proc report

Re: Proc report

Re: Proc report

Re: Proc report

Re: Proc report

Proc report

Re: how to merge two columns into single column

Re: how to merge two columns into single column

Re: how to merge two columns into single column

how to merge two columns into single column