hi i have to give flag "Y" if variable var=2 for two or more consecutive days based on vairable date (Y for each record per ID if the condition is met)   example   ID var date flag 001 2 24FEB2021 Y 001 2 25FEB2021 Y 001 2 26FEB2021 y 002 2 24FEB2021   002 1 25FEB2021     thank you for your help ... View more

Hi, i have a dataset;   ID VAR 1 A 1 B 2 B 3 A 3 C 4     and I want to calculate the percentege of distinct value in var a for all  distinct ID's: for example: population is 4 (distinct ID), occurance of var "B" is 2 so the result is 50%   thank you   example output:    so as I wrote earlier the entire population=distinct ID, no matter if there are blanks in var. The output is to show percentage of occurance of var in the entire population, like this:   VAR  Percentage of occurance var/ entire poplulation (distinct ID) A 50% B 50% C 25% ... View more

Hi, I want to create variable flag which will give Y if number from variable A will be in variable B A B Flag 2 1;2;3;4;5 Y   I've tried index, find but nothing works...   thank you in advance ... View more

hi  i have two datasets A and B which could have common variable ID. I want to add a flag "Y" to the dataset A if the same ID existis in dataset B   example   A         B   ID        ID 1          2 2  Y      6       3          4 4  Y     10 ... View more