About mona4u

mona4u · ‎12-18-2018

Hi all, I have this data set which I used proc transpose to flip it but I still not able to get the results that I want because of the Qlabel Values. I want to get the labels of the variables. I thought about if I use if Qname=".."then Qlabel="..." but I want to check if I there are shortcuts to get the label names my data USUBJID StID CRFID IDVAR IDVARVAL QORIG QEVAL A3921024 1006 10061050 A3921024 1006 2650261 AESEQ 1 CRF the result that I am targeting QNAME QVAL QLABEL IDVAR IDVARVAL QORIG QEVAL USUBJID A3921024 1006 10061050 SUBJECT ID AESEQ 1 CRF StID A3921024 1006 Site id AESEQ 1 CRF CRFID 2650261 Crf ID AESEQ 1 CRF

mona4u · ‎12-11-2018

Hi all, I am trying to convert a character date to yyyy-mm-dd data format this is a sample of the data that I have data have; input start_date $; datalines; 15/Nov/2015 ;

mona4u · ‎12-10-2018

Hi ALL, I have some issues with some of the records that I have. The stdt and ptnm have multiple values in the same row and I want to split the stdt and ptnm values in multiple records this is what I currently have Prot StID SubID CRFID ISubID PACN RevTp VstDt VstID AERef PtNm LltNm StDt A3921133 A3921133 1134 A3921133 1134 11341049 3409741 144893 H1604060 Consensus 09/Feb/2016 823129 2 Sequential AST or ALT >= 3x ULN,2 Sequential AST or ALT >= 3x ULN,Liver injury; 03/Mar/2016,14/Mar/2016,09/Feb/2016 the aimed result Prot StID SubID CRFID ISubID PACN RevTp VstDt VstID AERef PtNm LltNm StDt A3921133 A3921133 1134 A3921133 1134 11341049 3409741 144893 H1604060 Consensus 09/Feb/2016 823129 2 Sequential AST or ALT >= 3x ULN 03/Mar/2016 A3921133 A3921133 1134 A3921133 1134 11341049 3409741 144893 H1604060 Consensus 09/Feb/2016 823129 2 Sequential AST or ALT >= 3x ULN 14/Mar/2016 A3921133 A3921133 1134 A3921133 1134 11341049 3409741 144893 H1604060 Consensus 09/Feb/2016 823129 Liver injury; 09/Feb/2016

mona4u · ‎08-28-2018

the last update was totally correct but I'm so sorry for the last minute request. My manager just told me that I need also to map R3010 to NT10 R3011 to NT11 R3012 to NT12 ....... R3020 to NT20 ... etc. Can you help me with this as well? this is a mock-up data data have; length SUbJID $7 LESNID $5; input SUbJID $ LESNID $; datalines; C12-123 R101 C12-123 R102 C12-123 R201 C12-123 R301 C12-123 R401 C12-123 R101 C12-123 R102 C12-123 R201 C12-123 R301 C12-123 R401 C12-124 R201 C12-124 R401 C12-124 R201 C12-124 R401 C12-124 R201 C12-124 R401 C12-124 R201 C12-125 R101 C12-125 R101 C12-126 R201 C12-126 R301 C12-126 R201 C12-126 R301 C12-126 R201 C12-126 R301 C12-789 R301 C12-789 R301 C12-789 R301 C12-789 R301 C14-011 R101 C14-011 R201 C14-011 R301 C14-011 R101 C14-011 R201 C14-011 R301 C14-011 R101 C14-011 R201 C14-011 R301 C14-012 R101 C14-012 R201 C14-012 R301 C14-012 R101 C14-012 R201 C14-012 R301 C14-012 R101 C14-012 R201 C14-012 R301 C14-013 R101 C14-013 R201 C14-013 R301 C14-013 R101 C14-013 R201 C14-013 R301 C14-013 R101 C14-013 R201 C14-013 R301 C14-013 R101 C14-013 R201 C14-013 R301 C14-014 R101 C14-014 R201 C14-014 R301 C14-014 R101 C14-014 R201 C14-014 R301 C14-014 R101 C14-014 R201 C14-014 R301 C14-014 R101 C14-014 R201 C14-014 R301 C14-015 R101 C14-015 R201 C14-015 R301 C14-015 R101 C14-015 R201 C14-015 R301 C14-015 R101 C14-015 R201 C14-015 R301 C14-016 R101 C14-016 R201 C14-016 R301 C14-016 R101 C14-016 R201 C14-016 R301 C14-016 R101 C14-016 R201 C14-016 R301 C14-016 R101 C14-016 R201 C14-016 R301 C14-017 R101 C14-017 R102 C14-017 R201 C14-017 R101 C14-017 R102 C14-017 R201 C14-017 R101 C14-017 R102 C14-017 R201 C14-017 R101 C14-017 R102 C14-017 R201 C14-018 R101 C14-018 R201 C14-018 R101 C14-018 R201 C14-018 R101 C14-018 R201 C14-018 R101 C14-018 R201 C14-022 R101 C14-022 R201 C14-022 R301 C14-022 R101 C14-022 R201 C14-022 R301 C14-022 R101 C14-022 R201 C14-022 R301 C14-022 R101 C14-022 R201 C14-022 R301 C14-023 R101 C14-023 R201 C14-023 R301 C14-023 R101 C14-023 R201 C14-023 R301 C14-023 R101 C14-023 R201 C14-023 R301 C14-023 R101 C14-023 R201 C14-023 R301 C14-024 R101 C14-024 R201 C14-024 R301 C14-024 R101 C14-024 R201 C14-024 R301 C14-024 R101 C14-024 R201 C14-024 R301 C14-024 R101 C14-024 R201 C14-024 R301 C14-025 R101 C14-025 R201 C14-025 R301 C14-025 R101 C14-025 R201 C14-025 R301 C14-025 R101 C14-025 R201 C14-025 R301 C14-025 R101 C14-025 R201 C14-025 R301 C14-026 R101 C14-026 R201 C14-026 R301 C14-026 R101 C14-026 R201 C14-026 R301 C14-026 R101 C14-026 R201 C14-026 R301 C14-027 R101 C14-027 R201 C14-027 R301 C14-027 R101 C14-027 R201 C14-027 R301 C14-027 R101 C14-027 R201 C14-027 R301 C14-027 R101 C14-027 R201 C14-027 R301 C14-028 R101 C14-028 R102 C14-028 R201 C14-028 R301 C14-028 R101 C14-028 R102 C14-028 R201 C14-028 R301 C14-056 R101 C14-056 R201 C14-056 R101 C14-056 R201 C14-056 R401 C14-056 R101 C14-056 R201 C14-060 R101 C14-060 R201 C14-060 R202 C14-060 R301 C14-060 R303 C14-060 R304 C14-060 R305 C14-060 R307 C14-060 R3010 C14-060 R3011 C14-060 R3012 C14-060 R101 C14-060 R201 C14-060 R202 C14-060 R301 C14-060 R303 C14-060 R304 C14-060 R305 C14-060 R307 C14-060 R3010 C14-060 R3011 C14-060 R3012 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C99-001 R101 C99-001 R102 C99-001 R201 C99-001 R202 C99-001 R301 ; run;

