02-20-2020
Geo-
Quartz | Level 8
Member since
12-27-2017
- 102 Posts
- 17 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by Geo-
Subject Views Posted 831 12-13-2018 08:09 PM 837 12-13-2018 07:55 PM 3176 11-19-2018 06:24 PM 3195 11-19-2018 09:23 AM 1293 11-18-2018 07:26 PM 7923 11-18-2018 06:53 PM 1363 11-18-2018 08:53 AM 7970 11-18-2018 08:05 AM 3324 11-17-2018 03:07 AM 3343 11-17-2018 01:23 AM -
Activity Feed for Geo-
- Got a Like for extract date from datetime with datepart. 02-28-2024 06:02 AM
- Posted Re: how to select values according to their language? on SAS Programming. 12-13-2018 08:09 PM
- Posted how to select values according to their language? on SAS Programming. 12-13-2018 07:55 PM
- Posted Re: proc sql into data step on SAS Programming. 11-19-2018 06:24 PM
- Posted Re: proc sql into data step on SAS Programming. 11-19-2018 09:23 AM
- Posted Re: SAS Customer Intelligence 360: Model management for competitive differentiation on SAS Programming. 11-18-2018 07:26 PM
- Posted Re: char date yyyymmdd hh:mm:ss into date format on SAS Programming. 11-18-2018 06:53 PM
- Posted Compute time intervals for each customer ID on SAS Programming. 11-18-2018 08:53 AM
- Posted char date yyyymmdd hh:mm:ss into date format on SAS Programming. 11-18-2018 08:05 AM
- Posted Re: proc sql into data step on SAS Programming. 11-17-2018 03:07 AM
- Posted proc sql into data step on SAS Programming. 11-17-2018 01:23 AM
- Posted Re: date format on SAS Programming. 11-17-2018 12:28 AM
- Liked Re: date format for novinosrin. 11-16-2018 11:44 PM
- Posted date format on SAS Programming. 11-16-2018 10:07 PM
- Posted Re: question with PCTLPTS on SAS Programming. 11-15-2018 02:06 AM
- Posted question with PCTLPTS on SAS Programming. 11-15-2018 01:09 AM
- Liked Re: ERROR 79-322:Expecting a ( for Astounding. 11-13-2018 06:37 PM
- Liked Re: ERROR 79-322:Expecting a ( for Peter_C. 11-13-2018 06:37 PM
- Liked Re: ERROR 79-322:Expecting a ( for PaigeMiller. 11-13-2018 09:36 AM
- Liked Re: ERROR 79-322:Expecting a ( for RW9. 11-13-2018 09:36 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 08-29-2018 05:08 AM
11-13-2018
08:09 AM
I can not get what exactly "(" should be placed in the codes How to solve this? data trans_summary(drop=txn_amt_rmb);
set trans_list;
by party_id plus_minus_flag;
retain sum_rmb;
if first.plus_minus_flag then sum_rmb=0;
sum_rmb=(sum_rmb,txn_amt_rmb);
if last.plus_minus_flag then output;
run;
... View more
11-02-2018
11:45 PM
How to understand weight variable here?what is it for?redm_flag=0 means negative samples. proc surveyselect data=lg.develop_original(where=( redm_flag =0)) noprint
method=srs rate=0.1 out=lg.develop_sury ;
run;
data lg.develop_final;
set lg.develop_ original(where=( redm_flag =1)) lg.develop_sury;
if redm_flag=1 then weight=1;
else weight=10;
run;
proc freq data= lg.develop_final;
weight weight;
table redm_flag/missing;
run;
... View more
10-31-2018
05:35 AM
data _null_;
set TABLE(keep=company);
by company;
if first.company then call execute ('ods excel file="c:\temp.xlsx" sheet_name="sales report" '
|| 'proc print data=TABLE noobs; where company='||quote(company)||';run;'
|| 'ods excel close ');
run; Hi expert ,would you please check where is wrong with the code
... View more
10-31-2018
02:44 AM
macro is needed..if column B have hundreds of values,this way could not work
... View more
10-29-2018
10:37 PM
Hi, I have a table like: a b c a101 b1 c1 a102 b2 c2 a103 b3 c3 and will create 3 excel files like: table1_b2 a b c a102 b2 c2 table_b1 a b c a101 b1 c1 table_b3 a b c a103 b3 c3 how to use macro to create and export tables according to distinct value of column b and create table_&bi,thanks!
... View more
10-29-2018
06:13 AM
sir,I am not good at English..Would you mind check if the updated message fit you?thanks
... View more
10-29-2018
03:31 AM
Hi all,I am using SAS EG client to connect hive,what key words all other ways that can let the hive running sql with distributed key of the tables? Like we always distribute tables by date and we could fully use the resource of the machine
... View more
10-27-2018
09:53 PM
I am looking for base SAS for the full development of scorecard .Maybe your answer is fit for graphic topic?thank you for your time!
... View more
10-27-2018
05:48 AM
I have searched many sites about SAS scorecard development,and almost all of them focus and talk about the process or the theory.Here is a full process”https://www.worldprogramming.com/us/blog/credit_scoring_pt3 which is a very full case.however there is no sight of any codes.please kindly give me some advices for a full detailed code on webs or books.
... View more
10-23-2018
10:08 PM
I have a table in SAS work.mytable,how to create it into hadoop.this way will not work: proc sql;
connect to hadoop(
server=xxx
user=sas
password=xxx
schema=xxx
subprotocol=hive2
hdfs_tempdir='/tmp/sastemp/'
properties=xxx
);
select * from connection to hadoop(
create table sas_card_tmp.test01 as
)
select * from work.mytable;
disconnect from hadoop;
quit;
... View more
09-24-2018
03:14 AM
thank you for your attention.I could not change thes sas code,I am looking for what the lines with number doing.Did I interpret them right?
... View more
09-23-2018
10:39 PM
Hi,someone know summary statement please help me with the explanation of line with number below. I have written the annotation as I understood my way,however they are not the situation when I check it back in the excel file. Thanks in advance! data ccm_base_trans_3m;
retain txn_amt_rmb_08 txn_amt_rmb_09 0;
set ccm_base_trans(drop=event_id org where=("1jul2014"d le eff_date le "30sep2014"d));
if "1aug2014"d le eff_date le "31aug2014"d then do;
txn_amt_rmb_08=txn_amt_rmb;
end;
if "1sep2014"d le eff_date le "30sep2014"d then do;
txn_amt_rmb_09=txn_amt_rmb;
txn_date=datepart(eff_date);
end;
length mcc_desc $200.;
mcc_desc=put(mcc,$mcc.);
run;
proc summary data=ccm_base_trans_3m(keep=becif_custid txn_amt_rmb txn_amt_rmb_08 txn_amt_rmb_09 eff_date) nway missing;
/*each becif_custid*/
class becif_custid;
var txn_amt_rmb txn_amt_rmb_08 txn_amt_rmb_09 eff_date;
output out=ccm_base_trans_3m(rename=(_freq_=p3m_sum_cnt) drop=_type_)
/*1.count of txn_amt_rmb for each becif_custid*/
sum(txn_amt_rmb) =p3m_sum_cnt
/*2.sum of txn_amt_rmb_08 for each becif_custid*/
sum(txn_amt_rmb_08)=txn_amt_rmb_08
/*3.sum of txn_amt_rmb_09 for each becif_custid*/
sum(txn_amt_rmb_09)=txn_amt_rmb_09
/*4.last date of eff_date for each becif_custid*/
max(eff_date)=last_txn_date;
run;
... View more
09-17-2018
11:44 PM
Anyone has SAS macro to create tables according to a column values? Column id has 3 values (a,b,c),and create thress tables by this column. original: id spend lend a 10.1 0.5 a 5.5 7 b 1.2 2 c 3 6 b 6 3.1 id_a: id spend lend a 10.1 0.5 a 5.5 7 id_b: id spend lend b 1.2 2 b 6 3.1 id_c: id spend lend c 3 6
... View more
09-16-2018
12:15 AM
SAS sql into sas data step proc sql noprint;
create table tableC as
slect A.a,A.b,A.c,B.d,B.e
from tableA A
inner join tableB B
on A.b=B.b;
delete from tableC
where not (substr(d,1,1)='1' and length(trim(d))=11)
or d is null;
delete from tableC
where d in
(select d from tableC group by d having count(1)>1);
quit; thank you for your time!
... View more
09-15-2018
09:31 PM
Could someone familiar with sas change sql into data step.thank you for your attention proc sql noprint;
create table temp as
select A.a,A.b,A.c,A.d,
put(datepart(A.e),YYMMDDN8.) as e,
case when A.f is null then calculated e
else A.f end as f,
put(datepart(A.g),YYMMDDN8.) as g,
put(datepart(A.h),YYMMDDN8.) as h,
B.city,
B.channel
from tableA(where=("20150501" le batch_date le "20150519")) A
left join (select distinct a,f,city,channel from tableB) B
on A.a=B.a
order by 1;
quit;
... View more