Hi,
i am using SAS Desktop version, i can only connect to database using wizard every time. Can some one suggest me how can i save the database table pulled from wizard saved into SAS Dataset.
I need this urgently please can someone help me on this.
Thanks,
Vamsi
... View more
Hi Guys,
i am not able to import xlsx, xls file types from my server or local folders can someone suggest the reason for the error.
ERROR: DBMS type EXCEL not valid for export.
Do we need any licence to import external files of xls and xlsx.
Thanks in advance.
... View more
My data looks like this
Policy Number
Policy Start date
Policy End date
Policy Term
Age
101
10-Aug-15
8-Aug-18
3
58
102
25-Feb-16
23-Feb-18
2
55
i need the output in the below format. i wanted to break policy start date and Policy end date into years by adding 364 days
Policy Start date
Policy End date
Policy End date
Start Date
End date
Policy Term
Age
Policy Year
101
10-Aug-15
8-Aug-18
10-Aug-15
8-Aug-16
3
58
1
101
10-Aug-15
8-Aug-18
9-Aug-16
8-Aug-17
3
59
2
101
10-Aug-15
8-Aug-18
9-Aug-17
8-Aug-18
3
60
3
102
25-Feb-16
23-Feb-18
25-Feb-16
23-Feb-17
2
55
1
102
25-Feb-16
23-Feb-18
24-Feb-17
23-Feb-18
2
56
2
Please let me know if you any query. Can someone help me on this for me.
... View more
Hi , Please can someone help me with an example for Left , inner , full join in Hash Coding I have very large datasets nearly 1 crore so need help . Reagrds, Satya.
... View more
Please help with the code for hash join , for the below code in PROC SQL
Proc sql;
Create table test as
Select *
From dsn1 a inner join dsn2 b
On a.key1=b.key2 or a.key1a=b.key2;
Quit;
... View more
Please can some one explain me how to perform the SCD type 2 Transformation in Data Integration SAS. Please kindly help i am looking for this from last few months.
... View more