About sam369

sam369 · ‎08-13-2013

Hi Experts, I have a question on proc tabulate.the data look like data test; do grp=1 to 6; do flg='Yes','No'; do sec='dsfsa', 'fdafa', 'afafa'; output; end; end; end; run; proc tabulate data=test; class grp flg sec; table grp *FLG ,sec='section' * (n='n' * f=10. COLPCTN='%' * f=7.2 )/ misstext='0' rts=40; run; my o/p: ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ† ‚ ‚ section ‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‰ ‚ ‚ afafa ‚ dsfsa ‚ fdafa ‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒ‰ ‚ ‚ n ‚ % ‚ n ‚ % ‚ n ‚ % ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚grp ‚flg ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‰ ‚ ‚ ‚ ‚ ‚ ‚ ‚1 ‚No ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚2 ‚No ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚3 ‚No ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚4 ‚No ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 8.33‚ 1‚ 8.33‚ 1‚ 8.33‚ Šƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒŒ but my desired o/p is „ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ† ‚ ‚ section ‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‰ ‚ ‚ afafa ‚ dsfsa ‚ fdafa ‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒ‰ ‚ ‚ n ‚ % ‚ n ‚ % ‚ n ‚ % ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ…ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚grp ‚flg ‚ ‚ ‚ ‚ ‚ ‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‰ ‚ ‚ ‚ ‚ ‚ ‚ ‚1 ‚No ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚2 ‚No ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚3 ‚No ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚4 ‚No ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ ‚ ‡ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒ‰ ‚ ‚Yes ‚ 1‚ 50.00‚ 1‚ 50.00‚ 1‚ 50.00‚ Šƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒƒƒƒ‹ƒƒƒƒƒƒƒŒ can i produce this kid of output by using proc report? Thanks Sam

sam369 · ‎07-26-2013

Hi Vincent, Thank you so much for this Breif explanation. Now i learned one new way to look the data & how to interpret. I am bit familiar with SQL. I want to know x>y then i/x<1/y part....you explanation cleared my doubts.... Regards Sam

sam369 · ‎07-25-2013

Hi Vince, Perfect answer , that is what i am looking for , could you explain case section? Thank you LinLin,Anca tilea Thanks Sam

sam369 · ‎07-25-2013

Hi Experts, I have a dataset like below data have; input ord desc $; cards; 0 dfkasdf 1 qewrqwe 2 werewrqe 3 etritreter 4 cvczcvzcve 5 werewrqwer 6 rqwerqwerq 7 vczcvzvzcved 8 wereruipeewr 9 dhfewrwerq 10 wrwerwerq 11 ewryteiqwe 12 rewrbnmnbz 13 wecvxcvjzc 14 ewrwerqwe 15 itititoeoe ; run; I need to create a varaible call grp like below select(ord); when(0,12,8,4) grp=1; when(1,13,9,5) grp=2; when(2,14,10,6) grp=3; when(3,15,11,7) grp=4; otherwise; end; i want the dataset in same soring order like grp 1 0 12 8 4 2 1 13 9 5 3 2 14 10 6 4 3 15 11 7 any suggestion On Array, SQL Thanks Sam

sam369 · ‎07-21-2013

Hi, some one will come with better solution, the sample code will give what you want proc sql; create table want as select a.*,b.* from test1 as a inner join test2 as b on a.key1=substr(key2,1,3) order by a.key1,b.key2; quit; Thanks Sam

sam369 · ‎07-12-2013

Hi Pawan, some one may come with better solution.. Here is the sample Code /*First sql creating data set name in to macro from work library, if you have in diffrent location change the LIBname*/ proc sql; select memname into : Ds separated by ' ' from dictionary.columns where libname='WORK'; quit; %put &Ds; %let sqlobs=&sqlobs; %macro export; %do i=1 %to &sqlobs; %let dsn=%scan(&DS,&i); proc export data=&dsn outfile="\excelpath\sample.xls" dbms=excel replace; sheet="&dsn"; run; %end; %mend; %export Thanks Sam

sam369 · ‎07-12-2013

Hi desireatem, You can try this to get last record data KSm_&p(rename=survival1=(survival_max time=time_max)); set Kaplan_&p nobs=nobs; if _n_ =nobs then keep=1; if keep ne 1 then delete; drop keep survival; run; Thanks Sam

sam369 · ‎07-11-2013

