About mehak

mehak · ‎10-23-2017

yes sir this is what i want . But i want to implement all these things in my original data named as usage data .

mehak · ‎10-23-2017

I AM HAVING 3 FILES . i HAVE ATTACHED THE SAMPLE OF ALL THE FILES. Basically i have to do the following task on this : import usage data and provide labels from chuners and labels file . I am able to import the data but i dnt know how to provide labels from chuners and labels file usage data PRODUCT_ID Year AON CELL_CALL_CNT_M1 CELL_CALL_CNT_M2 CELL_CALL_CNT_M3 CELL_CALL_CNT_M4 102107083 2009 6 0 0 0 0 102107083 2010 14 0 0 0 0 102107083 2011 11 53 47 51 51 102119004 2009 10 0 0 0 0 102119004 2010 13 0 0 6 3 102119004 2011 8 73 113 38 70 102130021 2009 16 193 203 179 177 102130021 2010 21 11 2 77 11 102130021 2011 20 107 109 79 88 102134104 2009 14 0 10 1 0 102134104 2010 19 127 171 123 123 102134104 2011 17 143 354 338 238 102134105 2009 0 6 143 55 369 Churners file PRODUCT_ID churn_month 102220594 201109 102220594 201109 102220594 201109 102240104 201105 102240104 201105 102240104 201105 112110440 201107 112110440 201107 112110440 201107 112113214 201104 112113214 201104 112113214 201104 112116660 201104 112116660 201104 Labels data file Variable Label PRODUCT_ID Line number Year Year AON Age on network CELL_CALL_CNT_M1 count of cell calls-April CELL_CALL_CNT_M2 count of cell calls-May CELL_CALL_CNT_M3 count of cell calls-June CELL_CALL_CNT_M4 count of cell calls-July CELL_CALL_CNT_M5 count of cell calls-August CELL_CALL_CNT_M6 count of cell calls-September

mehak · ‎10-23-2017

basically i want to know how to add labels and churners in proc sql

mehak · ‎10-23-2017

Can anyone tell me how can i write churners and labels in proc sql .????? Basically i have two seperate files . one file named as USAGE DATA and the other one named as Churners and labels . I have imported both the files but dnt know how to write churners and labels in proc sql. *I HAVE IMPORTED BOTH THE FILES LIKE THIS WAY : libname _class_s "/folders/myfolders/1"; PROC IMPORT DATAFILE="/folders/myfolders/1/SB.csv" OUT=_class_s.SB DBMS=CSV REPLACE; RUN; SAMPLE DATA OF BOTH THE FILES ARE AS CHURNERS AND LABELS :- PRODUCT_ID churn_month 102220594 201109 102220594 201109 102220594 201109 102240104 201105 102240104 201105 102240104 201105 112110440 201107 USAGE DATA :- PRODUCT_ID Year AON CELL_CALL_CNT_M1 CELL_CALL_CNT_M2 CELL_CALL_CNT_M3 CELL_CALL_CNT_M4 CELL_CALL_CNT_M5 CELL_CALL_CNT_M6 1.02E+08 2009 6 0 0 0 0 0 0 1.02E+08 2010 14 0 0 0 0 0 0 1.02E+08 2011 11 53 47 51 51 7 7 1.02E+08 2009 10 0 0 0 0 0

mehak · ‎10-22-2017

libname _class_s "/folders/myfolders/ 1"; PROC IMPORT DATAFILE="/folders/myfolders/1/Car_sales.csv" OUT=_class_s.Car_sales DBMS=csv REPLACE; RUN; I have used the above code to import the file and it has import succesfully as i am able to see all the data present in my car file.

mehak · ‎10-21-2017

date1 = '21OCT2017'd ; <- DON'T HARDCODE YOUR DATA *( then what should i write here???????) no_of_months = intck ('MONTH', date1, date2); <- SWITCH THESE TO USE THE VARIABLES IN YOUR DATA SET, NOT HARDCODED (how can i switch these var???????????? )

mehak · ‎10-21-2017

