Something like this? Also one of the variables is defined as a character variable, howcome?   data WANT; set HAVE; call missing (TOTAL); TOTAL = sum(DICE1, DICE2); run; proc sgplot data=WANT; vbar TOTAL ; run;       ... View more

Or depending on what OP wants:   data _null_; set sashelp.class; call execute(catt('data ds',_N_,'; set sashelp.class(firstobs=',_N_,' obs= ',_N_,'); run;')); run;   ... View more

Here is how I did it. data CHOLESTEROL; * infile 'path/file_1' delimiter='09'x TRUNCOVER DSD firstobs=2 ; %* set length and informat and output order; informat CHR BP 8. MUTANT ORIG $20. MINOR_ALLELE $2. MINOR_AF EXPECTED_CASE_MINOR_AC 8. LOW_CONFIDENCE_VARIANT $5. N_COMPLETE_SAMPLES AC YTX BETA SE TSTAT PVAL 8. VARIANT $70. ; %* read data in input order; input VARIANT MINOR_ALLELE MINOR_AF EXPECTED_CASE_MINOR_AC LOW_CONFIDENCE_VARIANT N_COMPLETE_SAMPLES AC YTX ( BETA SE TSTAT PVAL ) (:?? 32.) ; drop VARIANT ; CHR = input(scan(VARIANT, 1,':'),?? 1.); BP = input(scan(VARIANT, 2,':'),?? 8.); MUTANT = scan(VARIANT, 3,':') ; ORIG = scan(VARIANT, 4,':') ; run; ... View more

If you want to sum the locations even when they are apart, this would work.     data have; input MOBILE TIME :DATETIME21. SCENARIO LOCATION $4.; datalines; 600000001 13FEB2019:00:01:00 0 home 600000001 13FEB2019:00:03:00 0 home 600000001 13FEB2019:00:04:00 0 home 600000001 13FEB2019:00:05:00 1 work 600000001 13FEB2019:00:11:00 1 work 600000001 13FEB2019:00:13:00 0 home 600000001 13FEB2019:00:15:00 0 home 600000001 13FEB2019:00:16:00 1 work ; run; data WANT; set HAVE (keep= TIME LOCATION); REALTIME = dif(TIME); if LOCATION = lag(LOCATION) then do; HOMETIME+REALTIME*(LOCATION = 'home') ; WORKTIME+REALTIME*(LOCATION = 'work') ; end; else REALTIME = .; HOURS = REALTIME/60; run; proc print data=want(Keep= HOURS LOCATION REALTIME HOMETIME WORKTIME); run;           ... View more

There are no 10k.FILEDATE that match SRC.FILEDATE. What would you do with the 10Q? etc?   ... View more