No. First of all , sas would load all the data into memory and then execute the operation  by Hash , all of these are in memory. Therefore, you have to change system option MEMSIZE= to make sas have more resource to run your hash code. ... View more

Could you post some data and desired output to explain your question ?   Or Do you want change this ? ------->   Or this ? https://communities.sas.com/t5/SAS-Programming/Input-a-CSV-file-with-text-fields-that-contain-line-breaks/m-p/821603   https://communities.sas.com/t5/SAS-Programming/import-csv-file-with-CRLF-in-text-field/m-p/951124   https://communities.sas.com/t5/SAS-Programming/import-a-crazy-csv-file/m-p/946213#M370582   ... View more

That would be very helpful if you could post some real or dummy data and the desired output. This issue I think is vey easy to address by SAS. Here is an example:   data _null_; infile cards truncover ; input; if mod(countc(_infile_,'"'),2)=1 then put "Found unbanlanced double quote:" _infile_; cards; 1,"sdee,ere","sdfpereu" 2,"sdfsds","sdsds"sdfsf" 3,sdfsd"sdsds,"sdfsds" 4,sdsdfs,"dssds," ; 1 data _null_; 2 infile cards truncover ; 3 input; 4 if mod(countc(_infile_,'"'),2)=1 then put "Found unbanlanced double quote:" _infile_; 5 cards; Found unbanlanced double quote:2,"sdfsds","sdsds"sdfsf" Found unbanlanced double quote:3,sdfsd"sdsds,"sdfsds" ... View more

In Excel file, the URL only can apply to a whole cell, not just a part of line . Interesting thing is the URL seems to be unable to apply to LINE statement, I don't know why . But FOOTNOTE could make a workaround way.   %let CT_link = https://controller.vcu.edu/grants/; ods escapechar='^'; ods excel file='c:\temp\temp.xlsx' options(Sheet_Name='xx' Embedded_footnotes='yes'); footnote j=l link="&ct_link" 'deadline ^{style [textdecoration=underline color=blue]cost transfer form} available on the G&C webpage.' ; proc report data=sashelp.class nowd; run; ods excel close;     ... View more

Quentin, Same with me . I learned something new and forgot it and remember it again . ... View more

You need to customize a template for this purpose.  Here take sashelp.heart as an example:   ods noproctitle; ods path (prepend) work.templat(update); proc template; edit Base.Freq.CrossTabFreqs; edit Frequency; format=COMMA12.; end; edit Percent; format=8.0; end; edit RowPercent; format=8.0; end; edit ColPercent; format=8.0; end; end; run; /**/ /*ods html file="userfmt.html" style=daisy;*/ /*title "Applying Custom Formats to Cellvalues";*/ /*proc freq;*/ /*tables citygovt*robgrp / missprint;*/ /*run;*/ /*ods html close;*/ proc freq data=sashelp.heart; tables bp_status * sex /nocum nopercent norow NOFREQ ; run;   ... View more

There is a more simple way to transform all the character in a table into UPPER CASE. Take table sashelp.heart as an example: filename x "%sysfunc(pathname(work))\temp.xpt"; proc cport library=sashelp file=x outtype=upcase; select heart; run; proc cimport infile=x library=work; run;   ... View more

Opps. You misunderstood what I said. When I said Note: This two variables must have the same length. That means the STORED length is the same ,not the ACTUAL length.   In your case, it is OK since you specify LENGTH statement, make them both have length 9 . If they are both numeric variables, that means they both have length 8. data mydata; length person_id $ 9 family_id $ 9; input person_id $ family_id $; ... View more

