topic Re: Can we refer to a variable in SAS enterprise guide with 3 level name? in SAS Programming

Can we refer to a variable in SAS enterprise guide with 3 level name?

GN0001 — Tue, 20 Jul 2021 20:01:39 GMT

Hello team,

I wonder if I want to refer to a variable name in SAS I can use this apporach:

libname + datasetname + variablename.

Please confirm it.

Regards,

blueblue

Re: Can we refer to a variable in SAS enterprise guide with 3 level name?

ballardw — Tue, 20 Jul 2021 20:17:24 GMT

Where to you think you need to use this?

Show an example of how this is to be used.

My first instinct is "no" but I don't use EG for much.

The SAS/AF Screen Control Language uses multilevels but the third is typically property of an object.

For any procedure that is using a specific data set the libname and dataset name are moot once loaded.

Re: Can we refer to a variable in SAS enterprise guide with 3 level name?

ChrisHemedinger — Tue, 20 Jul 2021 20:19:19 GMT

Can you provide an example where you might do that? It's not specific to SAS Enterprise Guide, but I'm wondering what type of SAS code you have where that would be a useful construct. Since SAS procedures are already (often) scoped to a particular data set...

Re: Can we refer to a variable in SAS enterprise guide with 3 level name?

GN0001 — Sat, 24 Jul 2021 06:33:07 GMT

Thanks for the input:

Here is example:

Proc sql,

Create table as mytable

select libname.tablename,columnname

from libname.tablename

quit

regards,

blueblue

Re: Can we refer to a variable in SAS enterprise guide with 3 level name?

ChrisNZ — Sat, 24 Jul 2021 06:35:55 GMT

As you can see if you try, this is invalid syntax.

Re: Can we refer to a variable in SAS enterprise guide with 3 level name?

Kurt_Bremser — Sat, 24 Jul 2021 06:43:23 GMT

Maxim 2: Read the Log.