Ksharp Tracker

Re: Does hash join not honor the memsize limitation?

Ksharp — Thu, 17 Sep 2026 07:38:38 GMT

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.

Re: ReWriting a CSV to remove end of file reference

Ksharp — Wed, 16 Sep 2026 11:10:50 GMT

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

Re: Column shift due to unbalanced quotes

Ksharp — Sat, 12 Sep 2026 06:32:56 GMT

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"

Re: Hyperlinks within text string - Export to Excel

Ksharp — Thu, 10 Sep 2026 01:52:46 GMT

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;

Re: Using PROC COMPARE with Case Insensitivity

Ksharp — Fri, 04 Sep 2026 11:01:57 GMT

Quentin,

Same with me . I learned something new and forgot it and remember it again .

Re: Remove decimal points in PROC FREQ cross tab

Ksharp — Thu, 03 Sep 2026 11:33:43 GMT

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;

Re: Using PROC COMPARE with Case Insensitivity

Ksharp — Thu, 03 Sep 2026 11:20:32 GMT

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;

Re: Connecting all possible individuals within a family, aka connecting paired nodes

Ksharp — Tue, 25 Aug 2026 07:01:57 GMT

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 $;

Re: Connecting all possible individuals within a family, aka connecting paired nodes

Ksharp — Sat, 22 Aug 2026 07:18:26 GMT

Of course. The best choice is using SAS/OR - proc optnet:

proc optnet data_links=have out_nodes=want GRAPH_DIRECTION=UNDIRECTED;
data_links_var from=from to=to;
concomp;
run;

Re: Connecting all possible individuals within a family, aka connecting paired nodes

Ksharp — Sat, 22 Aug 2026 07:22:38 GMT

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.

Re: Any way to rename a set of variable names?!

Ksharp — Wed, 19 Aug 2026 07:28:43 GMT

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;

Re: Write contrast between interaction between a continous and spline variable

Ksharp — Tue, 18 Aug 2026 06:51:45 GMT

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

Re: SAS email won't attach PowerPoint slide

Ksharp — Thu, 13 Aug 2026 10:15:58 GMT

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;

Re: How to switch order and color of levels for the overlay variable in proc gradar

Ksharp — Thu, 06 Aug 2026 12:36:37 GMT

This one ?

data wide;
length Variety $10;
input Variety $ a_texture b_texture c_texture d_texture e_texture f_texture g_texture;
 
 
datalines;
GEM 45.61 23.20 47.56 5.07 4.09 37.43 3.31
Hass 62.38 17.93 59.45 3.51 9.36 8.77 2.34
;
run;
 
 
proc sort data=wide out=long;
    by Variety;
run;
 
/* Transpose texture */
proc transpose data=long name=texture_label out=long1(rename=(COL1 = texture_value) );
    by Variety;
    var a_texture b_texture c_texture d_texture e_texture f_texture g_texture;
run;  
 
  PROC PRINT DATA=long1 ;
RUN ;
 
data longnew;
    set long1;
    if texture_label = 'a_texture' then texture_label = 'Creamy';
    else if texture_label = 'b_texture' then texture_label = 'Mushy';
else if texture_label = 'c_texture' then texture_label = 'Smooth';
else if texture_label = 'd_texture' then texture_label = 'Stringy';
else if texture_label = 'e_texture' then texture_label = 'Dry';
else if texture_label = 'f_texture' then texture_label = 'Watery';
else if texture_label = 'g_texture' then texture_label = 'None';

if Variety='Hass' then Variety=' Hass';
run;
 
PROC PRINT DATA=longnew ;
RUN ;
 
 goptions reset=all cback=white border htitle=12pt htext=12pt;
footnote1 j=c h=10pt "GEM N = 513, Hass N = 513";
title1 j=c h=13pt 'Comparison of texture between GEM and Hass (relative %)';
proc gradar data=longnew;
   chart texture_label / freq=texture_value ORDERACROSS=FORMATTED
                 overlay=Variety
                 starcircles=(25 50)
                 cstarcircles=black
                 cstars=(  aqua red)
                 wstars=(2 2)
                 cframe=white
                 ;
run;
quit;

Re: ODS SGPLOT to create HTML ID tag for every chart element

Ksharp — Thu, 06 Aug 2026 12:08:26 GMT

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

Re: Transpose Account Data which has multiple entries into multiple columns.

Ksharp — Wed, 05 Aug 2026 14:31:57 GMT

The most simple way is using PROC SUMMARY.

data test;
   infile cards truncover expandtabs;
   input Accno $ TranDate:date9. TranAmt TranCode;
   format trandate date11.;
   datalines;
Account1	21-Jul-26	75.26	53
Account2	24-Dec-21	26.86	53
Account3	16-May-14	40	53
Account3	16-Jan-15	40	53
Account3	16-Sep-15	40	53
Account3	16-Oct-15	40	53
Account4	3-Mar-23	20	53
Account5	2-Nov-20	1	53
Account5	2-Dec-20	1	53
Account5	31-Dec-20	1	53
Account5	2-Feb-21	1	53
Account5	2-Mar-21	1	53
;;;;
proc sql noprint;
select max(n) into :n from
(select count(*) as n from test group by Accno);
quit;
proc summary data=test;
by Accno;
output out=want idgroup(out[&n] (TranDate TranAmt TranCode)=);
run;

Re: need help-cannot access SAS studio (SAS OnDemand)

Ksharp — Wed, 05 Aug 2026 14:01:47 GMT

I have the same issue about ODA. Still is unable to access it . I don't know why ,but you could contact with SAS technical support or calling this community Admin @ChrisHemedinger

Forbidden
You don't have permission to access this resource.

Apache Server at welcome.oda.sas.com Port 443

A workaround way is downloading SAS (PC version) from Internet. That would be very convenient and fast to use SAS software.

Re: SAS Support Communities metrics and their trends

Ksharp — Tue, 04 Aug 2026 01:41:32 GMT

Sure. SAS is going better and I am going better.

Re: need help-cannot access SAS studio (SAS OnDemand)

Ksharp — Tue, 04 Aug 2026 02:04:35 GMT

"I dive into wrong field"
I mean you are going with a wrong direction ,or picking up a wrong skill/software.

In China ,it is very hard to find a job related to SAS.

Even SAS company in China has dropped out at Nov2025. All the SAS employee in China have lost their job! But I love to see it happended ! 😀

In order to get a job, you could try to learn others like Java,C# if you don't like Python .

Re: need help-cannot access SAS studio (SAS OnDemand)

Ksharp — Mon, 03 Aug 2026 07:34:25 GMT

You are diving into wrong field.
Since your English is so good, why not learn Python and find a job at AI field/company ?