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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.