Hi,   I would like to apply two types of floors, respectively for lower and upper segments of a dataset.   Assume the dataset has two columns: Col1 which is unique and asc sorted; Col2 is the actual data  the floor applies to 1) Floor 1 on the lower band of Col1 : for any values in Col1  less than3, which is set to by the user - replace their values in Col2 with the Col2 value of Col1 =3 2)Floor 2 on the upper band of Col1: for any values in Col1  greater than 4, which is set to by the user - replace their values in Col2 with the Col2 value of previous Col1 to ensure they are not decreasing when Col1 values increase   Below is an example of the dataset I have and what I want.   Many thanks in advance.     data have; input Col1 Col2; datalines; 1 1 2 2 3 3 4 4 5 3 6 6 7 1 8 3 ;   data want; Col1 Col2 1 3 2 3 3 3 4 4 5 4 6 6 7 6 8 6 ; ... View more

Esteemed Advisors:   I am trying to interleave two datasets with a condition that the resulting dataset contains only observations that can be found in both of the two datasets.     Below is exemplar code to illustrate the problem.  If you run this code and inspect dataset interleave2 you will see that for a group of  3 observations where target=1, two came from Random_A and one came from Random_B.  Likewise, for a group of three observations where target=2, two came from Random_B and one came from Random_A.  All of these observations need to be retained in the desired dataset.   For the group of 3 observations where target=3, all observations came from Random_B only.  These are ones that need to be omitted.  All observations for a given target that come from a single source dataset are not to be retained in the desired dataset.   The challenge for me (and now for you) is to come up with the code that will interleave Random_A and Random_B such that the resultant dataset that only contains the groups of targets that are present in both datasets.   Hope this makes sense and thanks for taking a look,   Gene   data Random_A (drop=i); call streaminit(4786); do i=1 to 100; Source="A"; Target=rand("Integer",1,100); ST=catx('/',Source,Target); output; end; data Random_B (drop=i); call streaminit(6874); do i=1 to 150; Source="B"; Target=rand("Integer",1,100); ST=catx('/',Source,Target); output; end; Proc sort data=Random_A; by ST; run; Proc sort data=Random_B; by ST; run; data interleave1; set random_A random_B; by ST; run; proc sort data=interleave1 out=interleave2 nounikey; by target; run; ... View more

Hi there,   Hello, I'm new here and would like to apologise if my question seems a little illogical. I am looking for a tool for our company in the area of factory planning, with which unstructured Excel data must be converted into a structured, predefined form. I am analysing whether the raw data (machine, process and product information) of our customers can be converted into a structured format by an AI. This is necessary in order to be able to read in the data with the in-house software (VBA code is currently still being written for this). The target formatting is therefore known (import excel). However, the raw Excel data is different in every new project. The reorganisation affects, among other things, the arrangement of rows and columns, but also the generation of formulas.   Is there a way to solve this problem with SAS?   Many thanky in advance. Best regards     ... View more

Hello, I know that i can use INTCK on studio but i want to know if i can find a formula in visual Analytics to measure the delay between 2 dates and exclude the week end or blank days. ... View more