About sam369

sam369 · ‎09-04-2014

Good to know few new thing,Thank you ksharp and hai kuo. Thanks Sam

sam369 · ‎09-03-2014

Thank you stat!!!Exactly That is what ,what i want, i am still looking for some one to give the answer in datastep . Thanks Sam

sam369 · ‎09-03-2014

Thank you jagadish for time being i didt the same approach , like creating the dummy dataset and concatenate with original dataset.. but not all the time the same trt is missing(in this case 3 and 5) some time another trt(like 1,2,3,4,5). so i need to do in dynamic way instead of creating dummy dataset. i am trying with do until(last.trt) but unsucessful yet Thanks Sam

sam369 · ‎09-03-2014

Hi All, i have a data with missing trt. i need to fill with dummy for EX: trt code cnt ll ul 1 abc 2 4 5 1 bbc 2 4 5 1 cbc 2 4 5 2 abc 2 4 5 2 bbc 2 4 5 2 cbc 2 4 5 4 abc 2 4 5 4 bbc 2 4 5 4 cbc 2 4 5 6 abc 2 4 5 6 bbc 2 4 5 6 cbc 2 4 5 in the above example 3 and 5 is missing i need to trt with missing value and cnt ,ll,ul will be with 0 want: trt code cnt ll ul 1 abc 2 4 5 1 bbc 2 4 5 1 cbc 2 4 5 2 abc 2 4 5 2 bbc 2 4 5 2 cbc 2 4 5 3 abc 0 0 0 3 bbc 0 0 0 3 cbc 0 0 0 4 abc 2 4 5 4 bbc 2 4 5 4 cbc 2 4 5 5 abc 0 0 0 5 bbc 0 0 0 5 cbc 0 0 0 6 abc 2 4 5 6 bbc 2 4 5 6 cbc 2 4 5 Thanks Sam

sam369 · ‎08-31-2014

Thank you ballardw, exactly that is what i am lookign for Thanks Sam

sam369 · ‎08-29-2014

Hi All, I have a question,in a library i have few datasets like abc12,abc13,abc14,abc15. need to find dynamically whether that dataset is available in that library or not, if it is available then need to create a macro.. suppose i am checking in that library with respective number 15, then need to create a macro macro=abc15 Thank you Sam

sam369 · ‎06-05-2014

Thank you ksharp, data have; infile cards truncover; input sub vis & $10. dos ; cards; 100 WEEK 1 5 100 WEEK 1 5 100 WEEK 1 5 100 WEEK 2 100 WEEK 2 5 100 WEEK 2 5 100 WEEK 3 5 100 WEEK 3 5 100 WEEK 3 5 100 WEEK 4 5 100 WEEK 4 100 WEEK 4 5 100 WEEK 5 5 100 WEEK 5 5 100 WEEK 5 101 WEEK 1 101 WEEK 1 101 WEEK 1 101 WEEK 2 101 WEEK 2 ; run; proc sort data=have; by sub vis; run; data want; set have; by sub vis; retain group 'DDOS '; retain MAXWKDOS MINWKDOS ; output; wdos+dos; if last.vis then do; group='WDOS ';dos=wdos;output; CUMDOS+wdos;MAXWKDOS=max(MAXWKDOS,wdos); MINWKDOS =min(MINWKDOS,wdos); group='DDOS';wdos=0; end; if last.sub then do; call missing(vis); group= 'CUMDOS ';dos=CUMDOS;output; group='MAXWKDOS';dos=MAXWKDOS;output; group='MINWKDOS';dos=MINWKDOS;output; CUMDOS=0; MAXWKDOS=0; MINWKDOS=999999;group='DDOS';wdos=0; end; drop CUMDOS MAXWKDOS MINWKDOS wdos; run; I do not want the highlighted part in my final data set.Because this record does not have any dos. If subj have missing dos then i need to keep only sub with group DDOS.In the above example then non highlighted part should be in data set for sub 101 Thanks Sam

sam369 · ‎06-05-2014

Hi Keshan, Thanks for your code!!! your code is also producing the same issue. Except CUMDOS rest are working fine. I want cumulative dos with in each subject. For example: For subj 100: Cumdos is sum of(wdos) : like week1+week2+week3+week4+week5=(15+10+15+10+10)=60 For subj 101: Cumdos is sum of(wdos) : like week1+week2+week3+week4+week5=(10+15+15+25+15)=80 (but the above logic is getting 60+80=140) i do not want 140 as cumdos for sub 101 , the correct value is 80. Thanks Sam

sam369 · ‎06-04-2014

