topic Re: Help needed in PROC PDSCOPY in SAS Procedures

Help needed in PROC PDSCOPY

Sivanandam — Wed, 15 Jun 2011 05:29:50 GMT

Hi ,

When i run the below code am getting the following error message
ERROR 200-322: The symbol is not recognized and will be ignored.

ERROR 22-322: Expecting a name.

Code:
filename xx'xo94.control.userview' disp=shr;
filename yy'xo94.control.user' disp=old;
data siva;
input id $;
cards;
srgm2010
srgm2001
;
proc pdscopy indd=xx outdd=yy;
select "id @1";
run;

Could you please help me to resolve this..

Re: Help needed in PROC PDSCOPY

SushilNayak — Wed, 15 Jun 2011 12:00:26 GMT

You don't need to quote the member name. Remove the quotes around the member name id@1 and resubmit the code. It should work

proc pdscopy indd=xx outdd=yy;
select id @1;
run;

Re: Help needed in PROC PDSCOPY

sbb — Wed, 15 Jun 2011 13:21:07 GMT

The OP is wishing to generate the SELECT statement dynamically using a SAS file which is not properly supported.

One alternative is to read up the member list, generate a SAS macro variable and then reference that variable as the SELECT statement data value.

Scott Barry
SBBWorks, Inc.

Re: Help needed in PROC PDSCOPY

Sivanandam — Thu, 16 Jun 2011 04:45:52 GMT

Sushi,

It will not work because select statement will consider ID as a member and it will search in the PDS.

Thanks,
Siva.

Re: Help needed in PROC PDSCOPY

Sivanandam — Thu, 16 Jun 2011 10:01:11 GMT

Scott,
I tried with the follwoing code with MACRO its working fine

%let id=SRGM2001 SRGM20002;

filename xx'xo94.control.userview' disp=shr;
filename yy'xo94.control.user' disp=old;
data siva;
proc pdscopy indd=xx outdd=yy;
select &id;
run;

is it possible to pass the input members via the file.

Re: Help needed in PROC PDSCOPY

SushilNayak — Thu, 16 Jun 2011 11:08:08 GMT

I'm really sorry..i misunderstood your question...i thought u were selecting member ID@1 instead of ID & @1 ..my bad..Anyhow it seems you fixed the issue...for the getting members name within the macro variable. use PROS SQL

filename xx'xo94.control.userview' disp=shr;
filename yy'xo94.control.user' disp=old;

data siva;
input id $;
cards;
srgm2010
srgm2001
;
run;

proc sql;
select id into : memlist separated by ' '
from siva;
quit;

proc pdscopy indd=xx outdd=yy;
select &memlist;
run;

Re: Help needed in PROC PDSCOPY

sbb — Thu, 16 Jun 2011 13:27:51 GMT

Yes you can.

To pass the selection criteria via a file, you would need to use %INCLUDE to reference an input file and code the statement between a SELECT statement and a trailing statement with a semi-colon, as in:

FILENAME input "_your_input_selection_list" ;
PROC PDSCOPY ....;
SELECT
%INCLUDE input;
;
run;

Scott Barry
SBBWorks, Inc.

Re: Help needed in PROC PDSCOPY

Sivanandam — Thu, 16 Jun 2011 14:07:03 GMT

Thanks for all.
Both the mentod are working fine.