Count and display the number, type and position of special character present in the sample string (space is an exception hence it can be ignored).   Create 3 additional variable Number - to display the unique number of special character present in the string Type – Print each special character in the order they appear in the string Position – Print all the position number in which each special character is present   See first observation for example   String Number Type Position S%pecial C*haract`er 3 % * ! 2, 10, 17 No Special Character       This li`st of       random! words       will he@lp spark       your creative       @imagination if you're       $looking to think       %up a d$omain n%ame,       a ban%d name,       a %project name       or wh%atever.       This %tool uses       thousands of       hand%picked       r%andom nouns       and ver!bs to max^im&ize       t%he possibility       of creating interesting       !b@r#a$i%n^s&t*o*r(m)i-n*g/ -i=d~e#a$s^.           I tried answering this question, but have been facing a lot of issues.....   This has been my code so far: data one; length String $100.; infile 'new1.txt' dlm='09'x; input String$; run; Data two; set one; l=length(String); array a{40} _temporary_; array Position{40} P1 - P40; do i=1 to l; a{i}=anypunct(String); if a{i}=0 then Position{i}=compress(put(i,best.)); end; do x=1 to 39; Pos1=Compress(put(Position{x},best.)||", "||put(Position{x+1},best.)); Pos=Compress(Pos1 ||", "); end; run; proc print data=two; run;   Please advice........ ... View more

Hi all,   I was working on a mini project to take in input from the user in order to use that input for an external utility program. I have structured a menu for the window in such a way that all inputs are to be entered on the dialog boxes arising from different parameters selected in the menu. But I have been undergoing a couple of issues in the same: (a) This program doesn't seem to work the way it is supposed to outside the sas environment (I use the unix environment) (b) The two date variables in the program are left unaltered, i.e; at the end of the program I only get xxxxxxxxx and xxxxxxxxxxxxxxxxxxxxxxx for the variables dblock and lckdtrf respectively.   My programs are as follows:   /*****pmenu2*****/   libname prith '/home/gurunatp/utilitytask'; proc pmenu catalog=prith.menus; menu Conf; item 'Confirm entered parameters' menu=start; item 'Bye'; menu start; item 'YES' selection=utility; item 'NO' selection=back; selection utility 'end;pgm;include /home/gurunatp/utilitytask/utility.sas;submit'; selection back 'end;pgm;include /home/gurunatp/utilitytask/pmenu3.sas;submit'; run; menu BASE; item 'Enter parameters' menu=parameters; item 'Bye'; menu parameters; item 'Study' Dialog=study Help='Enter the Study'; item 'Database Lock date' Dialog=dbl Help='Enter the Database Lock date'; item 'Lock request date and time' Dialog=lckdt Help='Enter the Lock request date and time'; item 'Lock user' Dialog=lckus Help='Enter the ID of the user running the program'; item 'Display Parameters' Selection=display; Dialog study 'pgm;include /home/gurunatp/utilitytask/dat1.sas;c xxxxxxxx @1;submit'; text #1 @1 'Enter Study:'; text #3 @15 len=8; Dialog dbl 'pgm;include /home/gurunatp/utilitytask/dat2.sas;c xxxxxxxxx @1;submit'; text #1 @1 'Enter Database Lock date:'; text #3 @15 len=9; Dialog lckdt 'pgm;include /home/gurunatp/utilitytask/dat3.sas;c xxxxxxxxxxxxxxxxxxxxxxx @1;submit'; text #1 @1 'Enter the Lock request date and time:'; text #3 @15 len=23; Dialog lckus 'pgm;include /home/gurunatp/utilitytask/dat4.sas;c xxxxxxxxxxxxxxxxxxxx @1;submit'; text #1 @1 'Enter the ID of the user running the program:'; text #3 @15 len=20; Selection Display 'end;pgm;include /home/gurunatp/utilitytask/dat.sas;submit'; run; quit; /* define Window */ %window INPUTS Menu=prith.menus.BASE #4 @10 'This application allows you to' #6 @13 '-Enter necessary parameters for running' #8 @13 ' the EDM to SDTM utility' #10 @13 '-Exit from the SAS system' #19 @10 'You must have the PMENU facility ON' #20 @10 'Select Enter parameters or BYE'; /* display window */ %display INPUTS;     /*****dat1.sas*****/   data prith.dat1; study='xxxxxxxx'; run;   /*****dat2.sas*****/   data prith.dat2; dblock='xxxxxxxxx'; run; /*****dat3.sas*****/   data prith.dat3; lckdtrf='xxxxxxxxxxxxxxxxxxxxxxx'; run;   /*****dat4.sas*****/   data prith.dat4; lckuser='xxxxxxxxxxxxxxxxxxxx'; run;   /*****dat.sas*****/   data prith.dat; set prith.dat1; set prith.dat2; set prith.dat3; set prith.dat4; run; %window OUTPUTS Menu=prith.menus.Conf #4 @10 'Study:' #6 @13 'Database lock date:' #8 @13 'Lock request date and time:' #10 @13 'Lock user:' #19 @10 'You must have the PMENU facility ON' #20 @10 'Select Confirm entered parameters or Bye'; /* display window */ %display OUTPUTS;   /*****pmenu3.sas*****/   /* define Window */ %window INPUTS Menu=prith.menus.BASE #4 @10 'This application allows you to' #6 @13 '-Enter necessary parameters for running' #8 @13 ' the EDM to SDTM utility' #10 @13 '-Exit from the SAS system' #19 @10 'You must have the PMENU facility ON' #20 @10 'Select Enter parameters or BYE'; /* display window */ %display INPUTS;       Kindly advice on how I can rectify the aforementioned issues?   Thanks and regards, Dobbie ... View more

