libname educlib 'sasdemo.educcats.screens' server=abcserv sapw=demopw; libname tempOut '.'; proc datasets; copy in=educlib out=tempOut index=no; select tab1 tab2 tab3 etc......; run; quit; PROC UPLOAD only allows for the upload or the destination-side recreation of an index.  If you want to no have an index at all after the transfer use a different procedure, such as PROC DATASETS. ... View more

If you really wanted to accomplish this with regular expressions (say your real data is much more complex than this data) then an approach to use could be similar to the following: data have; a='2A345';output; a='2B134';output; a='3C124';output; a='4D123';output; run; data want; array r[4] $1 _temporary_ ('1' '2' '3' '4'); prxid = prxparse('/(A)|(B)|(C)|(D)/io'); do until(done); set have end=done; pos = prxmatch(prxid, a); if pos then do; idx = prxparen(prxid); substr(a, pos, 1) = r[idx]; end; output; end; run; ... View more

data foo; infile cards length=len; input @; _1=findc(_infile_, 'MF', 2)-1; _2=len-_1-6; input name $varying32. _1 gender $1. num 6. state $varying32. _2; cards; AronM374856Texas BrandonM847584California JaneF856747Huston ClarindaF748574Newyork ArnoldM435867Huston ; run; makes a good point here, and you should consider his suggestion. ... View more

Here is an example using bash and Oracle's sqlplus tool: #!/bin/bash #Defaults USER="user" PASS="pass" PATH="database" #Usage function usage { echo "                                          " echo "Usage:                                    " echo "                                          " echo "  ${0##*/} [-u] [-p] [-d] SEX             " echo "                                          " echo "    -u | --user   + Username    + ${USER} " echo "    -p | --pass   + Password    + ${PASS} " echo "    -d | --path   + Database    + ${PATH} " echo "                                          " echo "    SEX           + M/F                   " echo "                                          " } if [[ "$1" =~ ^((-{1,2})([Hh]$|[Hh][Ee][Ll][Pp])|)$ ]]; then   usage; exit 1 else   while [[ $# -gt 0 && "$1" =~ ^-{1,2}.* ]]; do     opt="$1"     shift;     current_arg="$1"     if [[ "$current_arg" =~ ^-{1,2}.* ]]; then       echo "ERROR: You left an argument blank." >&2       exit 1     fi     case "$opt" in       "-u"|"--user" ) USER="$1"; shift;;       "-p"|"--pass" ) PASS="$1"; shift;;       "-d"|"--path" ) PATH="$1"; shift;;       *             ) echo "ERROR: Invalid option: \""$opt"\"" >&2                       exit 1;;     esac   done fi SEX=$1 if [[ "${SEX}" != "M" && "${SEX}" != "F" ]]; then   echo "ERROR: Invalid value for SEX" >&2   exit 1 fi sqlplus -s $USER/$PASS@$PATH << __SQL__ set echo off head off pages 0 trimspool on feedback off timing off time off    SELECT *      FROM mytable     WHERE sex = '${SEX}'; exit __SQL__ Here is an example using PROC SQL in SAS, just replace the bottom: #ensure sas in $PATH sas -stdio -sysparm "$USER $PASS $PATH $SEX" << __SAS__ 2>/dev/null    DATA _NULL_;       CALL SYMPUTX('sex', CATS("'", "%scan(&sysparm, 4)", "'"));    RUN;    PROC SQL;       CONNECT TO ORACLE(USER=%scan(&sysparm, 1) PASS=%scan(&sysparm, 2) PATH=%scan(&sysparm, 3));          SELECT * FROM CONNECTION TO ORACLE (             SELECT *               FROM class              WHERE sex=&sex          );       DISCONNECT FROM ORACLE;    QUIT; __SAS__ Or do it all in SAS with a macro: #!/bin/bash SYSPARM=$(echo ${@} | tr " " ",") /usr/local/SASHome/SASFoundation/9.4/sas -stdio -sysparm "$SYSPARM" << __SAS__ 2>/dev/null %macro mymacro(sex, USER=foo, PASS=bar, PATH=mydb)/minoperator;    data _null_;       file stdout;       put "NOTE: USER=&user PASS=&pass PATH=&path";    run;    %if not(&sex in M F) %then %do;       data _null_;          file stdout;          put "ERROR: Invalid value for SEX";       run;       %abort return 1;    %end;    proc sql;       select * from sashelp.class where sex="&sex.";    quit; %mend; %mymacro(&sysparm.); __SAS__ Obviously, these are all overly simple examples. ... View more