About knveraraju91

knveraraju91 · ‎12-01-2021

Dear, In my data I need to concatenate four variables. The output should have all values aligned in all rows to display in table. Please suggest. Thank you output needed; 31(25) 37(14) 80.6 8.3 11(2) 12(7) 37.8 8.2 output getting 31(25) 37(14) 80.6 8.3 11(2) 12(7) 37.8 8.2 data hav; input c1 $1-6 c2 $8-13 r1 $15-18 r2 $21-23 ; datalines; 31(25) 37(14) 80.6 58.3 11(2) 12(7) 37.8 18.2 ; data want; set hav; tot=c1||" "||c2||" "||r1||" "||r2; run;

knveraraju91 · ‎09-21-2021

Dear, I need suggestion in Proc transpose step. Please suggest to get the out put needed. data one; input trt$ aval$ nobs pct; datalines; a complete 10 20 a disconti 20 40 b complete 20 40 b disconti 10 20 ; output need; aval a_nobs b_nobs a_pct b_pct complete 10 20 20 40 disconti 20 10 40 20

knveraraju91 · ‎08-09-2021

Dear, I need help in my pgm to get the output i need. I need to create a numeric variable 'b' from char variable 'a' output need 15.22 33.22 please suggest. Thank you data have; input a $20.; datalines; CYCLE 15 DAY 22 CYCLE 33 DAY 22 ; data want; set have; b=compress(a,'','kd'); run;

knveraraju91 · ‎07-19-2021

Dear I need help in my pgm to output only records that contain 'OTHER'. In the my data, there is one record with 'OTHER'. In the output dataset 'TWO' I am getting three records. Please suggest data one; input a $40.; datalines; contains OTHER contains CHEMOTHERAPY contains IMMUNOTHERAPY contains IMMUNO ; DATA TWO; SET ONE; IF index(UPCASE(A),'OTHER'); RUN; output need contains OTHER

knveraraju91 · ‎06-21-2021

Dear, I came across a situation where I used macro variables in my pgm created by using macro function %str. I got error. when I removed %str function I did not get error. Please help me understand. Thank you I created 4 macro variables. Two using %str function. Other two not. When I run %one macro using macro variables created using %str function. I am getting error. But when i run with other two, I am not. Please help. %let gm_ba = %str(03) ; %let gm_snum = %str(a0310) ; %let gm_ca = 03 ; %let gm_tnum = a0310 ; data aaa; input a $ b; datalines; a 1 b 2 c 3 ; %macro one; data c&gm_ba&gm_snum.01; set aaa; run; %mend; %one; %macro one; data c&gm_ca&gm_tnum.01; set aaa; run; %mend; %one;

knveraraju91 · ‎04-08-2021

Dear, I need suggestion. In my sample data below, i have variable a with different lengths ad variable b with same length value. I need to concatenate both variables with space between them and have final values of same length for all rows. I need to insert blank spaces based length of variable a. Ex: For the first row i need to insert more blank spaces than last record. Please suggest. Thank you output needed aa bbbbbb aaa bbbbbb aaaa bbbbbb aaaaa bbbbbb data hav; input a $ b $; datalines; aa bbbbbb aaa bbbbbb aaaa bbbbbb aaaaa bbbbbb ; data hav1; set hav; c=catx('',a,b); run;

knveraraju91 · ‎03-04-2021

Thank you all for helping. My question was I have a variable 'value' in my data with as below. I need to split the value in to variables 'a and b' as shown in output needed. For 'a' variable I am getting output I need. For 'b' i getting 0.32, 1.30) and 00.32, 10.30). value 5.00 (0.32, 1.30) 10.00 (00.32, 10.30) output needed a b 5.00 (0.32, 1.30) 10.00 (00.32, 10.30) code a = strip(scan(value,1,'(' )); b = strip(scan(value,2,'(' ));

knveraraju91 · ‎03-04-2021

data aa; input value $20.; datalines; 5.00 (0.32, 1.30) 10.00 (00.32, 10.30) ; Dear, I need to split the value variable in to two variables (a and b ). I am able to extract first one using scan function. Please suggest which modifier i need to use in my code. Thank you output need a b 5.00 (0.32, 1.30) 10.00 (00.32, 10.30) my code; a=strip(scan(value,1,'(')); b=

