topic Re: Different icons in SAS output in SAS EG meaning? in SAS Programming

Different icons in SAS output in SAS EG meaning?

Phil_NZ — Wed, 17 Feb 2021 20:21:37 GMT

Hi all SAS Users,

This morning when I running the code suggested by @FreelanceReinh

data winsorize;
input Type $ INDC3 $ Year var1 var2;
cards;
AXX CNSTM 1994 0.01 0.08
MAS CNSTM 1996 0.05 .
RAF CNSTM 1994 0.07 0.08
AGG CNSTM 2004 0.07 .
CCC CNSTM 1996 0.02 .
RBB ENEGY 1998 0.05 0.88
RFB ENEGY 1999 0.06 0.89
TYB ENEGY 2018 0.05 0.48
;

data industry_return;
input INDC3 $ Year var3;
cards;
CNSTM 1988 1.2
CNTSM 1989 1.3
CNTSM 1990 1.5
CNTSM 1994 1.1
CNTSM 1996 1.7
CNTSM 2004 1.9
CNTSM 2018 2.1
ENEGY 1988 3.3
ENEGY 1996 3.5
ENEGY 1998 3.9
ENEGY 1999 4.2
ENEGY 2018 4.4
;

data _wins / view=_wins;
set winsorize;
_seqno=_n_;
run;

proc sql;
create table matching(drop=_seqno) as
select a.*, var3
from _wins a left join industry_return b
on spedis(a.indc3, b.indc3)<=10 & a.year=b.year
order by _seqno;
quit;

The result is like that

Can I ask what does the top right blue button of _WINS dataset mean? Because normally in the dataset in SAS EG, I see the right bottom red dot as in the MATCHING dataset.

Good morning and warm regards!

Re: Different icons in SAS output in SAS EG meaning?

Kurt_Bremser — Wed, 17 Feb 2021 20:29:44 GMT

That is because _WINS is a view:

data _wins / view=_wins;

Re: Different icons in SAS output in SAS EG meaning?

Phil_NZ — Wed, 17 Feb 2021 21:19:23 GMT

Hi @Kurt_Bremser

Is it only about the display icon or any further notice about that?

Cheers,

Phil.

Re: Different icons in SAS output in SAS EG meaning?

FreelanceReinh — Wed, 17 Feb 2021 21:41:11 GMT

Ideally you insert this line before the QUIT statement in the PROC SQL step:

drop view _wins;

This deletes the view (including the unfamiliar icon in your explorer window), which is no longer needed anyway.

Re: Different icons in SAS output in SAS EG meaning?

Reeza — Wed, 17 Feb 2021 22:05:44 GMT

A view is dynamic so what really happens is the code included in the view is run when you try and access that table. This is useful as it doesn't take space and will be updated when called.

It's not a static table with values that are constant, that would be a table.