mona4u · ‎08-28-2018

I tried the code and It didn't work with some cases SUbJID LESNID converted Should be C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-125 R101 TL01 TL01 C12-125 R101 TL02 TL01 C12-126 R201 TL01 C12-126 R301 NT01 C12-126 R201 TL01 C12-126 R301 NT01 C12-126 R201 TL01 C12-126 R301 NT01 C12-789 R301 NT01 C12-789 R301 NT02 NTO1 C12-789 R301 NT03 NTO1 C12-789 R301 NT04 NTO1 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01

mona4u · ‎08-28-2018

sorry for taking the time to get back to you today I tried to validate the program with a big data set and I found that there is issue with the conversion with some cases SUbJID LESNID converted should be C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-125 R101 TL01 C12-125 R101 TL02 C12-126 R201 TL01 C12-126 R301 NT01 C12-126 R201 TL01 C12-126 R301 NT01 C12-126 R201 TL01 C12-126 R301 NT01 C12-789 R301 NT01 NT01 C12-789 R301 NT02 NT01 C12-789 R301 NT03 NT01 C12-789 R301 NT04 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-015 R101 TL01 C14-015 R201 TL02 C14-015 R301 NT01 C14-015 R101 TL01 C14-015 R201 TL02 C14-015 R301 NT01 C14-015 R101 TL01 C14-015 R201 TL02 C14-015 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-017 R101 TL01 TL01 C14-017 R102 TL02 TL02 C14-017 R201 TL03 TL03 C14-017 R101 TL04 TL01 C14-017 R102 TL05 TL02 C14-017 R201 TL06 TL03 C14-017 R101 TL07 TL01 C14-017 R102 TL08 TL02 C14-017 R201 TL09 TL03 C14-017 R101 TL10 TL01 C14-017 R102 TL11 TL02 C14-017 R201 TL12 TL03 Can you take a look and fix the issue for me ?

mona4u · ‎08-28-2018

I have this issue with the data set I'm basically want to get this result from the data set I posted below. the way the variable converted came within subjid R101=TL01 and R102=TL02 .....ETC. But the confusing part is R20X take the next number available after R10X conversion for example if TL02 already reserved the R201 will convert to TL03, R202 converts to TL04. R301 convert to NT01 R302 converts to NTO2 .. ETC. R401 converts to NL01 and R402 converts to NL02. This is the full requirement

mona4u · ‎08-28-2018

