@ChrisNZ : "You can't do it in SAS", I only said SQL can't do it in SAS, not that SAS can't do it. You are (cleverly!) supplementing the limitation of SQL by adding a layer of macro language logic, but the limitation remains. ... View more

There's no such SQL function in SAS sadly. See https://communities.sas.com/t5/SASware-Ballot-Ideas/create-string-summary-functions/idi-p/288035 https://communities.sas.com/t5/SASware-Ballot-Ideas/Add-GROUP-CONCAT-function-to-proc-sql/idi-p/323092   ... View more

Probably too late, but:   1. Help us help you by boiling down your problem. Hundreds of figures and multiple data sets are unneeded to build a cross table and explain what you want to achieve.   2. If you want the percentages not to reach 100%, you need to perform your custom calculations before hand and use proc tabulate to only display the results. ... View more

SAS passes tags as-is when they open and close a string such as a title. How about simply something like title '<h1 style="padding: 3px">This is an H1 header</h1>'; proc odstext will add DIVs. proc template might be able to change that, I don't know.     ... View more

Or this if you want to ensure the display of all digits (see report lines 4 and 14). data VALUES; infile cards truncover; input VAL 32.; cards; -2981248.8 2981248.8 1248.764 248.076403 48.76403 8.76403 0.76403 0.076403 0.0076403 0.00076403 0.000076403 0.000076403871 -0.000076403 -0.000076403 1 ; proc fcmp outlib=WORK.FUNCS.TEST; function sigdig(VAL, SIG, FMT $) $32; %* Input validation to be added; length E F $32; E = putn(VAL, cats('E', SIG+6, '.')); if upcase(FMT)='E' then return(strip(E)); else do; F = cat(input(E, 32.)); L = length(F); if L < SIG then F = cats(F,'.',repeat('0',SIG-L-1)); return(strip(F)); end; endsub; run; options cmplib=WORK.FUNCS; data FCT; set VALUES; NUM1 = sigdig(VAL, 4, 'S'); NUM2 = sigdig(VAL, 4, 'E'); run; Obs. VAL NUM1 NUM2 1 -2981248.8 -2981000 -2.981E+06 2 2981248.8 2981000 2.981E+06 3 1248.764 1249 1.249E+03 4 248.0076403 248.0 2.480E+02 5 48.76403 48.76 4.876E+01 6 8.76403 8.764 8.764E+00 7 0.76403 0.764 7.640E-01 8 0.076403 0.0764 7.640E-02 9 0.0076403 0.00764 7.640E-03 10 0.00076403 0.000764 7.640E-04 11 0.000076403 0.0000764 7.640E-05 12 0.000076403871 0.0000764 7.640E-05 13 -0.000076403 -0.0000764 -7.640E-05 14 1 1.000 1.000E+00       ... View more

Perhaps something like this: proc fcmp outlib=WORK.FUNCS.TEST; function sigdig(VAL, SIG, FMT $) $32; %* Input validation to be added; length E $32; E = putn(VAL, cats('E', SIG+6, '.')); if upcase(FMT)='E' then return(strip(E)); else return(cat(input(E, 32.))); endsub; run; options cmplib=WORK.FUNCS; data FCT; set VALUES; NUM1 = sigdig(VAL, 4, 'S'); NUM2 = sigdig(VAL, 4, 'E'); run; Obs. VAL NUM1 NUM2 1 -2981248.8 -2981000 -2.981E+06 2 2981248.8 2981000 2.981E+06 3 1248.764 1249 1.249E+03 4 248.76403 248.8 2.488E+02 5 48.76403 48.76 4.876E+01 6 8.76403 8.764 8.764E+00 7 0.76403 0.764 7.640E-01 8 0.076403 0.0764 7.640E-02 9 0.0076403 0.00764 7.640E-03 10 0.00076403 0.000764 7.640E-04 11 0.000076403 0.0000764 7.640E-05 12 0.000076403871 0.0000764 7.640E-05 13 -0.000076403 -0.0000764 -7.640E-05   ... View more

