02-08-2018 04:25 PM
While trying to import a sas dataset (sas7bdat) in Viya (Prepare / Manage Data) and load into CAS:
I turn on the filter rows option on.
I have tried various options on a sample dataset "Digital Clickstream Data" - such as
"State Region" = "Georgia"
'State Region' = "Georgia"
"State Region" = 'Georgia'
The problem is - the WHERE condition works perfectly for cases where there are no spaces in the column name (e.g. City="Placintas") however, I get zero rows (no error) whenever I try to use a column name which contains spaces.
02-14-2018 10:35 AM
Thank you - however this did not work - either with double quotes or single quotes.
The attached error might explain better - basically the Filter Row condition is packaged into a WHERE clause, and this seems to be an incorrect syntax.
I tried another method - made use of the Viya Filter Data task (in SAS Studio) and obtained the code behind it - however, that still makes use of the ' 'n method for variables with spaces.
This somehow does not seem to work in SAS Data Studio/ Data Preparation.
02-23-2018 05:09 AM
I tried to apply filters on similar variable with spaces in variabe name and this is how it worked for me-
'Team Name'n = 'Atlanta'
Please check attached screenshots.
Need further help from the community? Please ask a new question.