Hi! given these data:   data have; infile datalines delimiter=','; input id1 $ id2 $; datalines; M,A A,B C,D B,C V,W W,X X,Y Y,Z ;   I am hoping to create a grouper ID that will associate M to A, A to B, B to C, and C to D. Same thing with V to W, W to X, X to Y and Y to Z. Please see below for the data I want:   data want; infile datalines delimiter=','; input id1 $ id2 $ grouper; datalines; M,A,1 A,B,1 B,C,1 C,D,1 V,W,2 W,X,2 X,Y,2 Y,Z,2 ;   So, in the output, there are 2 groups that are established. Is this possible using SAS 9.4? Please note that I cannot guarantee sort order so ideally the solution does not use first/last/lag commands.   TIA! ... View more

Hi,   I am using the "SAS Certification Prep Guide: Base Programming for SAS 9" to study for my base programming exam. I am using SAS Studio. I am having difficulty setting up the practice data relied on in the certification book. Specifically, SAS Studio is unable to locate the folder on my local Mac OSX machine. When I run the program that's supposed to set up all the practice data after adjusting to the correct folder location, I get the following error:   WARNING: Physical file does not exist, /Users/MYCOMPUTER/Downloads/base-guide-practice-data/cert/cre8permdata.sas. ERROR: Cannot open %INCLUDE file /Users/MYCOMPUTER/Downloads/base-guide-practice-data/cert/cre8permdata.sas.   Here is the code that was submitted and downloaded from SAS:   %let path=/Users/MYCOMPUTER/Downloads/base-guide-practice-data/cert; /******************************************************************** Do not modify the code below this line ********************************************************************/ %macro setdelim; %global delim; %if %index(&path,%str(/)) %then %let delim=%str(/); %else %let delim=%str(\); %mend; %setdelim %macro makedata; %include "&path&delim.cre8permdata.sas"; %include "&path&delim.cre8workdata.sas"; %include "&path&delim.cre8flatfiles.sas"; %put; %put NOTE- *******************************************************; %put NOTE- Your SAS Certification Prep Guide data files are ready.; %put NOTE- *******************************************************; %mend; %makedata; Hope this makes sense, TIA!! ... View more