Hello.   Imagine this example data set:   Var_Parent     Var_Child ------------------------------- Car                  Ford Car                  Fiat Car                  Chevrolet Animal             Cat Animal             Cow Animal             Pig Country           Portugal Country           UK Country           USA     I want to copy this data set to a new one, to stay like this (literally). As you can see, I want to OUTPUT "Begin of " every time Var_Parent changes.   Var ------------------- Begin of Car Ford Fiat Chevrolet End of Car Begin of Animal Cat Cow Pig End of Animal Begin of Country Portugal UK USA End of Country   Can someone help me, please? Thank you! ... View more

Hello!   Imagine a EM diagram with 6 steps. I executed successfully this diagram from step 1 to step 6.   I needed to make some changes on step 5. I executed again the diagram. I guess it would execute only steps 5 and 6 but it didn't! It started on step 3. I don't know why because there were no changes on the steps 1,2,3,4!   Any suggestions why this happened?   Thank you very much. ... View more

Hello all!   I notice that EMiner projects/diagramns creates folders inside the WORK lib. Examples: _TD21212_SMKTPVSAS01_ _TD10268_SMKTPVSAS01_ SAS_util000100001134_SMKTPVSAS01 (explained here: http://support.sas.com/kb/20/517.html)   With more than one user it's dificult to know wich one belongs to whom.     What means the numbers next to _TD? I know that the last part, SMKTPVSAS01, is the server name. Any suggestions?   Thank you! ... View more

Hello.   A dataset_1 has 100 variables A dataset_2 has 1500 variables   (50 are common to dataset_1).   I want to append the observations of dataset_2 to dataset_1, but choosing only the 50 common variables, without writing 50 KEEP's, one by one.   Is this possible using some kind of KEEP?   DATA dataset_1;      KEEP "50common_variables)      SET dataset_2; RUN;   Thank you! ... View more

Hello. I have a dataset with only one variable and 50 observations. The variable contains names of other I want to use to create a new dataset. Of course, these names change, depending on the steps of the processing. Example of the dataset_1: variable_name -------------------- brand colour year maxspeed The new dataset to create, dynamicaly and empty, must have the following variables: Example of dataset_2: brand colour year maxspeed ------------------------------------------------ This is some kind of transpose. I tried some transposes but it didn't work out. Can someone help? Thanks a lot. ... View more