Hi ,
I am experience BASE SAS user but a learner in DI studio 4.2. I am having simple problem:
I created a metadata for a table and then did the check in.
Then I had to add one more column to the table , I checked out the table and went to the properties tab to add the column.
After adding the column, I checked in the table.
Now when I am trying to open the table I am getting an error , "there was a problem in correlation ...and loading the SAS view ....and it mentions the newly added column name in the error'.
Can some please advise where I am going wrong.
Thanks,
Ashish
DI Studio is not a DBA tool, it just modifies metadata.
The metadata it self generates SAS code that is executed.
No code is created for altering/changing table layout.
If you change a table in dev/test environments, chances are that it's ok to just delete the table and let the next run of a job recreate the table with additional columns.
if you wish to extend an existing tbale in prod, you need to develop a scripts that ads the nes column and preserve existing data,
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.