Did you try my code ? https://communities.sas.com/t5/SAS-Communities-Library/How-to-find-all-connected-components-in-a-graph/ta-p/231539   Note: This two variables must have the same length.       data mydata; length person_id $ 9 family_id $ 9; input person_id $ family_id $; datalines; person001 family001 person002 family001 person003 family001 person004 family001 person005 family001 person006 family001 person007 family001 person001 family002 person008 family002 person009 family002 person010 family002 person011 family002 person012 family002 person013 family002 person014 family002 person014 family003 person015 family003 person016 family003 person016 family004 person017 family004 person018 family004 person019 family004 person020 family004 person021 family005 person022 family005 person023 family005 person024 family006 ; run; *Note:FROM and TO variable must have the same length ; data have; set mydata(rename=(family_id=from person_id=to)); run; data full; set have end=last; if _n_ eq 1 then do; declare hash h(); h.definekey('node'); h.definedata('node'); h.definedone(); end; output; node=from; h.replace(); from=to; to=node; output; node=from; h.replace(); if last then h.output(dataset:'node'); drop node; run; data want(keep=node household); declare hash ha(ordered:'a'); declare hiter hi('ha'); ha.definekey('count'); ha.definedata('last'); ha.definedone(); declare hash _ha(hashexp: 20); _ha.definekey('key'); _ha.definedone(); if 0 then set full; declare hash from_to(dataset:'full(where=(from is not missing and to is not missing))',hashexp:20,multidata:'y'); from_to.definekey('from'); from_to.definedata('to'); from_to.definedone(); if 0 then set node; declare hash no(dataset:'node'); declare hiter hi_no('no'); no.definekey('node'); no.definedata('node'); no.definedone(); do while(hi_no.next()=0); household+1; output; count=1; key=node;_ha.add(); last=node;ha.add(); rc=hi.first(); do while(rc=0); from=last;rx=from_to.find(); do while(rx=0); key=to;ry=_ha.check(); if ry ne 0 then do; node=to;output;rr=no.remove(key:node); key=to;_ha.add(); count+1; last=to;ha.add(); end; rx=from_to.find_next(); end; rc=hi.next(); end; ha.clear();_ha.clear(); end; stop; run; node household family001 1 person001 1 person002 1 person003 1 person004 1 person005 1 person006 1 person007 1 family002 1 person008 1 person009 1 person010 1 person011 1 person012 1 person013 1 person014 1 family003 1 person015 1 person016 1 family004 1 person017 1 person018 1 person019 1 person020 1 family005 2 person021 2 person022 2 person023 2 family006 3 person024 3       For your so large data, I would suggest to use batch mode,like:   "D:\SASHome\SASFoundation\9.4\sas.exe" -sysin "c:\temp\temp.sas" -log "c:\temp\temp.log" -memsize 0 "D:\SASHome\SASFoundation\9.4\sas.exe" -sysin "c:\temp\temp.sas" -log "c:\temp\temp.log" -memsize 20G to maximize the SAS memory size.   ... View more

Append to the Freelancer's post  if you have way too many variables need to rename. Macro variable has limited length   65534.   data _temp_; input x1 x2 x3 x4; datalines; 1 2 3 4 ;run; *Get all the variables name; proc transpose data=_temp_(obs=0) out=vname; var _all_; run; *Generate the new variable name; data vname; set vname; length new $ 40; new=cat('y',substr(_name_,2)); run; *Rename all the variables; data _null_; set vname end=last; if _n_=1 then call execute('proc datasets library=work nolist nodetails;modify _temp_;rename '); call execute(catt(_name_,'=',new)); if last then call execute(';quit;'); run;   ... View more

https://sas.service-now.com/csm/en/assess-the-effect-of-a-continuous-variable-using-a-contrast-or-estimate?id=kb_article_view&sysparm_article=KB0058379 https://sas.service-now.com/csm/en/examples-of-writing-contrast-and-estimate-statements?id=kb_article_view&sysparm_article=KB0057059 ... View more

1) Try this code filename src "&pptpath"; filename dst "&pptlocal"; -------> filename src "&pptpath" recfm=n; filename dst "&pptlocal" recfm=n; https://blogs.sas.com/content/sasdummy/2013/09/17/copy-file-macro/   2) Try RENAME() function: data _null_; rc=rename("c:\old\x.pptx","c:\new\x.pptx",'file'); put rc= ; run; ... View more

You could simply overwrite HTML file generated by PROC SGPLOT to get ID tag. It is very easy for SAS data step. ... View more