About raja777pharma

raja777pharma · ‎05-13-2020

Hello, I would like to assign max length for common variable for respective data set ,if variable present in data set Example : In a library we have 5 data sets A , B , C, D, E,F and XX_VAR is present in only A , B , E data sets and assign max length of this var across all data three data sets IF max XX_VAR length 150 in B data set and need to assign same length to across all data sets which have that variable This process will be for all vars in all data set in respective library

raja777pharma · ‎04-09-2020

Hello, It's not working as you mentioned i applied format but it didn't worked

raja777pharma · ‎04-09-2020

Hello , it's not working and showing error as below ERROR: PARAM must use a character format. ERROR: PARAM must use a character format. ERROR: PARAM must use a character format. ERROR: PARAM must use a character format. ERROR: PARAM must use a character format. ERROR: PARAM must use a character format. My data is like below

raja777pharma · ‎04-09-2020

Hello Team, I would like to display one var value in each RTF page starting after one line blank line, I would like show as per below screen shot on every page value is (Body Weight (kg)) But my out put is getting as per below ; I am using below code: Note: The each page display value var is "param" . proc Report data=report split='^' missing nowd spanrows headline headskip ; column gpxpage paramn param avisitn col1 gpx2 col2 col3 col4 col5 col6 col7 ; define gpxpage /order order=internal "" noprint; define paramn /group noprint; define param /group noprint; define avisitn /group noprint; define gpx2 /group noprint; define col1 /&Header. order order=internal style(column)=[cellwidth=2.in font_face=&fontf font_size=&fontsz just=l asis=on] style(hdr)=[just=l asis=on] flow; define col2 /"Parameter" order order=data style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=l asis=on] style(hdr)=[just=l asis=on] flow; define col3 /"Statistics" order order=data style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=l asis=on] style(hdr)=[just=l asis=on] flow; define col4 /&Header1. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; define col5 /&Header2. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; define col6 /&Header3. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; define col7 /&Header7. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; break after gpxpage / page; compute before gpxpage; line " "; endcomp; compute after gpx2; line " "; endcomp; compute before _PAGE_ / left; length text1 $100; if _BREAK_=' ' then do; text1="^{style[font_face=&fontf font_size=&fontsz}"||strip(param); end; line text1 $100.; endcomp; run;

raja777pharma · ‎04-02-2020

Hello Cheers, Thank your for replay , can we display COL1 as group where in COL1 it's showing two 'C1D1' , so we can display only one 'C1D1' Thank you.

raja777pharma · ‎04-02-2020