usecoup week seq carry coupval amtspent couponexpiry 3 1 4 0 4 215.28 20/02/2014 3 2 4 4 3 0 21/02/2014 3 1 3 0 3 16.71 24/02/2014 3 2 3 3 1 171.91 25/02/2014 this is my sample data i want to calculate a field for issuance date,as my coupon is valid for 2 months only .

mehak · ‎10-21-2017

Is there anyway by which i can change date 1 automatically and perform intck fn for all the variables which are present in my data set in a row named as couponexpiry data _dlass_1; set _dlass_1.grocery_coupons1; date1 = '21OCT2017'd ; date2 = '31MAR2014'd; no_of_months = intck ('MONTH', date1, date2); no_of_weeks = intck ('WEEK', date1, date2); no_of_days = intck ('DAY', date1, date2); run;

mehak · ‎10-21-2017

sir i want to get all the date after 20 jan . Then what i should do ?

mehak · ‎10-21-2017

i have attached the sample data set . Can you please know tell me how can i seperate out data for passangers vehicles launced after 20 jan .

mehak · ‎10-21-2017

how can i seperate out the data launged after 20 jan 1990 from vechiles

mehak · ‎10-21-2017

already done it sir . 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data _class_1; 63 64 coupon_issuance_date=intnx('02',20,-3,'b'); 65 NOTE: The data set WORK._CLASS_1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 66 proc print data = _class_1 noobs; 67 run; NOTE: There were 1 observations read from the data set WORK._CLASS_1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 68 69 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 82

mehak · ‎10-21-2017

Can anyone please tell me how can i subset the data after a given date . I think i have to use date fn . But dnt know how to keep date in a conditional statement how to find variable informat . ?

mehak · ‎10-21-2017

Can any1 please help me . I have to calculate field of coupon issuance date .expiry date of coupon is 3 months . But in my data sets i am only having expiry date . Is this the correct way to solve such que data _class_1; coupon_issuance_date=intnx('02',20,-3,'b'); proc print data = _class_1 noobs; run;

mehak · ‎10-21-2017

Is this the correct format to write proper variable and value label to the variables ???? in this no error is coming . But i want to check the format . PROC FORMAT lib=_class_s.Grocery_coupons fmtlib; VALUE Health_food_store 0='NO' 1='YES'; VALUE Size_of_store 1='SMALL' 2='MEDIUM' 3='LARGE'; VALUE Store_of_organization 1='EMPHASIZES_PRODUCE' 2='EMPHASIZES_DELI' 3='EMPHASIZES_BAKERY' 4=' NO_EMPHASIS' ; VALUE Gender 0='MALE' 1='FEMALE'; VALUE Who_Shopping_For 1='SELF' 2='SELF_AND_SPOUSE' 3='SELF_AND_FAMILY'; VALUE Vegetarian 0='NO' 1='YES'; VALUE SHOPPING_STYLE 1= 'Biweekly;inbulk' 2= 'Weekly;similar_items' 3= 'often;what_on_sale'; VALUE USE_COUPONS 1='NO' 2='From_newspaper' 3='From_mailing' 4='From_both'; VALUE Carryover 0='Firstperiod' 1='No_coupon' 2='5_percent' 3='15_percent' 4='25_percent'; VALUE Value_of_coupon 1='No_value' 2='5_percent' 3='15_percent' 4='25_percent'; RUN; options fmtsearch =(_class_s.Grocery_coupons); data _class_s; set _class_s.Grocery_coupons; format hlthfood Health_food_store. size Size_of_store. org Store_of_organization. gender Gender. shopfor Who_Shopping_For. veg Vegetarian. style SHOPPING_STYLE. usecoupon USE_COUPONS. carry Carryover. coupval Value_of_coupon.; run; proc print data=_class_s; run;

Online Status	Offline
Date Last Visited	‎10-16-2018 06:56 AM

Re: proc sql

Re: proc sql

Re: proc sql

proc sql

Re: time

Re: intck

Re: intck

intck

Re: time

Re: time

Re: proc sql

Re: proc sql

Re: proc sql

proc sql

Re: time

Re: intck

Re: intck

intck

Re: time

Re: time

Re: time

Re: intnx

time

intnx

Re: labels