topic Re: Filter Rows in SAS Viya Data Studio on a column name containing spaces in SAS Data Management

Filter Rows in SAS Viya Data Studio on a column name containing spaces

SundareshS — Thu, 08 Feb 2018 21:25:38 GMT

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.

Using instructions in http://documentation.sas.com/?cdcId=dprepcdc&cdcVersion=2.1&docsetId=datahub&docsetTarget=p1sv89vo4n8f03n0zvq0k90i8g3t&locale=en#p03671a579d22tn16ok3zwifhkh8

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.

thanks

Re: Filter Rows in SAS Viya Data Studio on a column name containing spaces

LinusH — Fri, 09 Feb 2018 13:33:10 GMT

Not sure about Viya, but in SAS9, you can use the name literal:

'State Region'n

Re: Filter Rows in SAS Viya Data Studio on a column name containing spaces

SundareshS — Wed, 14 Feb 2018 15:35:23 GMT

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.

Re: Filter Rows in SAS Viya Data Studio on a column name containing spaces

Rushikesh — Fri, 23 Feb 2018 10:09:59 GMT

Hi Sundaresh,

I tried to apply filters on similar variable with spaces in variabe name and this is how it worked for me-

Condition:

'Team Name'n = 'Atlanta'

Please check attached screenshots.

Re: Filter Rows in SAS Viya Data Studio on a column name containing spaces

SundareshS — Fri, 23 Feb 2018 15:16:19 GMT

Thanks, Rushikesh , and apologies to LinusH - I must have messed up earlier. Glad to know that this works.