Otherwise, you can use NODUPKEY to remove duplicates. This is a common gotcha with NODUPRECS. 2 Likes elolvido Fluorite | Level 6 Re: proc sort with nonduprecs does not work with data = ds(keep=) Posted 03-17-2021 03:51 PM (3534 views) | In reply to Ree...
replace(replace($names$, "Mister", "Mr"), "Miss", "Ms") Or if you want to have the number of characters of the strings in a column with nametext: length($text$) Note that strings which are part of the expression and are not from the input data (or the result of another wrapped...
Sort< 1 % Missing Value From Cell Above (P&G)< 1 % 2D/3D Scatterplot< 1 % Dissimilarity Selection (from Matrix)< 1 % SD-to-Smiles< 1 % Canvas Fingerprint Generation< 1 % LigPrep< 1 % Lookup and Add Columns< 1 % Ungroup MAE< 1 % Molecule Writer (from MAE)< 1 % Set MAE Prop...
(a) creating a shadow table, Table Y, that has EP-1 as its EDITPROC and that otherwise duplicates the structures and attributes of Table X; (b) modifying DB2 catalog information about Table X to signify that Table X has EDITPROC EP-1 by updating Table X DB2 catalog EDITPROC informatio...
proc sort data = example out = completed nodupkey; by id status; where status = 'C'; run; proc sort data = example out = aborted ; by id status; where status = 'A'; run; data want; merge completed aborted; by id status; run; View solution in original post 0 Likes 10...
Thus, my file has 20 lines for each animal: 5 trial types * 2 lights (before and after measurements) * 2 (duplicates). The sort procedure was used to sort my data by trial_day as I think the animals may grow habituated to the experiment (one trial_type was run per day) and I do...