Afternoon All, Anyone able to create a Unique Index with Proc SQL and the PW= option for a protected dataset? Works fine when creating a simple index (example); Proc Sql;      Create Index MY_COL on MY_DATASET (PW=MYPASS); Quit; However, I've tried different permutation of syntax and failed miserably, the only way I have been able to get it to successfully work is to remove the dataset protection then apply the UI and then re-apply the protection. No Protection (OK) Proc Sql;      Create Unique Index MY_INDEX on MY_DATASET (COL1,COL2); Quit; Protection (???) - All incorrect syntax Proc Sql;      Create Unique Index MY_INDEX on MY_DATASET (PW=MYPASS COL1,COL2);      Create Unique Index MY_INDEX on MY_DATASET ((PW=MYPASS) COL1,COL2);      Create Unique Index MY_INDEX on MY_DATASET (PW=(MYPASS) COL1,COL2);      Create Unique Index MY_INDEX on MY_DATASET (COL1,COL2) (PW=MYPASS); Quit; Thank you in advance! ... View more

Hi All, Working with a SAS dataset, I carry out a delete using "proc sql delete from where" however, this procedure doesn't appear to update the attribute (obs count) of the dataset. Code below as an example; /****************************************************/ /* Dummy data - 7 Obs /****************************************************/ data work.chgdata;   input account  12. charge;   format account 14. charge  dollar7.;   datalines; 345620135872 10 345620134522 7 345620123456 12 382957492811 3 345620134663 8 345620131455 6 345620104732 9 ; run; /* NOTE: The data set WORK.CHGDATA has 7 observations and 2 variables. */ /****************************************************/ /* Capture dataset attribute (Number of Observations) /****************************************************/ %let dsid=%sysfunc(open(work.chgdata)); %let obs=%sysfunc(attrn(&dsid,nobs)); %put %sysfunc(close(&dsid)); %put &obs; /* SYMBOLGEN:  Macro variable OBS resolves to 7 */ Proc Sql;     Delete from work.chgdata     Where charge in (6,9); Quit; /* NOTE: 2 rows were deleted from WORK.CHGDATA. */ %let dsid=%sysfunc(open(work.chgdata)); %let obs=%sysfunc(attrn(&dsid,nobs)); %put %sysfunc(close(&dsid)); %put &obs; /* SYMBOLGEN:  Macro variable OBS resolves to 7 */ Proc Sql;     Select Count(*) into :trueobs     From work.chgdata; Quit; %put &trueobs;   /* SYMBOLGEN: Macro variable TRUEOBS resolves to 5 */ My question is; a) is this a known bug / fault / outcome? b) is there anyway, using the Proc SQL to force the update of the dataset attributes so that I can use the attrn value of the dataset later on? Thank you. ... View more