cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RAVI2000
‎06-06-2023
  • 171 Posts
  • 102 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: Add superscript at value level for graphs

by Lapis Lazuli | Level 10 in Graphics Programming
‎06-06-2023 02:55 PM
‎06-06-2023 02:55 PM
where do we exactly specify the font? ... View more

Re: Add superscript at value level for graphs

by Lapis Lazuli | Level 10 in Graphics Programming
‎05-22-2023 04:41 PM
‎05-22-2023 04:41 PM
Can I do something similar using proc template & SGRENDER? ... View more

Add superscript at value level for graphs

by Lapis Lazuli | Level 10 in Graphics Programming
‎05-22-2023 03:59 PM
‎05-22-2023 03:59 PM
Hello everyone,   I would like to  add superscript "a" at value level for "Occurred".    proc format;     value occur         0="Not Occured"         2="Occured(*ESC*){unicode '1D43'x}"; run; proc sort data= adsl out=adsl(keep= usubjid bmkfl trt01a trt01an); by usubjid; where bmkfl='Y'; run; proc sort data=adbmk out=adbmk(keep=usubjid param paramcd fchg maxstom stopopfl); by usubjid paramcd avisitn avisit;     where bmkfl='Y' and paramcd = "LO" and ablfl ne 'Y' and anl03fl='Y'; run; data adbmk_stom;   merge adsl(in=a drop=trt01a trt01an) adbmk(in=b); length trt01a $25;   by usubjid; if a and b; *aval=abs(aval); if stopopfl ne 'Y' then do; trt01an=0; trt01a="Not Occured"; end; else if maxstom ge 1 then do; trt01an=2; trt01a="Occured(*ESC*){unicode '1D43'x}"; end; else trt01a=''; if trt01a ne ''; run; data boxdat; set adbmk_stom; format trtan occur.; run; proc sort data=boxdat; by trt01an; run; proc template; define statgraph stomcyt; begingraph; layout overlay / xaxisopts=(label="Occurance of Stomatitis Event" display=(label line ticks tickvalues) linearopts=(tickvaluelist=( 0 2) viewmin=0 viewmax=2)                    discreteopts=(tickvaluefitpolicy=split)) yaxisopts=(type=log display=(label line ticks tickvalues) labelsplitchar="#" labelfitpolicy=splitalways label = "Dicarbo hyderorotate" linearopts=(tickvaluelist=(0  1 10 100 1000) viewmin=-0 viewmax=1000)); boxplot x=trt01a y=fchg / boxwidth=.25 fillattrs=(color=white) whiskerattrs=graphdata1 display=(CAPS FILL MEDIAN OUTLIERS); scatterplot x=trt01a y=fchg / jitter=auto MARKERATTRS=(symbol=circle color=red) ; endlayout; endgraph; end; run;   ods listing image_dpi=300 gpath="path"; ods graphics / reset border=off width=8in height=4.5in imagename="stomcyt"; proc sgrender data=boxdat template="stomcyt" ; run; /* format trtan occur.; */ ods listing close; ods graphics off;     ... View more

Re: Covert the first observation values to variabale names

by Lapis Lazuli | Level 10 in SAS Programming
‎11-29-2022 05:33 PM
‎11-29-2022 05:33 PM
Thank you very much @Tom It really helped me alot! ... View more

Re: Covert the first observation values to variabale names

by Lapis Lazuli | Level 10 in SAS Programming
‎11-29-2022 05:15 PM
‎11-29-2022 05:15 PM
What option in proc import do I specify for it? I have tried it with range and datarow options. I didn't get exact row of the data that I am looking for. This excel has the variables values in the first observation. But other sheet have the values in 4th , 5th observations. ... View more

Re: Covert the first observation values to variabale names

by Lapis Lazuli | Level 10 in SAS Programming
‎11-29-2022 05:10 PM
‎11-29-2022 05:10 PM
Yes, going forward we have raised a request. That is really not a good data to work on with. ... View more

Re: Covert the first observation values to variabale names

by Lapis Lazuli | Level 10 in SAS Programming
‎11-29-2022 05:05 PM
‎11-29-2022 05:05 PM
I have tried your code, and I work on cloud studio. The "filename" statement is not reading the correct temp path.   ... View more

Re: Covert the first observation values to variabale names