Your code seems needlessly complex. You should leverage the existing formats. For example: data VALUES; infile cards truncover; input VAL 32.; cards; -2981248.8 2981248.8 1248.764 248.76403 48.76403 8.76403 0.76403 0.076403 0.0076403 0.00076403 0.000076403 0.000076403871 -0.000076403 ; data TEST; set VALUES; SIG = 3; E = putn(VAL, cats('E', SIG+6, '.')); NUM = input(E, 32.); run; proc print; format _NUMERIC_ best32.; run; Obs. VAL SIG E NUM 1 -2981248.8 3 -2.98E+06 -2980000 2 2981248.8 3 2.98E+06 2980000 3 1248.764 3 1.25E+03 1250 4 248.76403 3 2.49E+02 249 5 48.76403 3 4.88E+01 48.8 6 8.76403 3 8.76E+00 8.76 7 0.76403 3 7.64E-01 0.764 8 0.076403 3 7.64E-02 0.0764 9 0.0076403 3 7.64E-03 0.00764 10 0.00076403 3 7.64E-04 0.000764 11 0.000076403 3 7.64E-05 0.0000764 12 0.000076403871 3 7.64E-05 0.0000764 13 -0.000076403 3 -7.64E-05 -0.0000764   ... View more

You should add a line at the end of your first step to remove these nasty notes: NOTE: Variable KEY is uninitialized. NOTE: Variable ORGNL_SAS_DS_ROW_NBR is uninitialized. NOTE: Variable agreement_nbr is uninitialized. NOTE: Variable cie is uninitialized. NOTE: Variable lob is uninitialized. NOTE: Variable year is uninitialized. NOTE: Variable month is uninitialized. NOTE: Variable libname is uninitialized. NOTE: Variable filename is uninitialized. NOTE: Variable company_cd is uninitialized. NOTE: Variable policy_expiry_date is uninitialized. NOTE: Variable AGREEMENT_NBR_DR is uninitialized. NOTE: Variable LINE_OF_BUSINESS is uninitialized. NOTE: Variable PROVINCE is uninitialized. NOTE: Variable LEGACY_UNDERWRITING_COMPANY is uninitialized. NOTE: Variable UNDERWRITING_COMPANY is uninitialized. NOTE: Variable DISTRIBUTOR_NUMBER is uninitialized. NOTE: Variable DISTRIBUTOR_NUMBER_SRC is uninitialized. NOTE: Variable SOURCE_SYSTEM is uninitialized. NOTE: Variable DATASOURCE_BACKEND_REFERENCE is uninitialized. NOTE: Variable LAST_TERM_EFFECTIVE_DATE is uninitialized. NOTE: Variable LAST_TERM_EXPIRY_DATE is uninitialized. NOTE: Variable CONTRACT_UUID is uninitialized. like this: ... call missing(of _all_); stop; run;       ... View more

This is cool. Thank you! ... View more

You're asking proc tabulate to use variables in the table crossings AND in the BY groups. The variables are used twice in your logic, so they appear twice in the output data set and need different names. ... View more

SAS EG is extremely  sensitive to network disconnections. That's what's happening here. It's a known weakness that's never been addressed. You need a strong network link. If you're using wifi, try using a cable.   SAS Studio is very robust in this respect. EG uses SAS IOM to communicate, and I always assumed that that IOM was fragile. Does anyone know whether SAS Studio uses IOM? ... View more

@Rick_SAS Can you help? ... View more

Here's an example of how you can process the data as you read it. filename CSV "~/aa.txt"; data _null_; file CSV; put '"aa";"bb' '0d0a'x 'bb";"cc"' '0d0a'x '"xx";"yy";"zz"'; put '"11";"22";"33"'; run; data WANT; infile CSV recfm=n eof=EOF;%* Read the file in stream mode; length A B C TMP $8 ; %* Declare variables; retain A B TMP; %* Retain variables input X $1. @@; %* Save one character of data; if X='"' then do; %* Look for quote in data; Q+1; %* Count quotes; if Q=2 then do; %* Second quote: End of string; VARNO+1; %* Count variables ; if VARNO=1 then A=TMP; %* Save value into variable; if VARNO=2 then B=TMP; %* Save value into variable; if VARNO=3 then do; %* Last variable: Save record; C=TMP; %* Save value into variable; output; %* Save record; VARNO=-1; %* Reset variable counter; end; else do; %* Not last variable: skip to next data character; do until (X not in (';','"','0d'x,'0a'x)); input X $1. @@; end; TMP=X; %* Save first character of data; end; Q=1; %* Second quote processed, reset quote counter; end; end; else TMP=catt(TMP,X); %* Character is not a quote: Append it into value; return; %* Go to top to read next character; eof: %* EOF found; stop; %* Stop the data step; keep A B C; run; proc print noobs; run; A B C aa bb bb cc xx yy zz 11 22 33   ... View more

Ah this in on Linux though. I suppose you're on Windows? The EOL character is different. Never mind. You need to read one character at at a time. ... View more