About Hagen

Hagen · ‎07-30-2012

Hi, thanks for your answer. Unfortunately that didn't work. The point is, that I want to reuse the code in different projects and it should always refer to the preceding dataset. Best regards

Hagen · ‎07-27-2012

Hi there, how do I have to change the code: proc datasets memtype=data; modify OUTPUT.OF_PRECEDING_NODE; to tell SAS that it should modify the output of the preceding node without specifying the output dataset' name? Thanks a lot in advance. Regards

Hagen · ‎07-27-2012

Hi there, thanks for your answers and sorry for coming back to you so late. I am trying the following script: proc import datafile="c:\columnsdescriptions.xls" dbms=excel out=work.labels replace; getnames=yes; run; *filename gencode temp; filename gencode 'C:\gencode.sas'; data _null_; set work.labels end=eof; file gencode; if _n_=1 then do; put "proc datasets lib=LIB nolist;"/ "modify DEMO_CUSTOMERS;"; end; put ' label ' variable ' = "' label '";'; if eof then put "quit;"; run; *error occurs here: %include gencode; filename gencode clear; this throws the error: ERROR: The HEADER/VARIABLE UPDATE function is not supported by the ODBC engine. I don't understand this error message, as I am just trying to change the internal label and not a column name in the database. Any ideas on how to solve that? Best regards

Hagen · ‎07-12-2012

Hi Shiva, thanks for your reply. The use of management console goes along with the use of a metadata server right? As I don' t have a metadata server in place I cannot use mgmt console? Cheers

Hagen · ‎07-12-2012

Hi there, I merge some tables using SAS Enterprise Guide. Afterwards I create a report based on this merged data set. Is there any chance to change the database names of the attributes to a user friendly name, meaning using spaces and variable names with a length greater than 32 characters? If this is possible, can I write a program in EG which renames all variables based on a csv-List (looking for example like: "databaseAttributeName;New Name With Special characters" ). Thank you very much in advance for your answers Best Regards

Hagen · ‎07-03-2012

Hi there, I would like to use the SAS Enterprise Guide Explorer to create a permanent library. This shall be a conncetion to an Oracle Express database. I managed to assign a library using Tools "Assign Project Library" but if I start SAS Enterprise Guide Explorer I cannot create a new library as the item is greyed out in the menu. I am running Enterprise Guide in a VM - no Server so the connection profile is <<do not use a profile>> EG version is 4.3. Thanks for your ideas in advance. Best regards Hagen

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Using output of preceding node

Using output of preceding node

Re: Renaming attributes in a user friendly manner

Re: Explorer - create library

Renaming attributes in a user friendly manner

Explorer - create library