by Lapis Lazuli | Level 10 in SAS Programming
‎11-29-2022 04:42 PM
‎11-29-2022 04:42 PM
Thanks @Tom It was imported from excel, I didn't create it. It comes from a different team and I cannot edit it. I can only import and then do more modifications. ... View more

Covert the first observation values to variabale names

by Lapis Lazuli | Level 10 in SAS Programming
‎11-29-2022 04:23 PM
‎11-29-2022 04:23 PM
Hello everyone,   I have a sas dataset that has values like below.   The variable name "LSIDEM01_Listing_of_Subject_Dem" is very big. I want the observation 1 values to be variable names for all the B, C, D, E, F, G, H....       ... View more

Re: first. last. and comparing with previous observation

by Lapis Lazuli | Level 10 in SAS Programming
‎11-16-2022 10:57 AM
‎11-16-2022 10:57 AM
You're right @Kurt_Bremser, I was looking at other obs and gave the wrong example. Could you please consider the other cases where it is incorrect like obs 3 and so on? ... View more

Re: first. last. and comparing with previous observation

by Lapis Lazuli | Level 10 in SAS Programming
‎11-15-2022 11:40 AM
‎11-15-2022 11:40 AM
I have provided it in the above, thats all i have used for now! ... View more

Re: first. last. and comparing with previous observation

by Lapis Lazuli | Level 10 in SAS Programming
‎11-15-2022 10:53 AM
‎11-15-2022 10:53 AM
ohh, i missed OUTPUT option in between. i want to output all the records to adae3 ... View more

first. last. and comparing with previous observation

by Lapis Lazuli | Level 10 in SAS Programming
‎11-15-2022 10:13 AM
‎11-15-2022 10:13 AM
Hello all, I would like to output records of AEOUT which are being collected incorrectly for the same AEDECOD. For instance, consider the 1st row obs AETOXGR = 2 and has AEOUT="NOT RECOVERED/NOT RESOLVED. The next 2nd row obs has AETOXGR=3 with AEOUT = "NOT RECOVERED/NOT RESOLVED". This is incorrect, the 2nd row obs should instead have "NOT RECOVERED/NOT RESOLVED" since the AETOXGR is increasing 2 to 3. And vice-versa, where the 2nd row obs AETOXGR = 3 and AEOUT="NOT RECOVERED/NOT RESOLVED" and the 3rd row obs with AETOXGR = 2 have AEOUT="NOT RECOVERED/NOT RESOLVED", instead the 3rd row obs should have been "RECOVERING/RESOLVING" since the AETOXGR is being decreased from 3 to 2. Below is the sample data. SUBJID GRPID AESTDTC AEENDTC AEDECOD AEOUT SSEQ AETOXGR 100012 1 2021-03-25 2021-04-13 Anaemia NOT RECOVERED/NOT RESOLVED 1.1 2 100012 1 2021-04-14 2021-04-21 Anaemia NOT RECOVERED/NOT RESOLVED 1.2 3 100012 1 2021-04-22 2021-04-27 Anaemia NOT RECOVERED/NOT RESOLVED 1.3 2 100012 1 2021-04-28 2021-05-04 Anaemia RECOVERING/RESOLVING 1.4 3 100012 1 2021-05-05 2021-05-10 Anaemia NOT RECOVERED/NOT RESOLVED 1.5 2 100012 1 2021-05-11 2021-05-17 Anaemia RECOVERING/RESOLVING 1.6 3 100012 1 2021-05-17 2021-05-25 Anaemia NOT RECOVERED/NOT RESOLVED 1.7 2 100012 1 2021-05-26 2021-06-03 Anaemia RECOVERING/RESOLVING 1.8 3 100012 1 2021-06-04 2021-06-09 Anaemia RECOVERING/RESOLVING 1.9 2 100012 1 2021-06-10 2021-06-15 Anaemia NOT RECOVERED/NOT RESOLVED 1.10 1 100012 1 2021-06-16 2021-07-05 Anaemia NOT RECOVERED/NOT RESOLVED 1.11 2 100012 1 2021-07-06 2021-08-05 Anaemia RECOVERING/RESOLVING 1.12 3 100012 1 2021-08-06 2021-08-15 Anaemia NOT RECOVERED/NOT RESOLVED 1.13 2 100012 1 2021-08-16 2021-08-22 Anaemia RECOVERING/RESOLVING 1.14 3 100012 1 2021-08-23 2021-08-29 Anaemia NOT RECOVERED/NOT RESOLVED 1.15 2 100012 1 2021-08-30 2021-09-06 Anaemia RECOVERING/RESOLVING 1.16 3 100012 1 2021-09-07 2021-09-13 Anaemia NOT RECOVERED/NOT RESOLVED 1.17 2 100012 1 2021-09-14 2021-10-03 Anaemia RECOVERING/RESOLVING 1.18 3 100012 1 2021-10-04 2021-10-10 Anaemia NOT RECOVERED/NOT RESOLVED 1.19 2 100012 1 2021-10-11 Anaemia NOT RECOVERED/NOT RESOLVED 1.20 3 100012 3 2021-02-21 2021-02-21 Thrombocytopenia RECOVERED/RESOLVED 2.1 4 100012 4 2021-03-03 2021-03-08 Thrombocytopenia RECOVERING/RESOLVING 3.1 3 100012 4 2021-03-09 2021-03-15 Thrombocytopenia RECOVERING/RESOLVING 3.2 2 100012 4 2021-03-16 2021-03-23 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.3 1 100012 4 2021-03-24 2021-04-07 Thrombocytopenia RECOVERING/RESOLVING 3.4 2 100012 4 2021-04-08 2021-04-21 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.5 1 100012 4 2021-04-22 2021-04-27 Thrombocytopenia RECOVERING/RESOLVING 3.6 2 100012 4 2021-04-28 2021-05-04 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.7 1 100012 4 2021-05-05 2021-05-10 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.8 2 100012 4 2021-05-11 2021-06-09 Thrombocytopenia RECOVERING/RESOLVING 3.9 3 100012 4 2021-06-10 2021-06-15 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.10 2 100012 4 2021-06-16 2021-07-05 Thrombocytopenia RECOVERING/RESOLVING 3.11 3 100012 4 2021-07-06 2021-07-27 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.12 2 100012 4 2021-07-28 2021-08-29 Thrombocytopenia NOT RECOVERED/NOT RESOLVED 3.13 3 100012 4 2021-08-30 2021-10-21 Thrombocytopenia RECOVERING/RESOLVING 3.14 4 NOTE: obs 21 have sseq as 2.1 and obs 22 has sseq 3.1 with same AEDECOD(Thrombocytopenia)). SSEQ is derived as : "All event records of same AEDECOD from the same subject are linked by the AESTDTC and AEENDTC. If an event is followed by another event with same AEDECOD with and AESTDTC the same day or 1 day after the AEENDTC of the previous record.   I have tried the below code. data adae2 adae3; set adae1; retain grade; by subjid aedecod aestdtc aeendtc; if first.aedecod then grade=aetoxgr; if last.aedecod and aetoxgr lt grade then adae3; run; I was only able to satisfy one condition. Please suggest an appropriate method. ... View more

