Hi All,   I have an excel to import in to SAS 9.4, where a few rows have been strike through. While importing I'm getting to see those rows as it is. would like to hear from experts to check if there is an option/method exist to identify those rows at the proc import level with out manually deleting them.    Your help will be highly appreciated.   Thanks   ... View more

I have a list of datasets(in dsets_2 macro list) where I've to perform 1 operation(merge date+time variable) as below. #rawdata. is the library name %let dsets_2 = %str(rawdata.SERUM_BIO rawdata.CL_HEMA rawdata.CL_PG rawdata.SKIN_BIO rawdata.CL_CHEM rawdata.PHOTO);   I've to use this datasets such as SERUM_BIO,CL_HEMA,CL_PG, SKIN_BIO,CL_CHEM,PHOTO through a do loop to form 1 SINGLE DATASET.  Eg: dsets_2 macro has 6 datasets name, those has to be placed one upon other by SET statement, below code is used to achieve this, but not succeeded, need help to achieve. Kindly guide.     %macro sort(var1=,var2=); %local ii next_value; %let ii=1;%let iii=2; %do %while (%scan(%scan(&dsets_2,&ii, %str( )),2,".)") ~= %str()); %let next_value = %scan(&dsets_2, &ii); %if &var1 ~=. and &var2 >. %then %do ; data dset_&next_value.; set %scan(&dsets_2,&ii, %str( )); TDATETIME= dhms(LBDAT, 0, 0, LBTIM);format TDATETIME datetime20.; keep USUBJID &var1. &var2. TDATETIME; run; %let ii = %eval(&ii + 1); %end; %end; %mend sort; %sort(var1=LBDAT ,var2=LBTIM); ... View more

Hi experts,   I have a list of variables where clinical responses have been captured for every clinical events happened to multiple patient came for diagnosis. there are about 35 variables named differently. subjid  klebsiella pneumonia acetobacter choristidium_diff ......etc (22 variables) 0021    X             X                                     X 0022    X             X                    X               X 0024                   X                    X               X 0025    X             X                    X               X 0028    X             X                    X               X ......... continued till 10,000 paticipants   I would like to make a new column which will be 1 if all the 22 columns have X. if there is blank in any of the 22 columns then it has be 0.   I thought of using arrays to solve this and written a below code, but doesn't seems to execute with the aim. IF anyone can help with modifying the code, that would be helpful.   array infection{*}  klebsiella pneumonia acetobacter choristidium_diff acetobactor; do i=1 to dim(infection); if infection{i} ="X" then inf=1;else inf=0; end;    ... View more

Hi experts, I've YAS0 YES0 YCS0 YAS1 YES1 YCS1 YAS3 YES3 YCS3 columns where I have values such as "Atrisk" in all YAS columns, similarly "Events" for YES columns and "Censor" for all YCS columns and total I've about 9547 rows and only 1st rows of each column has the values. I would like to caryy forword the values to all 9657 rows. Could anyone guide me though how to modify the below written code to achieve the results. data plot_data_fin; merge plot_datafin transposed_gen_mod; by row;hw_lcl_lag=lag(hw_lcl); ARRAY cols {*} YAS: YES: YCS: ; Do i=1 to dim(cols); if COLS[i]=" " then COLS[i]=lag(COLS[i]); end; run; I have tried to do it through do over loop but couldn't finish it till end.Let me know if i'm on track and help with a solution to modify the code to achieve the results. ... View more