Hi there,  I want to calculate number of days from the last treatment whenever a patient visits provided patient is not receiving treatment with every visit.  Thank you in advance for your kind reply.  data have; length visit_date treatment_date $8; id=101; visit_date='20220101' ; treatment_date= '20220110';output; id=101; visit_date='20220111' ; treatment_date= ' ';output; id=101; visit_date='20220115' ; treatment_date= '20220120';output; id=101; visit_date='20220121' ; treatment_date= '20220130';output; id=102; visit_date='20220101' ; treatment_date= '20220110';output; id=102; visit_date='20220111' ; treatment_date= ' ';output; id=102; visit_date='20220121' ; treatment_date= ' ';output; id=103; visit_date='20220101' ; treatment_date= ' ';output; id=103; visit_date='20220111' ; treatment_date= '2022020';output; id=103; visit_date='20220121' ; treatment_date= ' ';output; id=103; visit_date='20220122' ; treatment_date= ' ';output; id=103; visit_date='20220123' ; treatment_date= ' ';output; id=103; visit_date='20220124' ; treatment_date= ' ';output; id=103; visit_date='20220125' ; treatment_date= '20220127';output; id=103; visit_date='20220128' ; treatment_date= ' ';output; run; data want; length visit_date treatment_date $8 day_before_last_treatment 3.; id=101; visit_date='20220101' ; treatment_date= '20220110';day_before_last_treatment=.;output; id=101; visit_date='20220111' ; treatment_date= ' ';day_before_last_treatment=1;output; id=101; visit_date='20220115' ; treatment_date= '20220120';day_before_last_treatment=5;output; id=101; visit_date='20220121' ; treatment_date= '20220130';day_before_last_treatment=1;output; id=102; visit_date='20220101' ; treatment_date= '20220110';day_before_last_treatment=.;output; id=102; visit_date='20220111' ; treatment_date= ' ';day_before_last_treatment=1;output; id=102; visit_date='20220121' ; treatment_date= ' ';day_before_last_treatment=10;output; id=103; visit_date='20220101' ; treatment_date= ' ';day_before_last_treatment=.;output; id=103; visit_date='20220111' ; treatment_date= '2022020';day_before_last_treatment=.;output; id=103; visit_date='20220121' ; treatment_date= ' ';day_before_last_treatment=1;output; id=103; visit_date='20220122' ; treatment_date= ' ';day_before_last_treatment=2;output; id=103; visit_date='20220123' ; treatment_date= ' ';day_before_last_treatment=3;output; id=103; visit_date='20220124' ; treatment_date= ' ';day_before_last_treatment=4;output; id=103; visit_date='20220125' ; treatment_date= '20220127';day_before_last_treatment=5;output; id=103; visit_date='20220128' ; treatment_date= ' ';day_before_last_treatment=1;output; run; Thanks,  ... View more

Hi there,  I need your kind help to export a sas data having double quote in s=csv format.    data have; name='john'; age='25'; run; data have2; set have (rename=(name=name1 age=age1)); name=quote(strip(name1)); age=quote(strip(age1)); drop name1 age1; run; proc export data=have2 outfile="M:\test\want.csv" dbms=csv replace; run; I am expecting : NAME,AGE "john","25"   I am getting: NAME,AGE """john""","""25"""   Can you suggest revision in the existing code to get the desired output.  ... View more

Hi there,    I need your kind help to get system date in YYYYMMDDHHMMSS format.    data _null_; export_date=put(datetime(), datetime20.); put export_date; run;   ... View more

Hi there,  I need your kind help to take a subset of my dataset with a desired number of reports having specific categories. My dataset is having 25 records with 5 apple, 4 banana, 6 grape, 6 orange and 4 pears.  I want to take a random subset which will have 2 apple, 2 banana, 3 grape, 3 orange and 3 pears.  data have; input id $ catgeory $; datalines; 101 apple 102 orange 103 grape 104 grape 105 pears 106 apple 106 orange 108 banana 109 grape 110 pears 111 apple 112 orange 113 banana 114 banana 115 pears 116 apple 117 orange 118 grape 119 banana 120 orange 121 pears 122 apple 123 orange 124 grape 125 grape ; run; Thank you in advance for your kind help. ... View more

Hi there,  I need your kind help to transpose my table having  2 groups of data elements related to dates and weight.  data have; id= 101; date_1= '20200101' ; weight_1=51; date_2='20200102'; weight_2=52; date_3='20200103'; weight_3=53; date_4='20200104'; weight_4=54; output; id= 102; date_1= '20200101' ; weight_1=61; date_2='20200102'; weight_2=62; date_3='20200103'; weight_3=63; date_4=' '; weight_4=.; output; id= 103; date_1= '20200101' ; weight_1=71; date_2='20200102'; weight_2=72; date_3=' '; weight_3=. ; date_4='20200104 '; weight_4=74 ; output; run; data want; input id date $ weight ; datalines; 101 20200101 51 101 20200102 52 101 20200103 53 101 20200104 54 102 20200101 61 102 20200102 62 102 20200103 63 103 20200101 71 103 20200102 72 103 20200104 74 ; run; Thank you in advance for your kind reply. ... View more

Hi there,  I want to take a subset from a data using macro variable but getting an error. I am interested to get table "WANT" using macro. Thank you in advance for your kind guidance. data have; length id $3 submission_date $8; input id submission_date ; datalines; 101 20110101 102 20110202 103 20110303 104 20120101 105 20120202 106 20120303 107 20130101 108 20130202 109 20130303 ; run; data have1; set have (rename =submission_date=submission_date1); submission_date=input(put(submission_date1, $8.), yymmdd8.); format submission_date date9.; drop submission_date1; run; data want; set have1; if submission_date ge '01JAN2011'd and submission_date le '31DEC2011'd; run; %macro annual_subset(year); data have2; set have1; if submission_date ge '01JAN&year.'d and submission_date le '31DEC&year.'d; run; %mend; %annual_subset(2011) ... View more