About sam369

sam369 · ‎02-16-2016

Thanks Reeza!!! . I tried the way you suggested, but doesnt work!!! i created a order variable!! still not able to get what i want Any suggestion will be helpful Thanks Sam

sam369 · ‎02-15-2016

Same , orddt to recdt Thanks Sam

sam369 · ‎02-15-2016

Hi All, I want to create variable with all the dates between the dates ranges. for example have: id orddt recdt 100 1/5/15 2/3/15 100 1/17/15 3/6/15 ...... .... 101 ............... 101 ...... want; 1d orddt1 recdt1 dt1 dt2 orddt2 recdt2 100 1/5/15 2/3/15 1/5/15(first orddt) 100 1/5/15 2/3/15 1/6/15 100 1/5/15 2/3/15 1/7/15 100 1/5/15 2/3/15 1/8/15 ................... ...................... 100 1/5/15 2/3/15 1/17/15 1/17/15( 2nd orddt) 1/17/15 3/6/15 100 1/5/15 2/3/15 1/18/15(upto first recdt) 1/18/15 1/17/15 3/6/15 ........................ .................... 100 1/5/15 2/3/15 2/2/15 100 1/5/15 2/3/15 2/3/15 100 2/4/15 1/17/15 3/6/15 100 2/5/15 1/17/15 3/6/15 ............................ .............................. .............................. 100 3/6/15(2nd recdt) 1/17/15 3/6/15 my code: data want; set have; by id; array d[&max] dt1-dt&max.; do i=1 to &max; do dt=orddt to recdt; d[i]=dt; output; end; end; format dt-dt&max. date9.; run; i am missing some thing in my code. Thanks Sam

sam369 · ‎01-12-2016

Thank you Reeza!!! can we adopt this formula under the sql? if i used in data step i got the output , but if i want to adopt for sql, getting warning on log, "net variable already exit in XXXX dataset" Thanks Sam

sam369 · ‎01-12-2016

Hi All, I have longitudnal data and grp variable and fl variable, values of grp as 1 2 3 4 5 6... and values for fl as 1 2 3... need to create variable net. Is there any dynamic way to get the grp and fl values if grp=1 then do; if fl=1 then net=1; if fl=2 then net=2;end; if grp=2 then do; if fl=1 then net=3; if fl=2 then net=4;end; if grp=3 then do; if fl=1 then net=5; if fl=2 then net=6;end; if grp=4 then do; if fl=1 then net=7; if fl=2 then net=8;end; my try : %let maxgrp=4;%let fl=2; proc sql; select *, %do i=1 %to &maxgrp; j=1 %to &fl; case when grp=&i and fl eq &j then &i*&j; end as trt from ids; quit; Thanks Sam

sam369 · ‎11-11-2015

Hi , I tried that one too. But no luck Thanks Sam

sam369 · ‎11-11-2015

Thank you for the reponse!!! for the sample data it is working fine. but on my real data i got this error. and in my example data i gave only 5 dy variable(dy1-dy5) but in my realy data it has more than 100. so icreate a macro variable and assing the value to array like this array dy_all dy1-dy&obs. ERROR: Mixing of implicit and explicit array subscripting is not allowed. Thanks Sam ERROR: Mixing of implicit and explicit array subscripting is not allowed. - See more at: http://compgroups.net/comp.soft-sys.sas/array-index/133326#sthash.gy1yuUJi.dpuf ERROR: Mixing of implicit and explicit array subscripting is not allowed - See more at: http://compgroups.net/comp.soft-sys.sas/array-index/133326#sthash.gy1yuUJi.dpuf ERROR: Mixing of implicit and explicit array subscripting is not allowed - See more at: http://compgroups.net/comp.soft-sys.sas/array-index/133326#sthash.gy1yuUJi.dpuf

sam369 · ‎11-10-2015

Hi all, I have veritical data . I need to create a variable which is close to the value. I am createing a reqvar variable. cond: reqvar is missing then dy1 is missing or ev<dy1 or ev-dy:(dy1 dy2 dy3 dy4 dy5)>80 assing val: for whose time point is close to ev data have; input sub ev cnt dy1 dy2 dy3 dy4 dy5 val1 val2 val3 val4 val5; cards; 100 255 5 25 55 78 90 110 .5 .9 1.5 6 8 101 90 3 40 83 87 . . .6 .8 1.7 . . 103 24 2 25 30 . . . .9 .9 . . . 104 100 5 80 90 99 180 200 1.8 1.9 2 6 9 ; run; data want; sub ev cnt reqvar 100 255 5 . (it is missing because ev -dy >80) 101 90 3 1.7 (assigned closet day ev=90 & dy3 =87 then assign value val3=1.7) 103 24 2 . (it is missing because ev <dy1) 104 100 5 2 assigned closet day ev=100 & dy3 =99, dy4 is 180 duration b/w ev-dy4 >80 so assign value val3=2) Thanks Sam