knveraraju91 · ‎01-19-2021

Hi Thank you for your time. In my previous post i posted what is in my similar actual data. I am again posting the data with numeric date values. Please suggest. Thank you data aa; input id val dtc ; informat dtc yymmdd10.; format dtc yymmdd10.; datalines; 1 49 2018-10-16T00:00:00 1 48 2018-10-17T00:00:00 1 44 2020-01-06T00:00:00 1 56 2020-03-16T00:00:00 1 43 2020-03-25T00:00:00 2 46 2020-02-06T00:00:00 2 58 2020-05-16T00:00:00 2 48 2020-07-25T00:00:00 ; data bb; input id weight wdtc; informat wdtc yymmdd10.; format wdtc yymmdd10.; datalines; 1 52.1 2018-10-15 1 55.1 2018-10-16 1 51.1 2018-10-17 1 50.1 2020-01-06 1 52 2020-02-10 1 55 2020-03-25 2 58 2020-02-05 2 60 2020-02-07 2 59.2 2020-05-16 2 59 2020-07-23 2 63 2020-07-24 ;

knveraraju91 · ‎01-19-2021

Dear, I need to add data set aa (variable=val) values with dataset bb(variable=weight) values by comparing dates. In my data, subject id=1 has multiple records in dataset aa and bb. I need to derive a variable sum for all aa records by adding val from aa with weight from bb. But i need to take only bb weight value for each aa record only if wdtc from bb dataset is on or before dtc from aa dataset . Thank you Output id val dtc weight sum 1 49 2018-10-16T00:00:00 55.1 104.1 data aa; input id val dtc $19.; datalines; 1 49 2018-10-16T00:00:00 1 48 2018-10-17T00:00:00 1 44 2020-01-06T00:00:00 1 56 2020-03-16T00:00:00 1 43 2020-03-25T00:00:00 2 46 2020-02-06T00:00:00 2 58 2020-05-16T00:00:00 2 48 2020-07-25T00:00:00 ; data bb; input id weight wdtc $10.; datalines; 1 52.1 2018-10-15 1 55.1 2018-10-16 1 51.1 2018-10-17 1 50.1 2020-01-06 1 52 2020-02-10 1 55 2020-03-25 2 58 2020-02-05 2 60 2020-02-07 2 59.2 2020-05-16 2 59 2020-07-23 2 63 2020-07-24 ;

knveraraju91 · ‎11-15-2020

Dear, I need to prepare a code for the below situation. There is a character variable with yymmdd10. format. For some OBS, either year or month or date or all are missing. I need to create a variable for what part is missing. Please suggest in data step two below code. Thank you if date is complete or missing dtf should be blank (for id= a and f) if day is missing then dtf=d (id= b) if day and month is missing then dtf=m (id= c) if year is missing then dtf=y (id= d) if month is missing and day is present then dtf=m (id= e) data one; input id$ date $10.; datalines; a 2017-07-25 b 2017-07 c 2017 d -07-25 e 2017--25 f ; data two; set one; want=choosec(countw(date, "-"),"M", "D", " "); run; output needed id date dtf a 2017-07-25 b 2017-07 D c 2017 M d -07-25 Y e 2017--25 M f ;

knveraraju91 · ‎10-22-2020

Dear, In my pgm, when i created variables d,e f, in data step two, I am seeing the variable labels for these variables. i need to carry labels of source variables. Please suggest data one; input a $ b $ c; label a ='some' b='somm' c='somn'; datalines; nn ss 1 dk mm 2 ; data two; set one; d=a; e=b; f=c; run;

knveraraju91 · ‎10-19-2020

Dear, I have some non cdisc data sets with several variables. I am trying to convert it to cdisc sdtm datasets. First step i am trying to rename all variables. I am coping a sample data with the code i am trying. Please suggest in my pgm where i am using arrays in data bbb. I need help in the below data step bbb where i am trying to rename variables with arrays eg: id to id_, and then create id with cdisc compliance information such legnth and label etc . Thank you data aaa; input id ab $200. ac $200.; datalines; 1 aaa bbb 2 abc bcd 3 bdb nan ; proc contents data=aaa out=con; run; proc sql; select count(distinct name) into:cntt trimmed from con; select distinct name into :var1 -:var&cntt. from con; quit; %put &cntt. &var1.; data bbb; set aaa; array aa(&cntt.) &var1. - &&var&cntt..; array aa_(&cntt.) &var1._ - &&var&cntt.._;; do i=1 to &cntt.; aa_(i)=aa(i); end; run; output