Re: select all the records where there is multiple records for flag

by Lapis Lazuli | Level 10 in SAS Programming
‎10-19-2022 02:58 PM
‎10-19-2022 02:58 PM
The "BLFL" is a character variable. Sorry I have mistakenly give "." instead of blank spaces. With your code I was able to extract the records that have multiple BLFL = "Y". But the records that have missing/ blank values are not being extracted. My output looks something like below after using your code. subjid testcd blfl 1 ALB Y 1 ALB Y 2 ALP Y 2 ALP Y 3 ALP Y 3 ALP Y 3 ALP Y 4 ALP Y 4 ALP Y 4 ALP Y 4 ALT Y 4 ALT Y For example, I also want to include the first three obs of the blank records of the BLFL along with the BLFL = "Y" for a particular testcd. Again, I want to extract the data where there are multiple records per testcd. The 1st testcd "ALB" with subjid "1" is considered since there is 2(multiple) "Y" flags for "BLFL". The "ALB" for subjid "4" is not considered because only one "BLFL" is present. Note: whenever there are multiple blfl, I want all the records for that testcd including the missing values of BLFL. ... View more

Re: select all the records where there is multiple records for flag

by Lapis Lazuli | Level 10 in SAS Programming
‎10-19-2022 11:01 AM
‎10-19-2022 11:01 AM
Hi Tom, Thanks for the insight. Does this also include missing . values as well? What I want here is, for instance if you consider the testcd ALB for subject 1, it has multiple "Y" values for that testcd. I want to output all the records which also include the missing values of the "BLFL" as well. Where ever we have multiple records of "Y" per testcd, I want to output all the records for that subject. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-06-2023 06:16 PM
Likes given to
Likes from
View All
Quick links