I want to create a data set with following macro variable.   %let x =credit data;   data &x._&sysdate9.; set t; run; Getting error, can not we remove the space within  a macro variable by using some function? ... View more

I have a data set with age and post.   Age post 12  AB 13 AB 14 PB 14 PB Now using case statement in sql need to add age at post level.  The output should be like this   Age post tot_age 12  AB  25 13 AB 25 14 PB 28 14 PB 28   ... View more

I have this code data t; input cust_id date:date9.  sales; 001 23feb2017 100 001 22jan2016 200 001 23mar2017 300 002 01june2015 200 002 03aug2016 300 002 05april2016 400 ;run; data t1; set t; by cust_id; if first.cust_id=0 then x =lag(date); run; I'm getting a missing vcalue in second observation, where I should get the date of first observation? Except this it's working fine. ... View more

 I want to create a table where I will have new customer.Suppose a customer purchased something in Feb'17 and prior to 12 months i.e from jan'16-feb'15 customer didn't purchase anythning, then it's a new customer for Feb'17. The look back period is for 12 months.   cust_id date sales; 001 23feb2017 100 001 22jan2016 200 001 23mar2017 300 002 01june2015 200 002 03aug2016 300 002 05april2016 400   output should be new_cust date sales; 001 23feb2017 100 002 05april2016 400   How can I do using SAS or SQL ... View more

 data test; input name $ 13. subj gender date date9.; datalines; john   kerry  1123   M   01jan2016 jack  adam   1124       F  02mar2015 ; here the program is not able to read the date,but if I use ":" (date:date9.) then it is able to read perfectly.Can you please explain why is it so? ... View more

I have two datasets "A" and "B". data a; name age frnds; raj 12 a raj 12 b raj 12 c rahul 21 a rahul 21 d rahul 21 e rahul 21 f raj 21 f raj 21 h...... .... ..... ; like this there are many observations in my data set A.And data set B like data B; name age frnds; raj     12       4 rahul 21   3 raj     21    5 ; so from data set "A" I want that much observations as there are numbers in dataset b in "frnds".For ex in data set b for "raj" "12" there are "4" in frnds so I need first 4 observations from data set A .Similarly for rahul need first 3 observations from data set A and 5 observations for "raj" "21" from data set A and so on.   Final op name age frnds raj 12       a raj 12       b raj 12       c raj 12       d   raj 12       e  rahul 21   a rahul 21   f rahul 21   g   and so on....... ... View more

A="FA"; B="1"; AB=AB||B; BA=B||BA; rub; For BA the value is coming as . 1 but for AB it is coming as  .??It should be same for AB as well.   ... View more

why can't input comes before infile ?   data a; infile "path"; input a b ; run;   And how PDV works,like first it read the values from infile and then it assigns the variable in PDV.       ... View more

I want to find the min value. data t; input x; cards; 10 20 40 30 26 ;run;   i found this code data t1; set t end=last; retain y; y=min(y,x); run; And it's giving the right solution.I want to ask that initially the value of y is missing and if we using min(y,x) then it should come as missing value as missing value has the lowest priority, then how come it is coming 10 . Please explain.           ... View more