Thanks Reeza!!! I have an issue with cum_dose counts. For sub=100 the cum_dos is correct but for other subjects also it is summing the previous cum_dos. in my final dataset for CUMWDOS want: subj 100 CUMWDOS 60 101 CUMWDOS 55 but the above code getting subj 100 CUMWDOS 60 101 CUMWDOS 115 Thanks Sam

sam369 · ‎06-04-2014

Hi All, the below is my have dataset. for each subject ha multiple vis and each vis have dos. i want to create ddos, wkdos ddos is nothing but , dos having at that particular vis, wdos is sum of ddos in that paricular vis cumdos is sum of wdos, maxwkdos and minwkdos are max and minimum value of wdos Have: sub vis dos 100 WEEK 1 5 100 WEEK 1 5 100 WEEK 1 5 100 WEEK 2 100 WEEK 2 5 100 WEEK 2 5 100 WEEK 3 5 100 WEEK 3 5 100 WEEK 3 5 100 WEEK 4 5 100 WEEK 4 100 WEEK 4 5 100 WEEK 5 5 100 WEEK 5 5 100 WEEK 5 Want: sub group vis final 100 DDOS WEEK 1 5.000 100 DDOS WEEK 1 5.000 100 DDOS WEEK 1 5.000 100 WDOS WEEK 1 15.000 100 DDOS WEEK 2 100 DDOS WEEK 2 5.000 100 DDOS WEEK 2 5.000 100 WDOS WEEK 2 10.000 100 DDOS WEEK 3 5.000 100 DDOS WEEK 3 5.000 100 DDOS WEEK 3 5.000 100 WDOS WEEK 3 15.000 100 DDOS WEEK 4 5.000 100 DDOS WEEK 4 100 DDOS WEEK 4 5.000 100 WDOS WEEK 4 10.000 100 DDOS WEEK 5 5.000 100 DDOS WEEK 5 5.000 100 DDOS WEEK 5 100 WDOS WEEK 5 10.000 100 CUMDOS 60.000 100 MAXWKDOS 15.000 100 MINWKDOS 10.000 my code: proc sql; create table want as select distinct sub,vis,sum(dos) as final,'WDOS' as group from have group by sub,vis order by sub, final; quit; this way i am creating separately for all group parameters, any better way like keep a macro or using array or dataset to achieve want Thank you sam

sam369 · ‎05-21-2014

Hi Ksharp, This is the exactly what i am looking for... Thank you !!! Hi All, Thank you for your valuable input.. Sam

sam369 · ‎05-20-2014

Hi All, i have a data with level1,level2 level3,level4 categories in a variable. the data is keep on changing. i want to add missing whether the data as missing or not, but my final result reflect missing vategory. I am using proc format, it is showing when data is missing, if data is no missing final out is not havinf missing category in my final dataset. And i am ending with creating a dummy dataset to concatenate the with main data. I am looking for alternative ways to create. Any thoughts will be helpful example data have; input grp subgrp categ cnt; cards; 3 1 level1 30 3 2 level2 50 3 3 level3 150 3 4 level4 56 3 5 level5 16 ; run; want: 3 1 level1 30 3 2 level2 50 3 3 level3 150 3 4 level4 56 3 5 level5 16 3 6 missing 0(if data not having missing i need to show 0 or else i need to show how many are missing) to get the category count i am using freq proc freq data=rawdata; table stklevl/norow nocol missing out=have(rename=(stklevl=categ count=cnt)); format stklevl grpfmt.; Thanks Sam

sam369 · ‎05-09-2014

Thank you DBailey, This is what i am looking for Thank you once again Sam

sam369 · ‎05-09-2014

Hi All, I am having following dataset with stock values.daily the values will change , i need to find dynamically , values less than .5 and create a macro variable. data have; input name stockrate; datalines; xyz 0.015 abc 0.9 fxy .86 tdf .02 boa .76 wfd .005 ; run; in the above case there are 3 companies less than .5(xyz,tdf,wfd). latest data may change to other companies. right no i am enter manually like checking stockrate and enter the company names. like %let stat=xyz tdf wfd i am looking for dynamic approach to check the values , and pick the company names and fill the %let stat = (what ever the companies <.5) Any insight on this Thanks sam

sam369 · ‎04-01-2014

Hi all i got the required output sorry to post CODE: _dt=compress(dt); newdt=input(_dt,date9.); 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

Re: fill dummy with loop

Re: fill dummy with loop

Re: fill dummy with loop

fill dummy with loop

Re: check dataset from lib

check dataset from lib

Re: macro or array

Re: macro or array

Re: macro or array

macro or array

Re: adding extra row

adding extra row

Re: dynamic call

dynamic call

Re: char date to numeric date