About Sivanandam

Sivanandam · ‎07-24-2011

Hi, I didn't get any reply for my above requirement for three days which helped me to found the solution by my own. Filevar statement and TRANWRD statement satisifed my requirement. Please find the code as below filename yy'xo94.store'; filename xx'xo94.sas.modelid'; data ss; infile xx; input store $; length ftrw $50; ftrw ='xo94.control.parm('||trim(store)||')'; infile dummy filevar=ftrw sharebuffers end=done; FILE DUMMY FILEVAR=FTRW; do until(done); input @1 sss $80.; %INCLUDE YY; //Which contains TRANWRD stements put sss; end; run;

Sivanandam · ‎07-20-2011

Hi, I need to replace a string in the PDS member ,string which i need to change in each pds member are present in the seperate PS. Example; PDS:'xo94,sas,' member names are: SRGM2001 SRGM2002 SRGM2003 PS file: Below are the dat present int hePS file Membername String which want to replace in member SRGM2001 SRGM2005 SRGM2002 SRGM2006 SRGM2003 SRGM2007 I want to read the SRGM2001 from the PS file and need to search in the PDS file if found i want to open that member and need to search 2005 if present i need to replace with 2001 similarly for remaining members . Could you please help me to achieve this Thanks, Siva.

Sivanandam · ‎06-21-2011

Hi Scott, Thanks very much for you valuable suggestions.its working fine. Thanks, Siva.

Sivanandam · ‎06-16-2011

Hi Scott, I tried the below code but am getting the following error 63 change %include zz=%include ss; ERROR: Incorrect %INCLUDE statement will not be executed. There is a syntax ERROR 22-322: Expecting a name. ERROR 76-322: Syntax error, statement will be ignored. Code: filename yy'xo94.control.user' disp=old; filename zz'xo94.output.process1'; filename ss'xo94.output.process2'; data siva; proc pds ddname=yy; change %include zz=%include ss; ; run; Thank, Siva.

Sivanandam · ‎06-16-2011

Thanks for all. Both the mentod are working fine.

Sivanandam · ‎06-16-2011

Apologies forr the confusion.I need to change all the members which are in oldname in a pds to a new name ..This is my exact requirement. The oldname and the newname members are given in preivious post.

Sivanandam · ‎06-16-2011

I have list of PDS members(old named) as below Oldname Newname 2005 2344 3453 4353 5336 6788 I need to replace all the oldname members into a new name which is mentioned above .how i can achieve it? using change statement i can do it for each member one by one manually. But i need to make automatically change all the old names in to corresponding new name . Couold you please help me to resolve this.

Sivanandam · ‎06-16-2011

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.

Sivanandam · ‎06-16-2011

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

Sivanandam · ‎06-15-2011

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..

Sivanandam · ‎04-19-2011

Could you please provide me sample code so that it will be more helpful for me..

Sivanandam · ‎03-13-2011

In a file 'xo94.inputs' there are two variables userid and the modelid as beow Userid's modelid's Srgm2001 Srgm2345 Srgm2005 Srgm2678 Srgm3009 Srgm6997 There is a PDS 'xo94.control.userview' where all the above mentioned userid's will be there as a member. I need to copy all the content of usrid srgm2001 from 'xo94.control.userview' to the file 'xo94.control.userview1' as a member srgm2345. where the new member Srgm2345 should be create as a new member in the file'xo94.control.userview1'and once the content are copied to the newly created member i need to replace all 2001 to 2345 inside the member Srgm2345. similarly as a loop i need to copy for all members in the 'xo94.inputs' Could you please help me how to achieve this .If possible can you proivide me the code for this..

Sivanandam · ‎02-27-2011

Could you please tell us ..How to set the format as 32..

Sivanandam · ‎02-27-2011

Thanks for you reply..Its answers for my doubt..

Sivanandam · ‎02-20-2011

Am getting the output but the digits are coming in exponent form is there any possibilty to come in numeric without exponent form

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Fetching records with unique value

Fetching records with unique value

Fetching records with unique value

Fetching records with unique value

Re: Fetching records with unique value

Fetching records with unique value

Fetching records with unique value

Fetching records with unique value

Fetching records with unique value

Fetching records with unique value

Replacing strings in pds member

Replacing strings in pds member

Re: To rename the PDS members

Re: To rename the PDS members

Re: Help needed in PROC PDSCOPY

Re: To rename the PDS members

To rename the PDS members

Re: Help needed in PROC PDSCOPY

Re: Help needed in PROC PDSCOPY

Help needed in PROC PDSCOPY

Re: To copy the data from one member of the pds to the other

To copy the data from one member of the pds to the other

Re: To display morethan 16 digit in SAS mainframe

Re: doubt in label

Re: To display morethan 16 digit in SAS mainframe