I have a category that has 2 values. I know that i am able to duplicate the category, however would like to know whether i am able to permanantly remove a value from the category.
Hello. I would like to apologize for being unclear with my message,
I have an occupancy column with 2 values, 0, 1. I would like to know if there is a way to separate the values into a column each eg: Unoccupied = 0
I have tried using substrings, filters and creating new categories to manipulate the 2 values but to no avail. At the same time, a side question, is changing the datatype of category to measure possible?
Hello, i thank you for the reply,
I am required to create some dashboards for the client. The dashboards will give an over view about room usage :
I inted to separate the occupance data into 2 different variables, occupied and non occupied. At the same time, i would like to find a way on how to convert the category datatype to measure to enable the be variables to be placed in the measure (y) axis of the graph above.
I apologize for any troubles caused
Hello and thank you for the reply,
I am unable to create calculated measures, the only option was for me to create a new aggregated measure. When brought to the formula screen, i dragged the boolean IF/ELSE statement to the workspace and dragged the category in. After it got dragged in, i got thrown an errror saying wrong type assigned.
These 2 screenshots are the options that are displayed, as i mentioned, there is no option to create aggregated measures
If I cant create calculated measures, what should be my next step? Do i have to ensure that the data thatt gets loaded into VA must be of the proper values? Does VA allow flexible type conversion?
Sorry if I mislead you, I only have the swedish version....:)
You should select "New Calculated Item..." and create two new "items", one for occupied and one for nonOccupied as a showed earlier.
Go into "text edit" (or what it's called in the english versoin....:)) and copy/paste the formulas I gave you, they might need some fine-tuning to fit your exact data 🙂
I apologize for the vagueness of the question.
As with the previous question, i want to separate the values (0,1) into 2 different categories. However, now instead of occupancy being a category type, it is now a measure type.
Will separating the values 0 and 1 be possible for occupancy with the data type of measure
Once again i apologize for any troubles caused.
No probz 🙂
You can't create rows in VA, so if you have one row containing the measures you can't create two dimension values on separate rows, which i guess is what you want to do 🙂
You can create two (or more) dimension values on the same row, but I don't know if it is usable in your case...
Hello Sir, i fail to understand what you meant in your past reply,
I hope the information i have provided can help you understand my situation better,
I intend to make a butterfly graph
As shown in the graph above, i require 1 category and 2 measure data types. I already have the category data prepared. I am however, having problems with the measure data. Within the occupancy measure data, there are 2 values as shown below. (Im am using category data for show/reference)
My question is that since occupancy is classified as a measure data type how do i separate the values 0,1 and the data into 2 different varibables. (below is a screen short of the intended outcome)
As mentioned not occupies will only have the zeros
and occupied will only have ones
I apologize for the repeated question Mr Fredrick. I appreciate any and all the help that you have given me
I think you can use my earlier suggestion, if I understand you correct 🙂
You can descide if you want to have 0/1 in both variables by changing the expression.
"You can create two new calculated measures:
IF occupancy = '1' then return 1
IF occupancy = '0' then return 1
Keep default aggregation (SUM)."
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.