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 🙂

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 991 views
  • 3 likes
  • 2 in conversation