I'm trying to find which records in a small dataset ('COHORT.HICS') are not in the larger one (ABCD.DATA).  Trying use merge via hash rather than sorting and then a data step, but it seems to run out resources.   Any suggestions how to make it work.   2 OPTIONS NOCENTER OBS= MAX ; 3 4 DATA HICDIFF0(KEEP=HIC); 5 IF 0 THEN SET ABCD.DATA; 6 IF _N_ = 1 THEN DO; 7 DECLARE HASH MB(DATASET:'ABCD.DATA'); 8 MB.DEFINEKEY('HIC'); 9 MB.DEFINEDONE(); 10 END; 11 SET COHORT.HICS; 12 IF MB.FIND() NE 0 THEN OUTPUT; 13 RUN; NOTE: THERE WERE 12354503 OBSERVATIONS READ FROM THE DATA SET ABCD.DATA. ERROR: HASH DATA SET LOAD FAILED AT LINE 9 COLUMN 5. ERROR: HASH OBJECT ADDED 12354498 ITEMS WHEN MEMORY FAILURE OCCURRED. FATAL: INSUFFICIENT MEMORY TO EXECUTE DATA STEP PROGRAM. ABORTED DURING THE EXEC ERROR: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF INSUFFICIENT MEMOR WARNING: THE DATA SET WORK.HICDIFF0 MAY BE INCOMPLETE. WHEN THIS STEP WAS STOPP NOTE: THE DATA STATEMENT USED 12.64 CPU SECONDS AND 18741K. NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 920K BELOW THE LINE AND 1555896K A ... View more

Can I format Excel output from an sql procedure?   Something like   Proc sql; select count(x) as count_num style={tagattr='format:#,##0'} from y; quit; ... View more

I'm trying to order the rows by the frequency column "Count" but this code doesn't seem to work.   PROC REPORT DATA=SURG_CD;                                                 COL SURG_DX SURG_DX=DESC N;                                             DEFINE SURG_DX / GROUP 'ICD-10-PCS CODE';                               DEFINE DESC / GROUP 'DESCRIPTION' FORMAT=$ICDDESC.;                     DEFINE N / 'COUNT' STYLE(COLUMN)={TAGATTR='FORMAT:#,##0'} ORDER=FREQ;                          RUN;                                                                    ... View more

  Shouldn't the compress function eliminate the repeating "20"? 27 data check; 28 set in.CK14_data2(firstobs=2 obs=2); 29 put state state hex16.; 30 statex=compress(state,'20'x); 31 put statex statex hex16.; 32 run; DC 4443202020202020 DC 4443202020202020 ... View more

I have two values with same apparent text but different hex values   State=ALABAMA 414C4142414D4109 State=ALABAMA 414C4142414D4120   Is there a way to equalize the hex values so they can be merged? ... View more

I'm using code similar to the following.   However, my output is printing periods in some cells with missing values.   How can I change the format so those cells displays either "0" or are blank?   proc format; picture mypct (round) low-high='009.99%'; run; proc tabulate data=sashelp.class; class age sex; var weight height; table age, sex*(weight height)*(pctsum*f=mypct.); run;   ... View more

  How can I force the word "Total" for the summary line in the code below?   data a; input x 1. y 1.; datalines; 10 21 31 22 ; run; proc format; value grp 1='A' 2='B' 3='A' ; proc report data=a; col x n; define x / group format=grp.; define n / 'count'; compute before; x = 'Total'; /*column or grand total*/ endcomp; rbreak before / summarize; run; ... View more

This is a simplified version of what I'm trying to do.   I use a dash because the actual number of variables quite large and am trying to avoid listing each one of them.   Is there a way to get the macro to call up each variable in the array.   options mprint; data sample; x1=1; x2=3; x3=2; run; %macro test(vars); %let selcnt=%sysfunc(countw(&vars)); %do i=1 %to &selcnt; %let selvar=%scan(&vars,&i); sum(&selvar) as &selvar %if &i lt &selcnt %then %do; , %end; %end; %mend; proc sql; select %test(x1-x3) from sample; quit; ... View more

There there a way for one macro parameter to refer to another?   To use a really simplistic example, what if I had the following?   In the second iteration, the parameters have the same value.    Is there a way for the second parameter to refer to back to the first?   options mprint; %macro vals(a,b); data _null_; x=&a; y=&b; run; %mend; %vals(1,2) %vals(1,1) ... View more

This code lists several variable and intended labels.   However, it won't print all of the fifth value ('Chapter 4'), I assume because of the space.   What is the fix?     27 %let utilvars=Util_Transp_YN Util_Dental_YN Util_Vision_YN Util_Hearing_YN Util_Ch4_YN Util_Other_YN; 28 %let labvals='Transportation' 'Dental' 'Vision' 'Hearing' 'Chapter 4' 'Other'; 29 30 %macro set_labs; 31 %do i=1 %to 5; 32 %put %scan(&utilvars,&i)=%qscan(&labvals,&i); 33 %end; 34 %mend; 35 %set_labs Util_Transp_YN='Transportation' Util_Dental_YN='Dental' Util_Vision_YN='Vision' Util_Hearing_YN='Hearing' Util_Ch4_YN='Chapter ... View more

How can I remove the space before the "n" in the variable y1.   data x; y='Provider Name '; y1=catq('1T',y,'n'); put y= y1=; run; ... View more