How to select specific columns from a datagrid into another datagrid ?

[iyerdeepa82]

Hi,

We have SAS CI Studio, version 6.4. I have a datagrid, which has multiple columns. I need just 10 columns out of that, hence I want to do a TABLESEECT with just columns of interest.

When I try specifying the column names in TABLESELECT , I get a SAS exception.

Syntax Used:

TABLESELECT(<<identifiers.Party Details>>,
'<<identifiers.Party Details>>.name,  '<<identifiers.Party Details>>.name EQ <<identifiers.Name>>')

Please advise, what are the other options?

Thanks,

Deepa

[JamesAnderson · Accepted solution]

Hi Deepa,

It looks like the issue is with the ColumnClause part of the TABLESELECT function. 

The documentation for TABLESELECT says:

columnClause

specifies the columns that appear in the new data grid variable. Use an asterisk (*) to specify all of the columns in the data grid. Use a list of column names that are separated by semicolons (;) to designate specific columns. These column names must be specified as strings and must be the actual column names in the data grid. You cannot use identifiers to specify column names.

.......

I also think you are missing a single apostrophe after your column clause.

Regards

James

[iyerdeepa82]

Thank you very much James for your prompt response. When I got rid of identifiers and used the column names directly, it started working !

Thanks,

Deepa