BookmarkSubscribeRSS Feed
clcl
Calcite | Level 5

Hi ,

i have written a code in base and i want to copy it accross to DI , i have dragged in a user wirtten code box and pasted the code into the code area and it ran ok ,

how do i open the table ?

thanks CL

1 REPLY 1
Barnipaz
Obsidian | Level 7

If the problem is the in your user code you have created some table and you want to open them by right clik -> view the answer is this

On the right side of the user code cell you see a green table.

See the properties of that table by right clicking.

Create the metadata.

In the tab colums you can insert the colums of the table you have created.

In the Pysical Memorization tab (I've the italian version and and I didn't remember the english tab) you can insert the phisycal position of the tabel.

Remember this: it's NOT necessary to register the table, but its NECESSARY that the library si registerd on the metadataserve

If you have created more then one table add more 'work table' using the right click of the mouse on the 'user written code' cell

If you have registerd the table tha you can substitute it always in the right click menu.

PS: sorry for the sloppy english 🙂

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 880 views
  • 3 likes
  • 2 in conversation