Hello,  Could someone explain the table statement below? Thanks. class scrdate_n studysite; var chart_n enrolled_n; table chart_n*studysite=' '*(sum*f=8. pctsum<enrolled_n>*f=8.) enrolled_n*studysite*sum, scrdate_n /misstext='0'; ... View more

Hello, I would like to get the month of "AUG2022" in the variable "scrdate_n."  The variable format is MONYY7.   Please guild me how; thanks. ... View more

Hello, I would like to create a monthly report based on the date from Jan to Apr 2023.  Please help.  In addition, there are errors in creating the dataset.  Please correct them; thanks.   data test; input cust_id date :ddmmyy10. site; format date ddmmyy10.; infile datalines delimiter=','; datalines; 2,01/04/2023,1, 6,01/24/2023,1, 3,03/04/2023,2, 8,03/18/2023,1, 4,02/05/2023,1, 7,04/05/2023,1 ; run; data Monthly_Table; input Site Jan2023 Feb2023 Mar2023 Apr2023; infile datalines delimiter=','; datalines; 1,2,1,0,1, 2,0,0,1,0, ;     ... View more

Hello, I have two data sets; set A is a large one with over 1000 columns, and set B is a small one with only 10 obs and 5 columns.  A and B have the same ID columns; in addition, all the five variables in Set B are from set A with updated values (numeric).  I would like to update set A with set B value with the same IDs.  That's why I think about merging two datasets.  Please let me know how to approach it, thanks. ... View more

Hello, I would like to use the Missing option in the different classes below.   I want Age/Sex/Race/Insurance/Underly (Missing value inclusion)  and Oxy/ICU/Incub/Ecmo/Died(Missing value exclusion). In addition, is there a way to get the SUM of each class in the Tabulate statement too?  Please guild me a way to do it.  Thanks.   proc tabulate data=ARI_UC_Elg_IDs; class Age Sex race Insurance oxy ICU Intub Ecmo Died Underly; tables (Age Sex race Insurance oxy ICU Intub Ecmo Died)*(n colpctn*f=4.2), Underly; where Age_group in (1,2,3); run; ... View more

Hello, I would like to get the counts for any variables equal to 1; I use Proc Freq table below.  Why SAS showed an error message?  Thank you. proc freq data=H4_SEC_UC; table sec_noumedcond sec_uasthma; where (sec_noumedcond=1 or sec_uasthma=1); run; 211 proc freq data=H4_SEC_UC; 212 table sec_noumedcond sec_uasthma ; 219 where (sec_noumedcond=1 or sec_uasthma=1); ERROR: WHERE clause operator requires compatible variables. 226 run; NOTE: The SAS System stopped processing this step because of errors. ... View more

Hi,  I have the following macro code below.  An error message was shown in the log window when it ran.  Could a data line step be run in Macro Macro steps? Please help. %macro AriINPChart; proc sort data=icd_10_cm_b; by icd_10_cm; run; data icd_10_cm; set icd_10_cm_a icd_10_cm_b; run; proc sort data=icd_10_cm nodupkey; by icd_10_cm; run; data Valid_ICD; LENGTH icd_10_cm $ 10; input icd_10_cm $; infile datalines delimiter="/"; datalines; H669/ 0219/ D59219/ Z283/ M545/ R05/ J899/ Y938/ Z20882/ ; run; proc sort data=Valid_ICD; by icd_10_cm; run; %macro vvv(ooo); %do ooo=1 %to 10; %let i=(&rr + 1); %let rr=%eval(&i); data inptadmitdx&ooo; set ds2inp (keep=studysite scrdate caseid inptadmitdt inptdischargedt inptadmitdx&ooo); if inptadmitdx&ooo ne ' '; if inptadmitdx&ooo in('999.9999','999..999','999.999','U07.1','U07.0','R51','M35.8') then delete; icd_10_cm=upcase(compress(inptadmitdx&ooo,',.[]-/')); run; proc sort data=inptadmitdx&ooo; by icd_10_cm; run; data inpcr&rr (keep=studysite scrdate caseid inptadmitdt inptdischargedt inptadmitdx&ooo icd_10_cm); merge inptadmitdx&ooo (in=a) icd_10_cm (in=b) Valid_ICD (in=c); by icd_10_cm; if a=1 and b ne 1 and c ne 1; run; proc sort data=inpcr&rr; by studysite caseid; run; %let inp_&rr.a=%str(Admission diagnosis [inptadmitdx&ooo.] does not match ICD-10-CM code list); ods proclabel "Check &rr:&&inp_&rr.a"; data inpcr&rr; set inpcr&rr; if caseid in ('EH1R09895') then delete; var1='scrdate='||trim(left(put(scrdate,mmddyy10.))) ||', '||"inptadmitdt="||trim(left(put(inptadmitdt,mmddyy10.))) ||', '||"inptdischargedt="||trim(left(put(inptdischargedt,mmddyy10.))) ||', '||"inptadmitdx&ooo.="||trim(left(put(inptadmitdx&ooo,$20.))); ||', '||"inptadmitdx&ooo. without special symbol="||trim(left(put(icd_10_cm,$20.))); format studysite studysite.; run; %createinp; %end; %mend vvv; %vvv; %mend AriINPChart; %AriINPChart; MPRINT(ARIINPCHART): data Valid_ICD; MPRINT(ARIINPCHART): LENGTH icd_10_cm $ 10; MPRINT(ARIINPCHART): input icd_10_cm $; MPRINT(ARIINPCHART): infile datalines delimiter="/"; MPRINT(ARIINPCHART): datalines; ERROR: The macro ARIINPCHART generated CARDS (data lines) for the DATA step, which could cause incorrect results. The DATA step and the macro will stop executing. NOTE: The data set WORK.VALID_ICD has 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(ARIINPCHART): ; MPRINT(ARIINPCHART): ; MPRINT(ARIINPCHART): ; MPRINT(ARIINPCHART): ; ERROR: The macro ARIINPCHART will stop executing. 2165 ... View more

Hello, I have a sample dataset below.  Two questions; first, the ")" are missing in all the data lines, not sure how to fix it;  second, my Proc transpose codes are not working. Please help; thanks. data Mean_Median_Output; input House 1.0 LOS_Mean_Q1Q3 $ LOS_Median_range $ Age_Mean_Q1Q3 $ Age_Median_range $; infile datalines delimiter='/'; datalines; 0/2.2 (1-2)/1.0 (0-92)/3.7 (2-4)/2.0 (2-17)/ 1/2.9 (1-3)/2.0 (0-117)/6.6 (3-9)/5.0 (2-17)/ ; run; Proc transpose data=Mean_Median_Output out=Mean_Median_transpose prefix=House_; run; ... View more