Hi
I have taken year cutoff=1800
and used for one dataset .
now i want to remove the options how can i do it to remove the options.
(or)
Remove the old options
i have tryed options;
options=' ';
... View more
data l;
input id;
cards;
45
63
1023
run;
Now i want to retain the last obs to new variable;
output:
id new_id
45 1023
63 1023
1023 1023
Here 1023 is the last obs it shold move to new variable new_id
... View more
data l;
input name $ classes $40.;
classes=compress(classes,'"');
c1=scan(classes,1);
c2=scan(classes,2);
c3=scan(classes,3);
cards;
ram "history,math geography"
hari "physics,, math chemistry"
run;
... View more
Hi
Iam having acc_no with same number now i want a new variable as seq_no it should be same for all the accouns that are same:
data new;
input acc_no amt;
cards;
1012 23
1013 45
1012 56
1012 56
1013 80
1023 42
run;
output:
acc_no amt seq_no
1012 23 1
1013 45 2
1012 56 1
1012 56 1
1013 80 2
1023 42 3
For this the acc no 1012 is having 1 as seq_no ,and 1013 has 2 as seq_no like that.
... View more
HI
I AM HAVING DATASET BY NAME INTIAL IT IS HAVING 10 OBS AND IT WAS SPLITTED IN TO TWO
DATASETS S1,S2 WITH 5 OBS EACH AND AFTER THAT I HAVE MADE SOME AGGREATIONS AND CREATED T1
AND T2 DATASET HAVING 5 OBS EACH NOW I WNAT THE COUNT OF EACH DATASETS AND COUNT OF S1 AND
S2 IN TO ONE VARIABLE AND EACH DATASET COUNT OF OBSE IN TO ANOTHER VARIABLE AND TARGET
VARIABLES COUNT AND INDIVIDUAL COUNT IN TO ANOTHER VARIABLE .IF I AM NOT CLEAR I HAVE GIVEN
THE EXAMPLE BELOW ,PLEASE HELP ME OUT.
OUTPUT:
INI_DSETNAME INTIAL_COUNT_OBS S_DS_NAME S1&S2COUNT S1&S2SUM T_DSNAME T1&T2COUNT T1&T2SUM
FINAL 10 S1 5 10 T1 5 10
FINAL 10 S2 5 10 T2 5 10
... View more
Hi i will get dataset i dont know the number of observastions are there i want to divide it in to 5 dataset
and name them as d1 to d5 dynamically how can i do by loop and each dataset obs should not go to another dataset based on id variable
ex:
data test;
input id;
cards;
1
1
2
2
2
3
3
4
5
6
6
7
7
8
run;
output
d1
1
1
1
d2
2
2
3
3
d3
4
5
d4
6
6
d5
7
7
8
As the dataset should divide in to 5 datasets and the id variable obs should be only in one dataset only for ex:d3 is having obs '4' the obs of that dataset should be only in d3 it sholuld not be in another dataset .The test dataset should divide in to 5 not exactly all the five dataset should be having the same no of obs it can vary can any one help me in this.
... View more
HI i want to add '0' before the id variable by using do until can any one help me.
data a;
input id $;
len=length(id);
do until (len=5);
a='0';
id=a||id;
end;
stop;
output;
cards;
1
01
001
run;
output
00001
00001
00001
... View more
Hi i want to read these observations in the same variable dt as they are in ddmmyy10. and date11. and if date is like 0970 and 0001 it should be in to 1900
data l3;
input dt ;
cards;
01/03/0970
01/01/0001
01/01/2003
12-sep-2011
run;
output:
01/03/1900
01/01/1901
01/01/2003
12/09/2011
... View more
Hi i ma having a variable id if it is continously geeting 1 ,2,3 then flag should create as 1 based on accno
dataset
data n;
input aaccno id;
cards;
23 0
23 1
23 2
23 3
23 0
24 1
24 4
24 2
24 3
26 1
26 2
26 3
run;
output:
data n;
input id flag;
cards;
0 0
1 1
2 1
3 1
0 0
1 0
4 0
2 0
3 0
1 1
2 1
3 1
run;
... View more
HI i am having differnt months and year if the reporting month is mar10 then i should create new variable called mar_diff and it should minus from the last two months jan10-feb10 and if reporting month is jan10 it should minus from nov-09-dec-09 and i should create new variable jan10_diff like that
data temp;
input oct09 nov09 dec09 jan10 feb10 mar10;
cards;
10 11 12 13 14 15 16
run;
... View more
proc sort data=a;
by analyst company quarter;
run;
data a2;
set a;
if first.company then a=1;
if first.quarter then b=1;
if first.analyst then c=1;
by analyst company quarter;
if a=1 and b=1 then output;
run;
... View more
Hi i am having a date i should minus it from the todays date(sysdate)
Data a;
input date ddmmyy10.;
cards;
05/02/2011
run;
for examples sysdate is 10/02/2011 then out put sholud be date=5 it should be automatic as the systemdate but not with today function
... View more
