Hi! 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. //Fredrik     "You can create two new calculated measures:   occupied: ============= IF occupancy = '1' then  return 1 ELSE 0   nonoccupied: ============= IF occupancy = '0' then  return 1 ELSE 0   Keep default aggregation (SUM)." ... View more

Hi! Do you read the general enhancements in "What's New"?     YES, always! Do you read the details list in "What's New"?     YES, always! Do you skim the lists?        sometimes, depending on the "size" of the general enhancements. Do you skip "What's New" completely?       Never!   I actually like the one with the pictures better, especially if the pictures show what's new and maybe even have some videos showing the changes and how to use them.   There would also be nice if there is a link to details (at the start and/or bottom) and text mode for further reading.   //Fredrik ... View more

One way could be to create a date variable with the value of the first day in each week, so for everyday in the week you create the date of the first day in that week. Don't know if it is possible, but one way to solve it.   The backdraw is that you can not display the week number in the report.   //Fredrik ... View more

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... //Fredrik ... View more

Hi! Sorry, but I don't understand your question, can you add some example of what yo want to do? 🙂 //Fredrik ... View more

Hi! https://lmgtfy.com/?q=sas+viya+connect+to+hadoop   https://lmgtfy.com/?q=sas+viya+load+data+from+enterprise+guide   😉   //Fredrik ... View more

Hi! To be able to do forecast you need a date variable. On that variable you can assign different formats, but (at least in v7.4) there are no week format and you can't do forecast on week...   As far as I know :0   //Fredrik ... View more

Hi! 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 🙂   //Fredrik   ... View more

Hi! If in VA tou can use functions like "TreatAs" and "Format" to change type. You will need to create calculated variables using these functions 🙂   //Fredrik ... View more

Hi! You can create two new calculated measures:   occupied: ============= IF occupancy = '1' then  return 1 ELSE 0   nonoccupied: ============= IF occupancy = '0' then  return 1 ELSE 0   Keep default aggregation (SUM).     //Fredrik   ... View more

I thought it would work by selecting then check box "All other" ? //Fredrik ... View more

Hi! Try changing the aggregation  from "SUM" to "MAX".   Otherwise you will rank on aggregated date values.   //Fredrik ... View more

Hi! Choose your variable containg the period from the drop down then doing the rank.  Then select the highest 13 values. Select the new numeric variable as "by".   I tried to modify my swedish version to english 🙂   Working?   //Fredrik ... View more

You can solve that using sessions. You can save a table to the session and pick it upp from any other program using the session ID 🙂   https://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sessions.html   //Fredrik ... View more