topic Re: Four level SAS name (libref/cat/dataset/etc). in SAS Programming

Four level SAS name (libref/cat/dataset/etc).

iyerkaren — Fri, 25 Sep 2015 11:02:41 GMT

Hi, I am confused about four level SAS names.

I have a program than runs proc report on a four level SAS name.

I read online four level SAS names are libref.catalog.entryname.entrytype.

I don't understand what entry name and type are, can anyone help?

Also, where does the dataset name come into it?

Thanks

Betreff: Four level SAS name (libref/cat/dataset/etc).

andreas_lds — Fri, 25 Sep 2015 11:41:06 GMT

Please post the code using the four level name.

Re: Four level SAS name (libref/cat/dataset/etc).

iyerkaren — Fri, 25 Sep 2015 12:04:19 GMT

Proc report data=c_sample.rwa_p&pp.&yy_live completerows completecols out=test (drop=_break_);

Re: Four level SAS name (libref/cat/dataset/etc).

iyerkaren — Fri, 25 Sep 2015 12:05:59 GMT

Sorry I meant to type

c_sample.rwa_p&pp.&yy._live

Re: Four level SAS name (libref/cat/dataset/etc).

RW9 — Fri, 25 Sep 2015 12:43:00 GMT

What software are you running, this doesn't look like base SAS, perhap Enterprise Guide or something else? Does the code work? In base SAS it is always <library>.<dataset>

Re: Four level SAS name (libref/cat/dataset/etc).

iyerkaren — Fri, 25 Sep 2015 14:29:27 GMT

Ah that's probably why I'm confused. I didn't realise the base SAS/enterprise guide difference. I am new to enterprise guide. Still, does anyone know what the code refers to? Thanks.

Re: Four level SAS name (libref/cat/dataset/etc).

ballardw — Fri, 25 Sep 2015 14:37:50 GMT

That is not a 4 level name. Since there are macro variables involved (the && bits) the "." is a concatenator.

If there were two dots ".." in the code then the macro processor would resolve that to a . separating the names.

Something, possibly a prompt(?) or menu selection is building a name for you if you didn't create that code.

With c_sample.rwa_p&pp.&yy_live

if there is something set so that a macro variable PP = DOG and a variable YY_LIVE=SHOE this would resolve to

c_sample.rwa_pDOGSHOE. The first do does not have a possible macro variable before it but the second does.

Re: Four level SAS name (libref/cat/dataset/etc).

Tom — Fri, 25 Sep 2015 15:26:16 GMT

The periods are part of the macro code, not part of the name.

c_sample.rwa_p&pp.&yy._live

&pp. will resolve to the value of the PP macro variable

&yy. will resolve to the value of the YY macro variable.

So this code

%let PP=ABC ;
%let YY=15 ;
%put c_sample.rwa_p&pp.&yy._live ;

willl write

c_sample.rwa_pABC15_live

to the log. There is only one period in the resulting value.

The period is needed on the &YY reference to mark where the end of the macro name is. Otherwise the macro processor would look for a macro variable named YY_LIVE instead of YY. It is not required on the reference to PP since the & following PP will signal the end of the macro variable name.

Re: Four level SAS name (libref/cat/dataset/etc).

iyerkaren — Fri, 25 Sep 2015 21:06:02 GMT

Thank you so much. No it's not my code I'm picking out data sources for work. Thanks!