↳
Using join you can split lines (duplicate). For example, you have AETERM in Adverse Event, where AETERM = "headtoothache". It's 2 independent DECOD, and if you need to control it by MedDRA dictionary you need to split lines where AETERM in both lines equal to 'headtoothache' but AEDECOD in the first line equal to 'HEADACHE' and 'TOOTHACHE' in the second line. Menos
↳
Merge:Merge is combining process which combine column wise i.e vertically, add different kind of variable names and datatypes, and Join: join is adding process which add rows wise i.e horizontal, add only same kind of variable names and datatypes. Menos
↳
said merge requires sorting of data and join doesnt .
↳
Was confused couldn't answer
↳
data type - Character & numeric type of data
↳
type of data - temporary & permanent
↳
Using arithmetic operations
↳
I have seen/heard the same feedback from too many people. Please Ameriprise do share the feedback with candidates as they also invest their time and you never know for some people this job can matter a lot. Menos
↳
Typical. The owner has no respect for anyone.
↳
Yes, I agree, the owner is a total jerk.
↳
Description: Building Standardized Reporting modules created from InfoMart data, provide management repost and dashboards to help Individual Business leading better manage the business. In BI Solution we analysis data as per business requirements which helps business to make key decisions. Menos
↳
Description: Building Standardized Reporting modules created from InfoMart data, provide management repost and dashboards to help Individual Business leading better manage the business. In BI Solution we analysis data as per business requirements which helps business to make key decisions. Menos
↳
*to add 2 missing values so that the result is zero can be achieved by using sum function with zero as extra argument. eg: data x; a = .; b = .; c = a + b + 0; /* even if you add zero, result is missing*/ d = sum(a,b,0); run; Menos
↳
-2+2
↳
Data Purchase_data; infile cards; input customer_id purchase_dates ddmmyy10. amount_paid; Format purchase_dates date9.; cards; 101 01/02/2014 300 101 02/02/2014 500 101 03/02/2014 400 101 04/02/2014 600 102 01/02/2014 300 102 02/02/2014 500 102 03/02/2014 400 103 01/02/2014 400 103 02/02/2014 900 103 03/02/2014 500 103 04/02/2014 700 103 05/02/2014 300 ; run; proc sort data=Purchase_data; by customer_id descending purchase_dates; run; Data Last_Purchase; set Purchase_data; by customer_id; if first.customer_id=1 then count=1; else count+1; if count in(1,2); drop count; run; Menos
↳
main difference between data Merge and Proc sql in data merge you have to sort the data before joining but in Proc sql without sorting data you can join the tables. Menos
↳
ya in sql defualt merg ,print
↳
different ways of creating macro: %let statement call symput('macro_var_name',value) proc sql into: macro(par1=, par2=) -- while creating macro. Data types in sas: ch and numeric ar Menos
↳
%let statement %local %global Call execute('%let m=',|| variable ||); call symput('macro_var_name',value) proc sql into: macro(par1=, par2=) -- while creating macro. Menos