Compare the sql output report  to  proc means data= _app_port_ mean; class snapshot_date; /* <== line added */ var flag_; weight ead; ods output summary=exposure_wise_override_rate; run;   ... View more

Can you post what sas format has Invoice variable? Within SAS, assuming the format is comma12.2, when Invoice is displayed is it like 3.571.144,00 (european option) ? It seems as if commas are diaplayed as blank space ?! ... View more

I think that Jane and Lee should have the same assigns: "NO" "YES", Check next code: Data temp; input cust_name $ sales_id $ sales_date date9. sales_amount type $; format sales_date date9.; cards; tom abc 07mar2019 120 Credit tom def 25nov2019 155 Cash tom ghi 02feb2020 110 Paypal tom jkl 07mar2020 165 Cash tom mno 16apr2020 185 Cash john sdf 25jun2019 255 Credit john vgh 05feb2020 122 Amazon john hui 15jul2020 333 Credit john bhj 08sep2020 256 Paypal john njd 28jun2021 128 Cash lee bhg 18oct2020 556 Paypal lee ggr 06Nov2020 546 Amazon lee njj 17oct2021 126 Credit lee juy 20oct2021 512 Credit lee aer 25oct2021 255 Amazon lee njk 18oct2022 596 Paypal jane asj 15dec2020 154 Amazon jane vhf 18may2021 456 Paypal jane kuh 16jul2022 488 Paypal ; run; data temp1(drop=cust_prev); /* adding cust_order to keep customers in original order */ set temp; retain cust_order cust_prev; if _N_=1 then do; cust_order=1; cust_prev = cust_name; end; else if cust_name ne cust_prev then do; cust_order+1; cust_prev = cust_name; end; run; proc sort data=temp1; by cust_order sales_date; run; data want; merge temp1 (in=in1) temp1(in=in2 firstobs=2 keep=cust_order type rename=(type=type2)); by cust_order; retain first_pur following_pur; if first.cust_order then do; if type='Credit' then first_pur='YES'; else first_pur='NO'; if first_pur='YES' then do; if type2='Credit' then following_pur='YES'; else following_pur='NO'; end; else do; if type2 ^= 'Credit' then following_pur='YES'; else following_pur='NO'; end; end; drop type2; /* you may drop cust_order if not needed */ run; ... View more

In order to use dynamic format, given at run time, use PUTN for numeric or PUTC for character instead of PUT function. for example: data test; x=2.5; run; data _null_; set test; myfmt = 'z4.3'; show = putn(x,myfmt); /* using variable name not a format name */ put show=; run; you can create your own format in a variable by using concatenation and any expression you need. ... View more

Use next tested code: data Database1; input id $ date :ddmmyy10. ; cards; 111 01/01/2015 111 20/03/2015 111 15/06/2016 111 12/03/2017 111 30/06/2020 222 18/03/2020 222 25/04/2020 ; run; data Database2; input id $ date2 :ddmmyy10. ; cards; 111 18/06/2016 111 15/08/2016 111 17/03/2017 111 20/01/2018 111 04/04/2018 111 20/04/2020 222 26/05/2020 ; run; data temp / view=temp ; set Database1 Database2; sortdt = coalesce(date, date2); format date date2 sortdt ddmmyy10.; run; proc sort data=temp out=temp1; by id sortdt ; run; data want; set temp1; by id sortdt ; retain dt1; if first.id then dt1=date; if date then do; dt1=date; end; else date=dt1; drop sortdt dt1; run; data want; set want; by id date; if not (first.date and last.date) and date2=. then delete; run; ... View more

As much as I understand the hierarchy of options in SAS, it is in that order: 1. Options assigned at SAS installation(configuration file) 2. Options assigned at SAS initiation (autoexec file) 3. Options changed by submitted code.   I believe that SAS administrator of SAS studio of the site, may change those options. My experience is with he Students vaersion (not used any more) which is a variance of SAS studio.   I retired 6 years ago and may be i'm not familiar enough with the todays platforms. ... View more

The article you sent deals with options statement submitted by you, that is when you are alraedy in sas studio, If you want that some options will be automaticaly set for all sessions  in future, you can add the options statement in the autoexec.sas program.  If it is a private installation you can do it yourself, otherwise you can ask the sas administartor to it for you.  ... View more

1. running "options .." doen't need to run "proc options" in order to activate it. 2. you can assign more then one option in "options" statement, as in  options nodate validvarname=upcase ; 3. You can add above line into the autoexec.sas  program, which is executed within entering sas studio.           ... View more

What do you want to do with the character variables? you can't sum them. You need to decide what to do in order to get help how to do it. ... View more

I have done something similar very long time ago. The main logic is to write all output to a text file and then ommit the "new page" control lines. Check the output file, first 2-3 pages of next code and locate the "new page" control lines: filename myprint '<folder and file name>.txt; proc printto file=myprint; run; ... enter yor code ... proc printto; run; then do: ods pdf file= <ods file folder and name>.pdf; data _null_; infile myprint truncover; input a_line $; if a_line = "1 " then delete; /* target - ommit new page control line; May need correction */ run; ods pdf close; I'm not sure proc printto is available on all sas platforms. Above code is not tested. I hope it should give you the hint how to solve the problem.   I'm adding here my test done owith SAS On Demand for Academics: /* target: ommit break page lines */ filename myprint '~/reports/myprint.txt'; proc printto print=myprint; run; proc print data=sashelp.class; run; proc print data=sashelp.cars; run; proc printto; run; data _null_; length a_line $132; infile myprint truncover; input a_line $132.; if substr(a_line,1,1) = 'FF'x then delete; file print; put a_line; run; You still may want to remove some titles or headings. ... View more

Have checked the PROC COMPARE to achieve the differences, though it is not reported in the required format. ... View more