topic Re: Label for data in reports in SAS Data Management

Label for data in reports

DanielYar — Wed, 24 Apr 2019 08:29:42 GMT

I'm using SAS Viya suite. I have my data about different units in the organisation as integers (category) 1-9. However, I'd like to present these with the unit's name in the report I'm creating. How can i get the actual names in the report instead of the integers/codes (1-9)?

I have access to SAS Studio and Prepare data.

Re: Label for data in reports

JBailey — Thu, 25 Apr 2019 19:06:19 GMT

Hi @DanielYar,

This sounds like a job for SAS Formats. Fortunately, there is a video for that.

Creating User-Defined Formats with the FORMAT Procedure in SAS® Viya™

Hope this helps.

Best wishes,

Jeff

Re: Label for data in reports

DanielYar — Fri, 26 Apr 2019 10:27:11 GMT

Thank you @JBailey for the reply. it is indeed an advanced solution. For myself with (very) limited coding experience it is rather not an option for now. I thought maybe there could be ways of using report builder features to deal with it.

Thanks again, Daniel

Re: Label for data in reports

JBailey — Fri, 26 Apr 2019 13:21:16 GMT

Hi @DanielYar

Are you using SAS Enterprise Guide?

Best wishes,
Jeff

Re: Label for data in reports

DanielYar — Fri, 26 Apr 2019 16:20:09 GMT

Hi Jeff,

No, I don´t use the Enterprise Guide. I am quite new to SAS and start directly with the last version of Viya last autumn. I just had a Web-based training that give me the basic knowledge about the suite. However, not coding or advanced function yet.

However, I found a work around to the problem by creating new items in the data set with new labels. This add some new items to the table but solve the current problem.

Nevertheless. Id like to go ahead learning more about what you were suggesting and the coding.

Thanks for the engagement Jeff.

Best, Daniel

Re: Label for data in reports

JBailey — Wed, 01 May 2019 14:27:57 GMT

Hi @DanielYar

I am happy that you are making progress. If you need anything else, holler!

Best wishes,
Jeff

Re: Label for data in reports

LinusH — Sun, 05 May 2019 11:49:39 GMT

Even though I haven't used it my self, but I'm pretty sure that there are functionality in Data Preparation to either join with a look up table, or provide a couple of values (If their not too many).

Re: Label for data in reports

ChrisLysholm — Sun, 05 May 2019 17:26:50 GMT

The SAS Data Studio product does provide the 'join' transform as well as a 'calculated column' transform. For this scenario though, I am not sure that 'calculated column' transform would suffice as this transform supports calculation of column in form: <column> = <expression>;

Data Studio also provides the 'code' transform which could be used for this use case. Logic could be added such as if/else or select statement to create column.

Documentation for SAS Data Studio to create custom code: SAS Data Studio 2.2 - Create Custom Code