sam369 · ‎09-08-2015

Hi All, how to import the excel, using porc import . having some values have apostrophes in the columns!!! excel coulumns : sub txt 100 medical's 100 software's Mycode: proc import out=want datafiles="location.xlsx" dbms=xlsx replace; getnames='yes'; run; Thanks Sam

sam369 · ‎08-18-2015

Thank you All Sam

sam369 · ‎08-17-2015

Hi Ballardw, Dates are in character format. yes you are right, the subject doesn't have flg sub grp vis dt flg 100 bbb v1 20jun2013 The rule for the flg is, to check the dates with previous dates in that grp. if the visit date is after the previous visit date i need to flg them . Thanks Sam

sam369 · ‎08-17-2015

Hi All, i need to check the date with previous visit in the group. i have visits up to 50, and different from each group. below is how data look like Have: data have; input sub grp vis dt; cards; 100 xxx v1 20jun2012 100 xxx v2 27aug2012 100 xxx v3 15sep2012 100 xxx v4 20aug2012 100 yyy v1 20jun2012 100 yyy v2 100 yyy v3 15sep2012 100 yyy v4 15sep2012 100 zzz v1 20jun2012 100 zzz v2 27aug2012 100 zzz v3 10mar2012 100 zzz v3 15sep2012 100 aaa v1 20jun2012 100 aaa v2 27aug2011 100 aaa v3 15sep2012 100 aaa v4 25dec2012 100 bbb v1 20jun2013 100 bbb v2 27aug2012 100 bbb v3 15sep2012 want: isub grp vis dt flg; 100 xxx v1 20jun2012 100 xxx v2 27aug2012 100 xxx v3 15sep2012 100 xxx v4 20aug2012 1 100 yyy v1 20jun2012 100 yyy v2 100 yyy v3 15sep2012 100 yyy v4 15sep2012 100 zzz v1 20jun2012 100 zzz v2 27aug2012 100 zzz v3 10mar2012 1 100 zzz v3 15sep2012 100 aaa v1 20jun2012 100 aaa v2 27aug2011 1 100 aaa v3 15sep2012 100 aaa v4 25dec2012 100 bbb v1 20jun2013 1 100 bbb v2 27aug2012 1 100 bbb v3 15sep2012 1 Thanks Sam

sam369 · ‎07-08-2015

Thank you for your time & detail explanation Hai.kuo. Now i understood clearly!!!!! new thing to learn .... Have a great night Thanks Sam

sam369 · ‎07-08-2015

HI Hai.kuo, Thank you so much It worked!!!! could you please explain in detail the below part... i am not aware of ** "(-1)**(sum(val = 0)>0)*val" Thanks Sam

sam369 · ‎07-08-2015

Hi Stat, thank you so much for your quick response. i have added one more to have group according to my real data data have; input id grp1 $ trt $ val ; cards; 100 xxxx x 0 100 xxxx y 1 100 yyyy x .33 100 yyyy y .67 100 zzzz x .5 100 zzzz y .5 100 aaaa x 1 100 aaaa y 0 100 bbbb x 0.63 100 bbbb y 0 100 cccc x 0 100 cccc y .4 100 dddd x 1 100 dddd y 1 100 eeee x 0 100 eeee y 0 100 ffff x .67 100 ffff y 1 ; run; proc sql; create table want as select *,case when sum(val in (1,0))>=1 & sum(val) ne 2 then val*-1 else val end as val1 from have group by id,grp1; quit; output: want1: id grp1 trt val val1 100 xxxx x 0 0 100 xxxx y 1 -1 100 yyyy x .33 .33 100 yyyy y .67 .67 100 zzzz x .5 .5 100 zzzz y .5 .5 100 aaaa x 1 -1 100 aaaa y 0 0 100 bbbb x 0.63 -.63 100 bbbb y 0 0 100 cccc x 0 0 100 cccc y .4 -.4 100 dddd x 1 1 100 dddd y 1 1 100 eeee x 0 0 100 eeee y 0 0 100 ffff x .67 .67 100 ffff y 1 1 ; Is there any way to pick only values having 0 & (any value) for individual grp i mean another dataset want2: 100 xxxx x 0 100 xxxx y 1 100 aaaa x 1 100 aaaa y 0 100 bbbb x 0.63 100 bbbb y 0 100 cccc x 0 100 cccc y .4 ; run; 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: finding specific words and creating a new variable

Re: caculating 'exit load' based on dates !!!

Re: How to add missing data

Re: pick 0 and 1

Re: how to calculate differences from a baseline value

Re: all dates between range

Re: all dates between range

all dates between range

Re: if else macro loop

if else macro loop

Re: assign the closet value

Re: assign the closet value

assign the closet value

import columns

Re: check dates

Re: check dates

check dates

Re: pick 0 and 1

Re: pick 0 and 1

Re: pick 0 and 1