Dear SAS communities I have a excel dataset that contains a 50 binary variables (e.g. history of diabetes: 1/0 etc), a variable "center" which contains the name of one of 10 hospitals   I just want to create a summary stats excel table where each of the 50 binary variables is listed as a line like this variable                 N.       Nmiss.            frequent "0"      percentage "0"    frequent "0"      percentage "0"   hx_diabetes.                                               xx.                       xx%.                    yy.                       yy%.       hx_stroke                                                    xx.                       xx%.                    yy.                       yy%.         then sort by "center" to output the same table restricting to each of the "center"   if you have a code that I can borrow, I would be grateful.  Thanks  ... View more

I am not sure where to post this so my apology if this is not the correct forum   our group needs to hire a part time or a full time sas programmer, preferrably located in boston, MA   is there a place to post this?   thanks  ... View more

Dear SAS community I am trying to import using this proc import with a guessingrow=10000;   proc import datafile="\\.psf\home\Dropbox (Partners HealthCare)\IronKey\CMRCOOP_merge\1CMR_COOP\Data_onecsv\1_exported_as_one_file.xlsx"  out=cmrcoop dbms=xlsx replace;  getnames=yes;  guessingrow=1000; run;   but I keep getting this error, 7107  proc import datafile="\\.psf\home\Dropbox (Partners 7107! HealthCare)\IronKey\CMRCOOP_merge\1CMR_COOP\Data_onecsv\1_exported_as_one_file.xlsx" 7108  out=cmrcoop dbms=xlsx replace; NOTE: The previous statement has been deleted. 7109  getnames=yes; 7110  guessingrow=1000;       -----------       180 ERROR 180-322: Statement is not valid or it is used out of proper order.   7111  run;     NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds   any thoughts?   Much appreciated Raymond ... View more

Dear SAS programming community:   I need to search the contents of a variable "outcome_entries" (please see the attached screenshot of a subject). The actual dataset contains several thousand subjects. I need to collect the values in red color. Note that these values are arranged by outcome_name, followed by the outcome values (where 1 means present of that outcome_name and 0 means absent), followed by the year of that event (which can be missing as in the cva), followed by a number of days value. there is set list of these events (un_ang, ami, cva....) that I know the names. I need: 1) each of these events with its corresponding presence or absence (1/0), date, year, and day since values 2) count how many time a specific event happens (e.g. 2 for "heart" and 2 for "ami", but 1 for "pci"   any help is much appreciated, thanks  Raymond ... View more

Dear SAS community I was given this macro which is useful to use but it only runs it for var1.  I need to repeat this for all 600 variables (var1, var2, var3... ...var600) in a dataset.   Each of var1, var2....var600 is a column of data in the dataset.   My purpose of running this macro is to extract the name of the dependent variables, name of the variable (i.e. var1), and the P-value of the interaction term (drug*var1).  Is there a way to automate this?  Many thanks    ods graphics / reset=all; %macro loop; data pv2_var1; format y $20.; run; %let endpoint=d_lvef ln_lvesvi d_globalecvrem ln_ecv_rem d_total_lge_fw ln_total_lge_fw; %do i=1 %to 6; %let y=%scan(&endpoint,&i,' '); title "Endpoint = &y"; ODS OUTPUT SOLUTIONF=RESULTS; proc mixed data=testset covtest noclprint plots=studentpanel method=reml; class patient_id site_id; model0: model &y = drug var1 drug*var1/ s cl ddfm=kenwardroger; run; DATA pv2_var1; SET pv2_var1 RESULTS(IN=A); if missing(effect) then delete; IF A THEN Y="&y"; RUN;   %end; title " "; %mend; %loop ... View more