About Aman4SAS

Aman4SAS · ‎12-26-2016

i m trying like this but getting error please suggest %macro loop(); Data want; set have; %do i = start_point %to 115; m_%eval(&i.- start_point)=count_&i.; %end; run; %mend; %loop();

Aman4SAS · ‎12-26-2016

no its not about renaming and sorting, suppose start point is 3rd month so month is third but for this custmer its first month so M_0 is 3rd month. like this

Aman4SAS · ‎12-26-2016

I have a data like cust_id start_point count_1 count_2 count_3 count_4 count_5 count_6 count_7 a 3 . . 25 45 55 67 75 b 4 . . . 25 33 63 44 c 2 . 25 33 63 44 74 85 d 1 25 33 63 44 74 85 37 Need a data like cust_id start_point M_0 M_1 M_2 M_3 M_4 M_5 M_6 a 3 25 45 55 67 75 . . b 4 25 33 63 44 . . . c 2 25 33 63 44 74 85 . d 1 25 33 63 44 74 85 37 Please suggest

Aman4SAS · ‎12-26-2016

Dear All I need to map 2 data set ; example is below; data A var1 a b c d data B 1 2 3 4 5 6 Need result like Data Result a1 a2 a3 a4 a5 b1 b2 b3 b4 b5 c1 c2 c3 c4 c5 d1 d2 d3 d4 d5 can not use macro variable list becaz there is lots of obs in data a and b(out of limit t macro variable) please suggest Thanks in advance

Aman4SAS · ‎11-01-2016

0 as missing value and 1 can be anything.. just to simplify i used 0 and 1,

Aman4SAS · ‎11-01-2016

I am not able to imageing anything on it or i can try array and "if " conditions but its not seems good. Can u please suggest if any thing in sort available. Thanks in advance

Aman4SAS · ‎11-01-2016

Hi All, i have data like below: data test; input a b c; datalines; 1 0 0 0 1 0 0 1 1 1 1 1 ; run; i need output with same data added one more variable result as a b c Result 1 0 0 A1 0 1 0 B2 0 1 1 B3 1 1 1 A4 please suggest to get the result

Aman4SAS · ‎10-25-2016

i have code : data test; input name $ age; datalines; a 1 a 2 a 3 A 1 a 4 A 3 A 2 ; run; proc sort data=test nodupkey ; by name; run; proc print; run; output is : A 1 a 1 desire output is : a 1 (only) is there any possibility to ignore case and select only first unique record.(without any kind of manipulation in data and using only proc sort) Thanks in advance

Aman4SAS · ‎10-22-2016

Thanks a lot. It works. Connecting with you always return me learn something new. Its Great . Thanks once again.

Aman4SAS · ‎10-22-2016

Thanks for all reply. As suggested by RW , i tried to delete this post but i was not able to delete. I required only in SQL bcaz i know all other option to get result i.e. data step, merge but i have been asked to do it in SQL and my answer was same as RW Sir, and result, i am failed. so to be confirmed i have asked this to you legend people. Thanks Xia Keshan for your attention on my question. Please suggest me how can i delete this post or do i need to keep it as it is.

Aman4SAS · ‎10-21-2016

Hi All, I need to find latest 2 observation/transaction from each group using only PROC SQL. I have tried to make my code, Kindly suggest if any improvization available: Problem in my code is if i require latest 3 obs then i will need increase steps to get result. Code below: proc sql; create table new1 as select distinct * from test group by product having transaction_date =max(transaction_date) union select distinct * from (select * from test except (select distinct * from test group by product having transaction_date =max(transaction_date))) group by product having transaction_date =max(transaction_date) ; quit; : Xia Keshan need help.

Aman4SAS · ‎08-08-2016

sir i have already run these code, but in output want , i m getting only result for Q23. please check the output.

Aman4SAS · ‎08-08-2016

Hi All, I need frequency matrix of my data. my data is having 3 question Q1 -- Q23 and and one variable is cluster value of cluster is 1 to 3 and values of Q1--Q23 are 1 to 5 i am using code below: proc freq data=out_3 ; table (Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 Q23)*cluster /nocol norow nocum nopercent; run; OUTPUT: Q23 CLUSTER COUNT PERCENT 1 1 68 0.3046322014 1 2 698 3.1269599498 1 3 3310 14.828420392 2 1 213 0.9542155721 2 2 2114 9.4704775558 2 3 3598 16.118627363 3 1 1323 5.9268882717 3 2 4657 20.862825912 3 3 1015 4.5470835947 4 1 3314 14.846339934 4 2 1385 6.2046411612 4 3 42 0.1881551832 5 1 472 2.1145058686 5 2 103 0.4614281874 5 3 10 0.0447988531 Now problem is , i am getting output only for Q23 , but i am looking result for all Q1--23 . Is it possible to get that. Thanks in advance

Aman4SAS · ‎04-19-2016

In your output{snapshot provided by you in ur answer} , visible that center value for over_all is missing. I am looking for that value. what would be that value if i want to know that. Thanks in advance.

Aman4SAS · ‎04-19-2016

Hi, Thanks for reply. But its centroid for variables, i am not able to find out over_all centroid,, does final seeds also called as over_all centroid?? Thanks in Advance

Online Status	Offline
Date Last Visited	‎05-25-2021 03:59 PM

Re: Data step with Lag function

Re: Data step with Lag function

Data step with Lag function

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

If condition with macro variables

Re: Data step with Lag function

Re: Data step with Lag function

Re: Need Data Step Solution

Re: How to read Raw data with embedded blank without increasing the sp...

Re: %let = if statement, or case?... confused...

Re: How to read Raw data with embedded blank without increasing the sp...

Re: Transforation of Data

Re: Transforation of Data

Transforation of Data

Need to map 2 datasets

Re: finding first non missing variable

Re: finding first non missing variable

finding first non missing variable

How to ignore case while using nodupkey in proc sort?

Re: latest 2 observation from each group using only PROC SQL

Re: latest 2 observation from each group using only PROC SQL

latest 2 observation from each group using only PROC SQL

Re: Need frequency matrix using proc freq

Need frequency matrix using proc freq

Re: How to get centroid value in proc fastclus

Re: How to get centroid value in proc fastclus