Hello all,   I went through the available resources to learn about the PMENU procedure. But I haven't really been able to figure out how to configure dialog boxes to take in user input and put it into a dataset. I know that we need to specify a command string to define what the dialog is meant to do with the user input. In the SUGI paper from http://www.sascommunity.org/sugi/SUGI94/Sugi-94-248%20Staum%20Staum.pdf I observed a sample command string to be dialog detlinfo 'end;include rptcode(detail);c xx @1;submit'; Frankly I didn't understand it at all. Now I am trying to make my own utility of sorts in order to take in 4 variables through dialog boxes. And I am unsure of what needs o be input in place of the command string to get the input from the user and input it into one dataset. My program is as follows:   libname prith '/home/dubby'; proc pmenu catalog=prith.menus; menu BASE; item 'Enter parameters' menu=parameters; item 'Bye'; menu parameters; item 'Study' Dialog=study Help='Enter the Study'; item 'Study' Dialog=dbl Help='Enter the Database Lock date'; item 'Study' Dialog=lckdt Help='Enter the Lock request date and time'; item 'Study' Dialog=lckus Help='Enter the ID of the user running the program'; Dialog study 'Study'; text #2 @3 'Enter the study'; text #4 @9 len=8; Dialog dbl 'Database_Lock_date'; text #2 @3 'Enter the Database Lock date'; text #4 @9 len=9; Dialog lckdt 'Lock_requestD&T'; text #2 @3 'Enter the Lock request date and time'; text #4 @9 len=22; Dialog lckus 'Lockuser'; text #2 @3 'Enter the ID of the user running the program'; text #4 @9 len=10; run; quit;   Kindly advice.....   ... View more

Hi all, I have a sample dataset of which i'd like to check if the observation starts with '/gb/pro/', and if it does, I need to concatenate it to the end of the previous observation with a ' ' in between. Kindly advice on how I could do so....   LINES chad,hardy,/gb/pro/cli/dat/ba/102/009/stab/blin/le0/tx.sas7bdat,old,xxxx,none,2/22/2008,9:51:7 chad,hardy,/gb/pro/cli/dat/ba/102/009/stab/blin/le0/tx.sas7bdat,new,add,read,2/22/2008,9:51:7 chad,hardy,/gb/pro/cli/dat/ba/102/009/stab/blin/le0/vs.sas7bdat /gb/pro/cli/dat/ba/102/009/stab/blin/le0/yc.sas7bdat,old,xxxx,none,2/22/2008,9:51:7 chad,hardy,/gb/pro/cli/dat/ba/102/009/stab/blin/le0/vs.sas7bdat /gb/pro/cli/dat/mb/102/009/stab/blin/le0/yc.sas7bdat,new,add,read,2/22/2008,9:51:7 chad,hardy,/gb/pro/cli/data/ba/102/009/stab/blin/le0/ye.sas7bdat,old,xxxx,none,2/22/2008,9:51:7 chad,hardy,/gb/pro/cli/data/ba/102/009/stab/blin/le0/ye.sas7bdat,new,add,read,2/22/2008,9:51:7 chad,hardy,/gb/pro/cli/data/ba/102/009/stab/blin/le0/yh.sas7bdat,old,xxxx,none,2/22/2008,9:51:7 ... View more