topic Re: Lables in DI studio in SAS Data Management

Lables in DI studio

Babloo — Wed, 07 Mar 2018 14:21:20 GMT

I'm developing the DI job to convert the SAS dataset to the CSV file in DI Studio 4.21. I want to add the label for the following variables as follows, so that my output CSV file has the field names like cdnumpol, feemisio and produkt

t11.POLICY_ID as cdnumpol, 
t1.CREATED_DTTM as feemisio,
t2.PRODUCT_NAME as produkt

Could someone of you tell me how to accomplish this?Adding the description to those variables didn't worked though.

Re: Lables in DI studio

LinusH — Wed, 07 Mar 2018 15:52:06 GMT

You are changing column names, not SAS labels with that code.

please also share your CSV file generation code so we can see what's going on.

Re: Lables in DI studio

Babloo — Wed, 07 Mar 2018 15:59:55 GMT

Could you please tell me how to change the column names in DI studio?

I don't have code for CSV file generation.

Re: Lables in DI studio

LinusH — Wed, 07 Mar 2018 16:55:24 GMT

Some confusion here.
It seems from that code snippet you already change the column names.
Labels are reflected in column descriptions.

Re: Lables in DI studio

Babloo — Wed, 07 Mar 2018 17:01:55 GMT

I didn't changed the column names. I want to change it as I mentioned in my
initial post.

Re: Lables in DI studio

Patrick — Thu, 08 Mar 2018 01:44:31 GMT

Then use something like the Extract Transformation and map your source table into a target table or view (green table) with the new column names and then use this table/view as input to the File Writer.