Hello SAS friends, I am new to SAS and I am still learning. I am in need of a program that generates a random ID. I found a script on this forum and made a few changes and it works, but it is not quite what I need. I need this script to force the random generating ID to Always use at least 1 upper case letter, 1 number and 1 special character (# or @). Is this possible? Here is the code I am using. data temp (keep=id_out); allowed="123456789AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz#@"; num_ids=1; idlen=8; array done{100} $200.; length my_id $6; num_allowed=length(strip(allowed)); i=1; do until (i=num_ids+1); do j=1 to 6; temp=ceil((num_allowed * rand("uniform"))); substr(my_id,j,1)=substr(allowed,temp,1); end; if whichc(my_id,of done{*})=0 then do; done{i}=my_id; i=i+1; id_out=my_id; output; end; end; run; Any help would be great!     ... View more

Greetings, I am using SAS University Edition and I am getting some issues with the following script. I expect it to accept the numeric values but it does not. Input data MySample1; input Firstfield secondfield thirdfield; datalines; 123 34 54 21 35 33 1 32 34 ; run; Proc Print Data=Sample;Run;   Output  Firstfield secondfield thirdfield1 . . .   Error NOTE: Invalid data for Firstfield in line 76 1-9. NOTE: Invalid data for secondfield in line 77 1-8. NOTE: Invalid data for thirdfield in line 78 1-7. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0   78 CHAR 1.32.34 ZONE 30330332222222222222222222222222222222222222222222222222222222222222222222222222 NUMR 19329340000000000000000000000000000000000000000000000000000000000000000000000000 NOTE: Invalid data errors for file CARDS occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. Firstfield=. secondfield=. thirdfield=. _ERROR_=1 _N_=1 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.MYSAMPLE11 has 1 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds     79 ; 80 run; 81 Proc Print Data=MySample11;Run;   NOTE: There were 1 observations read from the data set WORK.MYSAMPLE11. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more