Hello Team, I am struggling to generate RTF as per below screen shot, My output is not coming as Group for COL1,COL2, and need to put blank line between (Break) COl1 after value 'Observed ' and 'Changed' Note : The data should be in sort order of vars – ‘gpxpage paramn avisitn catno’ In Below screen shot have more columns , but in my out put column are restricted and will come next RTF page I have attached the data set and same data set in excel sheet. I need output like below : My Current code and Output as below: data report; set table; if _n_ < 25 then gpxpage=1; else gpxpage=2; run; title; %prctmplt; %ttlmaker; ods listing close; ods &outype file="%sysfunc(pathname(out))\&outname2..&outype" style=acrsstyle ; run; ods escapechar = '^'; proc Report data=report split='^' missing nowd spanrows headline headskip ; column gpxpage paramn avisitn catno col1 col2 col3 col4 col5 col6 col7 ; define gpxpage /order order=internal "" noprint; define paramn /order order=internal "" noprint; define avisitn /order order=internal "" noprint; define catno /order order=internal "" noprint; define col1 /&Header group style(column)=[cellwidth=1.2in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col2 /"Parameter" group style(column)=[cellwidth=0.8in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col3 /"Statistics" style(column)=[cellwidth=0.9in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col4 /&Header1. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col5 /&Header2. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col6 /&Header3. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col7 /&Header99. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; break after gpxpage / page; compute before gpxpage; line " "; endcomp; run; My data set attached

raja777pharma · ‎04-02-2020

Hello Team, I am struggling to generate RTF as per below screen shot, My out put is not coming as Group for COL1,COL2, and need to put blank line between (Break) COl1 after value 'Observed ' and 'Changed' Note : The data should be in sort order of vars - gpxpage paramn avisitn catno In Below screen shot have more columns , but in my out put column are restricted and will come next RTF page I have attached the data set and same data set in excel sheet. I need output like below : My Current code : ods escapechar = '^'; proc Report data=report split='^' missing nowd spanrows headline headskip ; column gpxpage paramn avisitn catno col1 col2 col3 col4 col5 col6 col7 ; define gpxpage /order order=internal "" noprint; define paramn /order order=internal "" noprint; define avisitn /order order=internal "" noprint; define catno /order order=internal "" noprint; define col1 /&Header group style(column)=[cellwidth=1.2in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col2 /"Parameter" group style(column)=[cellwidth=0.8in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col3 /"Statistics" style(column)=[cellwidth=0.9in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col4 /&Header1. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col5 /&Header2. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col6 /&Header3. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col7 /&Header99. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; break after gpxpage / page; compute before gpxpage; line " "; endcomp; run; My Current output : Attached data set and same data in excel sheet

raja777pharma · ‎04-01-2020

Attached the data in a excel file and data set

raja777pharma · ‎04-01-2020

Hello Team , I am struggling to generate rtf based on group and break at specific lines in RTF I would like to genrate RTF as per below screen shot Want Output: My Code is below TO genrate RTF proc Report data=report split='^' missing nowd spanrows headline headskip ; column gpxpage paramn avisitn catno col1 col2 col3 col4 col5 col6 col7 ; define gpxpage /order order=internal "" noprint; define paramn /order order=internal "" noprint; define avisitn /order order=internal "" noprint; define catno /order order=internal "" noprint; define col1 /&Header group style(column)=[cellwidth=1.2in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col2 /"Parameter" group style(column)=[cellwidth=0.8in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col3 /"Statistics" style(column)=[cellwidth=0.9in font_face=Courier font_size=1.25just=l asis=on] style(hdr)=[just=l asis=on] flow; define col4 /&Header1. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col5 /&Header2. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col6 /&Header3. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; define col7 /&Header99. style(column)=[cellwidth=1in font_face=Courier font_size=1.25just=c asis=on] style(hdr)=[just=c asis=on]; break after gpxpage / page; compute before gpxpage; line " "; endcomp; run My Current Output : Key Points : The data should be sorting by : gpxpage paramn avisitn catno , The first COL1, COL2 to display Group and Break at COL2 after 'OBSERVER' and 'CHANGE' values I have included in report only limit columns (in Expected RTF column 7,8,9 no need) Please let me know how i can attache the data set , as of now data attached in excel file.

raja777pharma · ‎02-12-2020

Hello Team, I am facing order issue and group display in proc report. I need to rtf file output as per below screen shot 1 & 2 (both are same table but need in tow pages) and data was attached excel sheet i have created titles and foot notes In excel sheet also i mentioned rows orders (gpx gpx1) as per shell

raja777pharma · ‎02-03-2020

Thank you Yes it's worked perfectly

raja777pharma · ‎02-03-2020

Hello , As per below data table 01 would like to create two data sets (table 02 and 03) In one data set need to unique values if any location is selected then location_name values will be <var names> like in below table 02 , if any multiple locations marked then location_name have value = MULTIPLE for another data set need if any location_name have value = MULTIPLE then those multiple location number with chronological order like table 03 Note : Locations number will give chronological order like NY=1 , NJ=2 , CA=3 ..... Table 01: SUBNUM VISNAME TEST_DEC TESTDAT NY NJ CA CH DH HY MU LV BJ MS LN 001 VSIST1 X 16Apr2019 X 002 VSIST1 X 06May2019 X 002 VSIST2 X 13Jun2019 X 003 VSIST1 X 22Apr2019 X 004 VSIST1 X 11Sep2019 004 VSIST2 X 05Nov2019 X X 004 VSIST2 X 03Dec2019 005 VSIST1 X 12Dec2019 X X X 006 VSIST1 X 30Oct2019 007 VSIST1 X 23Oct2019 X 008 VSIST1 X 02Jan2020 X Data set 01/Table 02 : SUBNUM VISNAME TEST_DEC TESTDAT LOCATION_NAME YES/NO 001 VSIST1 YES 16Apr2019 CA YES 002 VSIST1 YES 06May2019 HY YES 002 VSIST2 YES 13Jun2019 CH YES 003 VSIST1 YES 22Apr2019 CH YES 004 VSIST1 YES 11Sep2019 MISSING NO 004 VSIST2 YES 05Nov2019 MULTIPLE YES 004 VSIST2 YES 03Dec2019 MISSING NO 005 VSIST1 YES 12Dec2019 MULTIPLE YES 006 VSIST1 YES 30Oct2019 MS YES 007 VSIST1 YES 23Oct2019 CA YES 008 VSIST1 YES 02Jan2020 BJ YES Data set 03 /Table 03: SUBNUM VISNAME TEST_DEC TESTDAT LOCATION_NAME YES/NO 004 VSIST2 YES 05Nov2019 LOC_4 YES 004 VSIST2 YES 05Nov2019 LOC_6 YES 005 VSIST1 X 12Dec2019 LOC_5 YES 005 VSIST1 X 12Dec2019 LOC_8 YES 005 VSIST1 X 12Dec2019 LOC_10 YES

raja777pharma · ‎01-30-2020

Hello ed_sas_memebr , Thank you for answer . for table three purpose is if any TRT value is multiple , then we have to know what are multiple values are checked and out the same value in to another variable , in that means TYPE can value is TRT1-3.

raja777pharma · ‎01-30-2020

Hello , As per below data table 01 and want to create new data as table 02 if subject have three catergory's TEST,EXTRA and MORE , each in catergory again they three values CT ,MRI and other if subject had any one of CT , MRI or OTH marked then in New data TYPE is <TEST or EXTRA or MORE or> and TRT is <CT_01 or MRI_02 or OTH_03 > if subject had mraked two are above then TRT is <multiple> I want one more data table 03 , as in if any TRT value is multiple then TRT_MULTPLE value will be <TRT_CT_MRI> as shown in below table 03 Table 01 : Exist data Table 02 : Want new data as per above conditions <New data set 01> Table 03 : Want new data as per above conditions <new data set 02> Table 01 : SUBNUM VISNAME TEST_DEC TESTDAT TESTCT TESTMRI TEST_OTH EXTRA_DEC EXTRADAT EXTRACT EXTRAMRI EXTRAOTH MORE_DEC MOREDAT MORECT MOREMRI MOREOTH 001 VSIST1 Yes 16Apr2019 X Yes 16Apr2019 X Yes 16Apr2019 X 002 VSIST1 Yes 06May2019 X Yes 06May2019 X Yes 06May2019 X 002 VSIST2 Yes 13Jun2019 X Yes 13Jun2019 X Yes 13Jun2019 X X 003 VSIST1 Yes 22Apr2019 X Yes 22Apr2019 X Yes 22Apr2019 X X 004 VSIST1 Yes 11Sep2019 X Yes 11Sep2019 X Yes 11Sep2019 X 004 VSIST2 Yes 05Nov2019 X Yes 05Nov2019 X Yes 05Nov2019 X 004 VSIST2 Yes 03Dec2019 X Yes 03Dec2019 X Yes 03Dec2019 X 005 VSIST1 Yes 12Dec2019 X Yes 12Dec2019 X Yes 12Dec2019 X 006 VSIST1 Yes 30Oct2019 X Yes 30Oct2019 X Yes 30Oct2019 X X 007 VSIST1 Yes 23Oct2019 X Yes 23Oct2019 X Yes 23Oct2019 X 008 VSIST1 Yes 02Jan2020 X Yes 02Jan2020 X Yes 02Jan2020 X Table 02 : New data set need to create as per above data : SUBNUM VISNAME DATE TYPE TRT 001 VSIST1 16Apr2019 TEST CT_01 002 VSIST1 06May2019 TEST CT_01 002 VSIST2 13Jun2019 TEST CT_01 003 VSIST1 22Apr2019 TEST CT_01 004 VSIST1 11Sep2019 TEST CT_01 004 VSIST2 05Nov2019 TEST CT_01 004 VSIST2 03Dec2019 TEST CT_01 005 VSIST1 12Dec2019 TEST CT_01 006 VSIST1 30Oct2019 TEST CT_01 007 VSIST1 23Oct2019 TEST CT_01 008 VSIST1 02Jan2020 TEST CT_01 001 VSIST1 16Apr2019 EXTRA MRI_02 002 VSIST1 06May2019 EXTRA MRI_02 002 VSIST2 13Jun2019 EXTRA MRI_02 003 VSIST1 22Apr2019 EXTRA MRI_02 004 VSIST1 11Sep2019 EXTRA MRI_02 004 VSIST2 05Nov2019 EXTRA MRI_02 004 VSIST2 03Dec2019 EXTRA MRI_02 005 VSIST1 12Dec2019 EXTRA MRI_02 006 VSIST1 30Oct2019 EXTRA MRI_02 007 VSIST1 23Oct2019 EXTRA MRI_02 008 VSIST1 02Jan2020 EXTRA MRI_02 001 VSIST1 16Apr2019 MORE CT_01 002 VSIST1 06May2019 MORE CT_01 002 VSIST2 13Jun2019 MORE MULTIPLE 003 VSIST1 22Apr2019 MORE MULTIPLE 004 VSIST1 11Sep2019 MORE CT_01 004 VSIST2 05Nov2019 MORE CT_01 004 VSIST2 03Dec2019 MORE CT_01 005 VSIST1 12Dec2019 MORE CT_01 006 VSIST1 30Oct2019 MORE MULTIPLE 007 VSIST1 23Oct2019 MORE CT_01 008 VSIST1 02Jan2020 MORE CT_01 Table 03 : New data set need to create based on table 01 SUBNUM VISNAME DATE TYPE TRT_MULTIPLE 001 VSIST1 16Apr2019 TEST CT_01 002 VSIST1 06May2019 TEST CT_01 002 VSIST2 13Jun2019 TEST CT_01 003 VSIST1 22Apr2019 TEST TRT_CT_MRI 004 VSIST1 11Sep2019 TEST TRT_CT_MRI 004 VSIST2 05Nov2019 TEST CT_01 004 VSIST2 03Dec2019 TEST CT_01 005 VSIST1 12Dec2019 TEST CT_01 006 VSIST1 30Oct2019 TEST TRT_CT_OTH 007 VSIST1 23Oct2019 TEST CT_01 008 VSIST1 02Jan2020 TEST CT_01

raja777pharma · ‎01-28-2020

Hello Please help to get NEW_VAR based on C_01 to C_07 var values if Only C_03 value as 'x' then NEW_VAR value will be the variable name and value if more than value 'x' in C_01 to C_07 then New_var value will be 'Multiple' can we code this in array or any simple code ? SUBJID C_01 C_02 C_03 C_04 C_05 C_06 C_07 New_Var 10001 10002 x C_03_X 10003 x C_06_X 10004 x x Multiple 10005 x C_02_X 10006

Online Status	Offline
Date Last Visited	Thursday

How to Calculate the Standardized Mean Difference between two treatmen...

WaterFall Chart Dummy legend display if no data

Assing Value based on Dates Range

How to order the Bars and display the labels from other var in PROC SG...

Re: Assign Flag as minimum value , if same value then last records fla...

how to assign the decremental seq and up to 3

Re: Assign Flag as minimum value , if same value then last records fla...

Assign Flag as minimum value , if same value then last records flag

How to Flag last hour records by group vars

Re: How to take first three different reocrds values in one observatio...

Re: array_Assign new var based on multiple var values

Re: Transpose Data Based on value

Assign max lenght per common variable across all data sets which have ...

Re: Proc report | show group value in Each page starting

Re: Proc report | show group value in Each page starting

Proc report | show group value in Each page starting

Re: Proc report RTF Grouping and Break

Proc Report Break & Group

Proc report RTF Grouping and Break

Re: Proc Report Break and Group

Proc Report Break and Group

Proc report

Re: array or transpose for data

array or transpose for data

Re: Array and Transpose based on data values

Array and Transpose based on data values

array_Assign new var based on multiple var values