Interview Question to my friend.
x=A,B,C,D,E,F,G ;
He wants to find 4th comma or 5th comma.
I have given this answer.
data a; x='A,B,C,D,E,F'; run; %let p=9; data find_comma; set a; fouth_comma=find(x,',',&p); run;
Is it correct? or wrong?
Interview asked me to write dynamically.
Please correct if I'm wrong.
They want dynamically?
... View more
Data have;
input id;
cards;
1
1
1
2
2
44
44
44
44
; run;
duplicate records in output dataset by using only proc sql?
like below
data want
id
1
1
2
44
44
44
can i get code for this ? thanks in advance.
... View more
Data have;
input id;
cards;
1
1
1
2
2
44
44
44
44
; run;
duplicate records in output dataset by using only proc sql?
like below
data want
id
1
1
2
44
44
44
can i get code for this ? thanks in advance.
... View more
Data have;
input id;
cards;
-1
-2
-3
10
20
30
;
run;
sum of nagative values in positive varible
sum of positive values in negative variable
like below
positive negative
60 -6
... View more
Cid date
101 01jan2019
102 02jan2019
103 02jan2019
104 01feb2019
105 02feb2019
101 05feb2019
106 07feb2019
108 01mar2019
104 05mar2019
107 01apr2019
109 02may2019
106 03may2019
102 04may2019
109 05jun2019
.
.
.
the above data we have
i want customer who visited twice in any consecutive 3months.It means customer who visited 2times in (jan feb mar) .means in three months customer need to visit atleast 2times.
for the above who visited twice in three months is
cid
101
104
109
but in data we have many observations....
for example i have given few records to underdstand senario..
... View more
Here is the clear explanation...
I'm having data like this
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
FOR EVERY 3 CONSECUTIVE MONTH THE CUSTOMER WHO VISITED TWICE in ANY THREE MONTHS i.e
JAN FEB MAR------------->> In this three consecutive months customer who has visited twice in any months(means jan feb or feb mar or jan mar)
or
FEB MAR APR------------->> " " " " " (means feb mar or mar apr or feb apr)
....
....
like that we will get so on..upto oct nov dec.
Here i want to retrieve the records who visited twice in any 3 consecutive months;
... View more
DATA A; INPUT LIBREF$ PATH$; CARDS; MYLIB C:\SAS\SAI MYSAS D:\SAS\RAJA MYXYZ E:\SAS\RANI ; RUN; HERE LIBRARY HAS TO CREATE AS MYLIB IN GIVEN PATH C:\SAS\SAI LIKE THAT ONE MORE LIBRARY HAS TO CREATE AS MYSAS IN GIVEN PATH D:\SAS\RAJA...... CAN I GET CODE FOR THIS THANK YOU...
... View more
