Hi All,   I came across a new option in SAS input statement like   It's a part of code:   Input MONTH_ID         : ?? BEST6. SVC_DT           : ?? YYMMDD8. PATIENT_ID       : ?? BEST11.;   The one on the left side is variable. What is the use of ":" and "??" in input statement? Can anyone explain in brief?   Thanks In Advance ... View more

I have 20 csv files, need to import and append the 20 CSV files in SAS using DO loop. The file name as follow: Part-00000-sample file- set 12589 Part-00001-sample file- set 12590 Part-00002-sample file- set 12591 Part-00003-sample file- set 12592 etc....   i need to import the 20csv files using do loop. As for importing need a double loop, need a help for this?   TIA ... View more

While running the code, What will be the buffer size, if my SAS data file size is 10GB?   ... View more

I'm from India, where can I learn the clinical SAS fully. Please help me, it will be very useful for me. ... View more

data friday; target=today(); do n=1 to 5 while(date < NWKDOM(5, 6, month(target),year(target))); date=NWKDOM(n, 6, month(target),year(target)); output; end; format target date date9.; run;   When I run the above code, i got the output as: 07Jan2022 14Jan2022 21Jan2022 28Jan2022   BUT,   %macro test; %let target=today(); %do n=1 %to 5 while(date <NWKDOM(5, 6, month(target),year(target))); %let date= NWKDOM(n,6, month(target),year(target)); output; %end; %mend test;   When i run the above code with same condition, I got the output as: 07Jan2022   The output I want is: 07Jan2022 14Jan2022 21Jan2022 28Jan2022   Can someone help me to overcome this situation!!   I want 4 macro values in a single macro variable.   TIA, Joe ... View more

Hi, I have data like this Date 01oct2021 10oct2021 05oct2021 11oct2021 01oct2021 05oct2021 10oct2021 It contain duplicate values. I need to transpose in row manner. For example, I want Date 01oct2021 05oct2021 10oct2021 Thanks ... View more

Hi,   i have the column name as week1 week2, week3 and so on upto week100. i need week1 as 29-Oct and week2 as 22-Oct and week3 as 15-Oct and so on. Like, week 1 is current week, week2 is -7 of current week.   For example, week1     week2      week3  29-Oct      22-Oct      15-Oct   thanks ... View more

Hi all,   i got some data on daily basis, but i want to convert it into weekly basis i need it like on Saturday -Friday basis For example,   1. 09-06-21 2. 14-06-21 3. 05-06-21 4. 11-06-21 5. 28-06-21 6. 25-06-21 7. 04-06-21   where No.7 lies in one week, whereas No.1,3,4 lies in another week. my data contains record from 2019, but i need it on weekly basis. It will be helpful if its available in both SAS and excel solution.   Thanks In Advance ... View more

Hi Experts,   i came across the situation, where I'm not able to solve this?   For example,   date           test        result          count of patient 04-11-20   Blood     Positive        20 05-11-20   Urine     Positive        56 04-11-20   Urine     Negative       2 06-11-20   Urine     Positive         7 05-11-20   Blood     Negative      5 06-09-20   Blood    Negative       52   My criteria is i need urine test only, to get the count of patient (both positive & negative) like for urine test, total 65   please help me to resolve this situation. i have the data set of 20000 obs.   thanks in advance ... View more