Hi Chucs, May be some one come up with better answer. here is the sample code where you can get the desired o/p proc sql; create table want as select a.*,b.baseday,(dxday-baseday) as diff from have as a left join(select id,dxday as baseday from have(where=(caetype eq 'INFL')) group by id having dxday=min(dxday)) as b on a.id=b.id order by a.id,a.dxday; quit; Thanks Sam

sam369 · ‎04-24-2013

Thank you Reeza and Ksharp!!!!! Thanks for the details.... Ksharp it really Good to see you back!!!!! Sam

sam369 · ‎04-24-2013

Hi Experts, i got an issue while iam using scan function. i want to seperate the string with delimeter. example is below: %let varlist=ficc <100 ficc 100-400 ficc >400; %macro test; %do i=1 to 3; %let test=%sysfunc(scan(&varlist,&i,' ')); %put &test=; %end; %mend; %test; got an errors saying scan have too many arguments ,some time uninitilized want: test=ficc <100 test=ficc 100-400 test=ficc >400 Thanks Sam

sam369 · ‎04-16-2013

Hi EinarRoed, Some one might come with slick answer !!! here is one apporach data have; input DEAL_NO POL_NO LAPSE_DT $; cards; 1 172 AUG13 1 173 SEP13 2 185 JUL13 2 186 MAY13 2 187 SEP13 3 222 FEB13 3 223 OCT13 4 301 MAY13 4 302 JUN13 4 303 APR13 ; run; data have2; input DEAL_NO POL_NO; cards; 1 173 2 186 3 222 4 301 ; run; proc sql; create table temp as select a.*,b.flag from have as a left join(select *,1 as flag from have2) as b on a.DEAL_NO=b.DEAL_NO & a.POL_NO=b.POL_NO having calculated flag eq 1; quit; proc sql; create table want as select a.*,b.LAPSE_DT from have(drop=LAPSE_DT) as a left join temp as b on a.DEAL_NO=b.DEAL_NO; quit; Thanks Sam

sam369 · ‎04-12-2013

Thank You PG. Now i got it Sam

sam369 · ‎04-12-2013

Perfect!!!! Thank you PGstat. But i didn't understand how exactly this was worked. I was confused at trim part? if you have time could you explain it THanks Sam

sam369 · ‎04-11-2013

Hi PGStat, after using your code i got flag 0 see the code below: data have; input id char1 $20. char2 $35.; cards; 100 T312F/M456U M456U 110 J568M M578T 120 G786E/T024Y/F123Y F123Y 130 F765G Q903T/N678B/Y347T/F765G/B987Y 140 H786E/F024Y/K123Y F123Y/M768Y/C675N ; run; data want; set have; flag = index(char1,char2) + index(char2,char1) > 0; run; proc print;run;

sam369 · ‎04-11-2013

Hi, In my dataset i have a 2 character variables, i need to compare them.If any Part of char1 matched with char2 i need to flag it.Matched items are marked as in BOLD in want dataset have; id char1 char2 100 T312F/M456U M456U 110 J568M M578T 120 G786E/T024Y/F123Y F123Y 130 F765G Q903T/N678B/Y347T/F765G/B987Y 140 H786E/F024Y/K123Y F123Y/M768Y/C675N Want: id char1 char2 Flag 100 T312F/M456U M456U 1 110 J568M M578T 0 120 G786E/T024Y/F123Y F123Y 1 130 F765G Q903T/N678B/Y347T/F765G/B987Y 1 140 H786E/F024Y/K123Y F123Y/M768Y/C675N 0 Thanks Sam

Online Status	Offline
Date Last Visited	‎01-10-2023 02:21 PM

Re: How to delete some observations in some groups based on a conditio...

Re: retain previous missing visits

retain previous missing visits

Re: How to add duplicates in a new column

Re: flag

flag

Re: pick the closest prior date

Re: pick the closest prior date

Re: pick the closest prior date

pick the closest prior date

Re: pick the closest prior date

Re: if else macro loop

Re: pick the closet value aginst time period

Re: pick the closet value aginst time period

Re: prxmatch

Re: How to add missing data

Re: Fill in the blanks with the previous value

Re: Help with expression or subquery in an SQL JOIN

Re: identifying maximum investment among ??

Re: pick 0 and 1

proc tabulate percentage

Re: ARRAY

Re: ARRAY

ARRAY

Re: how to merge data based on similarity

Re: Loading data into multiple tabs of an excel

Re: How to select first and last row of a data

Re: how to calculate differences from a baseline value

Re: Scan Function

Scan Function

Re: Help with expression or subquery in an SQL JOIN

Re: Compare the variables

Re: Compare the variables

Re: Compare the variables

Compare the variables