topic Re: Measure to Category conversion in SAS VA in SAS Visual Analytics

Measure to Category conversion in SAS VA

Rahul_SAS — Wed, 23 Aug 2017 05:10:22 GMT

Hi Experts,

I using variables Sr No, Emp Code as category that contains all numeric values(like 0001-9999 and 40000-70000) so converted before bringing into LASR and its showing under Category also. But when I am using these variable in calculated column or filter expression its coming as Measure.

Actually I want parameterise my report search using these variables so using these variable in filter expression with parameter like:

(Emp ID) Contains (Parameter Emp ID)

but its coming as measure so not able to use Contain function.

Couldn't figure out the problem.

Please help.

-Rahul

Measure to Category conversion in SAS VA

Rahul_SAS — Wed, 23 Aug 2017 05:08:06 GMT

Hi Experts,

Actually I want parameterise my report search using these variables so using these variable in filter expression with parameter like:

(Emp ID) Contains (Parameter Emp ID)

but its coming as measure so not able to use Contain function.

Couldn't figure out the problem.

Please help.

-Rahul

Re: Measure to Category conversion in SAS VA

Kiwi_Colin — Wed, 23 Aug 2017 05:33:45 GMT

Hi Rahul

You'll be pleased to find this is very quick to fix.

As you've found, when a numeric variable comes into VA it defaults to being a measure.

If you want it to be a category, you can easily change it to that.

Click on the data item in the left pane

> See properties of that data item at the bottom, with "Classification" shown as "Measure"

> Click on "Measure", and select "Category" from drop down

Or can "Right-mouse" click on data item in left pane, and choose "Category"

Done! It now can be used as a category. Of course you can't do calcuations on it now.

If you need to use it in both ways, that is as "Category" and "Measure", you can duplicate the data item, call it a different name, and change that one to a "Category".

A classic for this is age. You may want age as a "Measure", to get average or max age. And also want age as a "Category", to have certain age groups, so can show bars for each age group.

Hope that helps,

Re: Measure to Category conversion in SAS VA

Rahul_SAS — Wed, 23 Aug 2017 05:43:16 GMT

Thank you sooo much kiwi_colin for your prompt reply.

I have already used the solution you have mentioned above.

The problem persist even after converting that variable into category as I mentioned in my post that its showing in Category segment only.

I am not able to use that converted categorical variable as categorical variable its still coming as Measure when I try to use that in a Calculated column or Filter Expression.

-thanks

Re: Measure to Category conversion in SAS VA

sas_viclearner — Wed, 18 Oct 2017 01:21:11 GMT

Hi Colin,

I have a numeric measure "year" and to convert it into category variable "Year" do i need to duplicate the numeric measure and name it with category variable name

Re: Measure to Category conversion in SAS VA

MichelleHomes — Wed, 18 Oct 2017 02:13:28 GMT

Hi @sas_viclearner,

You would only need to duplicate Year if you need to have both a measure type and a category type for your analysis.

I've replied to the question you posted at https://communities.sas.com/t5/SAS-Visual-Analytics/convert-numeric-measure-year-to-category-variable-year/m-p/405078

Kind Regards,

Michelle

Re: Measure to Category conversion in SAS VA

Fredrik_Hansson — Wed, 25 Apr 2018 11:20:06 GMT

If the same dataset is used in multiple reports, and a certain numeric column is always used as a category, it might be a good idea to give the column a format. That will make the column a category in SASVisualAnalyticsDesigner by default.

* Format must be stored where Visual Analytics can find it     ;
libname formats "/opt/sas/config/Lev1/SASApp_VA/SASEnvironment/SASFormats/";

* Generic format that can be used for (m)any numeric variable(s)    ;
proc format library=formats.formats;
    value category
        .="Unknown age";
quit;

* Apply format to variables who are to be used as categories. Can be difficult to achieve in the databuilder.
* Do in dataintegration layer if possible.      ;
proc sql noprint;
    create view TEMP_LASR_VIEW_16353 as 
    SELECT
        CLASS.Name length=8 AS Name,
        CLASS.Sex length=1 AS Sex,
        CLASS.Age format=category. length=8 AS Age,
        CLASS.Height length=8 AS Height,
        CLASS.Weight length=8 AS Weight 
    FROM
        sashelp.CLASS CLASS;
quit;