sorry for taking the time to get back to you today I tried to validate the program with a big data set and I found that there is issue with the conversion with some cases SUbJID LESNID converted should be C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-124 R401 NL01 C12-124 R201 TL01 C12-125 R101 TL01 C12-125 R101 TL02 C12-126 R201 TL01 C12-126 R301 NT01 C12-126 R201 TL01 C12-126 R301 NT01 C12-126 R201 TL01 C12-126 R301 NT01 C12-789 R301 NT01 NT01 C12-789 R301 NT02 NT01 C12-789 R301 NT03 NT01 C12-789 R301 NT04 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-011 R101 TL01 C14-011 R201 TL02 C14-011 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-012 R101 TL01 C14-012 R201 TL02 C14-012 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-013 R101 TL01 C14-013 R201 TL02 C14-013 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-014 R101 TL01 C14-014 R201 TL02 C14-014 R301 NT01 C14-015 R101 TL01 C14-015 R201 TL02 C14-015 R301 NT01 C14-015 R101 TL01 C14-015 R201 TL02 C14-015 R301 NT01 C14-015 R101 TL01 C14-015 R201 TL02 C14-015 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-016 R101 TL01 C14-016 R201 TL02 C14-016 R301 NT01 C14-017 R101 TL01 TL01 C14-017 R102 TL02 TL02 C14-017 R201 TL03 TL03 C14-017 R101 TL04 TL01 C14-017 R102 TL05 TL02 C14-017 R201 TL06 TL03 C14-017 R101 TL07 TL01 C14-017 R102 TL08 TL02 C14-017 R201 TL09 TL03 C14-017 R101 TL10 TL01 C14-017 R102 TL11 TL02 C14-017 R201 TL12 TL03 Can you take a look and fix the issue for me ?

mona4u · ‎08-20-2018

I have this issue with the data set I'm basically want to get this result from the data set I posted below. the way the variable converted came within subjid R101=TL01 and R102=TL02 .....ETC. But the confusing part is R20X take the next number available after R10X conversion for example if TL02 already reserved the R201 will convert to TL03, R202 converts to TL04. R301 convert to NT01 R302 converts to NTO2 .. ETC. R401 converts to NL01 and R402 converts to NL02. here is the example SUBJID LESNID Converted C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R301 NT01 C12-123 R401 NL01 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R301 NT01 C14-062 R401 NL01 C14-062 R402 NL02 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R301 NT01 C14-062 R401 NL01 C14-062 R402 NL02 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R301 NT01 C14-062 R401 NL01 C14-062 R402 NL02 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R301 NT01 this is a sample of the data I have data have; length SUbJID $7 LESNID $5; input SUbJID $ LESNID $; datalines; C12-123 R101 C12-123 R102 C12-123 R201 C12-123 R301 C12-123 R401 C12-123 R101 C12-123 R102 C12-123 R201 C12-123 R301 C12-123 R401 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301 C14-062 R401 C14-062 R402 C14-062 R101 C14-062 R201 C14-062 R301; run;

mona4u · ‎08-09-2018

R301 convert to NT01 R302 converts to NTO2 .. ETC. R401 converts to NL01 R402 converts to NL02

mona4u · ‎08-08-2018

The two soln are really good. I have to figure them out bc I have to convert R301 and 401 too.

mona4u · ‎08-07-2018

I have this issue with the data set I'm basically want to get this result from the data set I posted below. the way the variable converted came within subjid R101=TL01 and R102=TL02 .....ETC. But the confusing part is R20X take the next number available after R10X conversion for example if TL02 already reserved the R201 will convert to TL03, R202 converts to TL04 the aim SUBJID LESNID Converted C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C12-123 R101 TL01 C12-123 R102 TL02 C12-123 R201 TL03 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R101 TL01 C14-062 R201 TL02 C14-062 R101 TL01 C14-062 R201 TL02 this is a sample of the data I have length SUbJID $7 LESNID $5; input SUbJID $ LESNID $; datalines; C12-123 R101 C12-123 R102 C12-123 R201 C12-123 R101 C12-123 R102 C12-123 R201 C14-062 R101 C14-062 R201 C14-062 R101 C14-062 R201 C14-062 R101 C14-062 R201 C14-062 R101 C14-062 R201 ;

mona4u · ‎07-20-2018

it didn't work

mona4u · ‎07-20-2018

i tried this code ods csvall file="&output\A678_20110265_irrc_recist_NL_2018Jul18.txt" options(delimiter='|'); title; proc print data=irr_nl_1 noobs; run; ods csvall close; but it gave me " " in the character variables

mona4u · ‎07-20-2018

I need to know how to output data as txt pipe delimited in sas

Online Status	Offline
Date Last Visited	‎10-06-2022 12:13 PM

how to output different data to different pdf files

random statement

Re: merge statement error

Re: merge statement error

Re: merge statement error

merge statement error

lsmeans one side inference

Re: substract data from different rows

substract data from different rows

Proc correlation matrix with p and r plots

Re: WARNING: Multiple lengths were specified for the BY variable WEEK_...

Re: merge statement error

Re: lsmeans one side inference

Re: lsmeans one side inference

Re: substract data from different rows

Proc correlation matrix with p and r plots

Re: creating a macro of month names

Proc transpose and extract the labels

convert character date to yyyy-mm-dd date format

Splitting record into multiple records

Re: complicated conversion

Re: complicated conversion

Re: complicated conversion

Re: complicated conversion

Re: complicated conversion

complicated conversion

Re: complicated problem

Re: complicated problem

complicated problem

Re: how to output data as txt pipe delimited in sas

Re: how to output data as txt pipe delimited in sas

how to output data as txt pipe delimited in sas