knveraraju91 · ‎10-10-2020

Dear, I am using the below pgm to convert xpt files in a folder to sas datasets. The pgm is working fine. But i can only do one data set at a time. Please suggest me how to modify my pgm to convert all datasets. In the below pgm i am converting ae xpt file. What information i need to add in place of ae to work on all data sets. libname tmp pipe "dir /b ""abc/ddd/%str(*).xpt"""; libname ms "abc/ddd"; data _null_; infile tmp; input; call execute(cats('libname xptfile xport "abc/ddd/','ae','.xpt";')); call execute('proc copy inlib=xptfile outlib=ms; run;'); call execute('filename xptfile clear;'); run;

knveraraju91 · ‎10-09-2020

Thank you for your time. I could not resolve it. Please suggest Here is log NOTE: CALL EXECUTE generated line. 1 + filename xptfile "abc/programs/qc/archive/rt1/, _input_" NOTE: Line generated by the CALL EXECUTE routine. 2 + proc copy inlib=xptfile outlib=ms; ____ 23 ERROR 23-2: Invalid option name proc. 2 !+ proc copy inlib=xptfile outlib=ms; ____ 23 ERROR 23-2: Invalid option name copy. 2 !+ proc copy inlib=xptfile outlib=ms; _____ 23 ERROR 23-2: Invalid option name inlib. 2 !+ proc copy inlib=xptfile outlib=ms; ______ 23 ERROR: Error in the FILENAME statement. ERROR 23-2: Invalid option name outlib. 3 + filename xptfile clear; 3 The SAS System WARNING: No logical assign for filename XPTFILE. 4 + filename xptfile "abc/programs/qc/archive/rt1/, _input_" NOTE: Line generated by the CALL EXECUTE routine. 5 + proc copy inlib=xptfile outlib=ms; ____ 23 ERROR 23-2: Invalid option name proc. 5 !+ proc copy inlib=xptfile outlib=ms; ____ 23 ERROR 23-2: Invalid option name copy. 5 !+ proc copy inlib=xptfile outlib=ms; _____ 23 ERROR 23-2: Invalid option name inlib. 5 !+ proc copy inlib=xptfile outlib=ms; ______ 23 ERROR: Error in the FILENAME statement. ERROR 23-2: Invalid option name outlib. 6 + filename xptfile clear; WARNING: No logical assign for filename XPTFILE.

Online Status	Offline
Date Last Visited	‎12-11-2023 01:43 PM

How to skip every third number in DO iterative loop

how to get l_bin and U_bin values in ods output dataset in proc freq

How to include subjects when calculating commonrisdiff when subject pr...

Re: How insert text in table using proc report in PDF output

How insert text in table using proc report in PDF output

Need help in calculating stratified p-value in my pgm

Re: How to add stratified variables in proc freq code when finding ris...

How to add stratified variables in proc freq code when finding risk di...

How to output one sided pvalue into a dataset

How to have evenly space x-axis using tickvaluelist in proc template

Re: How to skip every third number in DO iterative loop

Re: How to skip every third number in DO iterative loop

Re: how to get l_bin and U_bin values in ods output dataset in proc fr...

Re: how to get l_bin and U_bin values in ods output dataset in proc fr...

Re: Need help in calculating stratified p-value in my pgm

How to output one sided pvalue into a dataset

how to align values when concatenating variables of different lengthes

Proc transpose help

Help need in using compress function

Help using index function

Help needed in understanding %str function

How to insert blank spaces between two variables having different leng...

Re: Help need in using scan function

Help need in using scan function

Re: How to perform a calculation by comparing dates when multiple rec...

How to perform a calculation by comparing dates when multiple records...

How to populate a variable based on what part of date is missing form ...

How to carry the label of a source variable when creating a new variab...

Help need in pgm

Help need for converting multiple xpt files in folder to sas datasets

Re: Help in my pgm