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.
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.
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.
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.