About srinath3111

srinath3111 · ‎09-21-2018

Hi, Data have; length class $7; Set unclean; X=mod(_n_, 3); If x=1 then class="name"; Else if x =2 then class = "address"; Else if x=0 then class = "type"; Retain record; If x=1 then record+1; Run; Proc transpose data=have out=want(drop=CLASSIFICATION _name_ record); By Id record; Var var; Id class; Run;

srinath3111 · ‎07-06-2018

data ds; infile datalines; input var1 var2$10.; datalines; 201 Pakistan 206 Bangladesh 209 Russia 208 China 245 In 862 L ; run; what i need is Paxxstan baxxladesh Ruxxia chxxa In L

srinath3111 · ‎07-04-2018

Actually I wanted to know the data gaps. What i need is for suppose x client has given data for jan, Mar, Dec 2017 but we are suppose to receive the data for jan2017 to dec 2017 our code should identify the data gaps for example FEB, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV is missing data so we should have flag "should reach out" Thanks in advance

srinath3111 · ‎07-04-2018

I have a data set below grp_name is the name of client data_have is like what months we have received the data, start_dt is from when we should we receive the data, end_dt is till when we have to receive the data. grp_name data_have start_dt end_dt X Jan2016 Jan2016 Dec2016 X Mar2016 Jan2016 Dec2016 X Dec2016 Jan2016 Dec2016 y Jan2017 Jan2017 Apr2017 y Feb2017 Jan2017 Apr2017 y Mar2017 Jan2017 Apr2017 y Apr2017 Jan2017 Apr2017 z Apr2018 Jan2018 Dec2018 ; What i need is For x group we have for Jan, Mar, Dec 2016 but we should have data from jan to dec 2016 so a flag should be created and should be marked as 1 else 0. Thanks in advance

srinath3111 · ‎05-17-2018

Hi, It doesnt work. Thanks

srinath3111 · ‎05-17-2018

Hi, data ds; infile datalines; input a$ b$ c$ d$ e$; datalines; 1 2 as> sd< 78# 3 5 a>a sd< 78& 1 2 <ss sd< 78* 1 2 ss 3 84 ; run; output may be like _n_ 1 2 3 or 1 2 as> sd< 78# 3 5 a>a sd< 78& 1 2 <ss sd< 78* I was trying data ds1; array spc(93) _All_; set work.ds nobs=nobs point=i; do i=1 to dim(spc); where spc(i) like (<%,>%,%>%,>%,%>,%>%); end; stop; run; Thanks in advance

srinath3111 · ‎05-16-2018

Hi, Try this. %let vector=1804+1803+1712; %let k=3; %put &vector.; options symbolgen mprint mlogic; %macro Macro0; %DO i=1 %TO &k; %let mon&i=%scan(&vector,&i); %end; %put &mon1; %put &mon2; %put &mon3; %mend; %macro0; Thanks, Srianth.

srinath3111 · ‎05-15-2018

Hi, Try data ds; infile datalines; input proce_new$; new_price=input(proce_new,12.); datalines; 104 104.25 104.35 103 ; run; Thanks, Srinath

srinath3111 · ‎05-10-2018

Hi, proc sql; create table final as select a, count(a) as COUNT from l group by a; quit; data ds; set l; by a b; keep a count; retain count 0; if first.a=1 then count=1; else count=sum(count,1); if last.a=1 then output; run; Thanks, srinath

srinath3111 · ‎05-04-2018

data ds; infile datalines; input Encounter Id Date ER$; informat Date anydtdte10.; format Date mmddyy10.; datalines; 4390843 1001 2/8/2017 Y 1327819 1001 1/2/2017 Y 239480 1001 5/4/2017 N 43958345 1001 1/7/2018 N 390485903 1001 5/4/2018 N 323465354 1002 2/5/2017 Y 54332432 1002 6/8/2017 Y 7657657567 1002 9/8/2017 N 768698 1003 6/8/2017 Y 7567465 1003 8/9/2017 Y 23465758 1003 9/5/2017 N 35134346674 1003 10/9/2018 N 34575697 1003 11/8/2018 Y 3524341 1003 12/8/2018 N ; run; proc sort data=ds; by id; run; proc sql; select distinct count(Encounter), id from ds where ER='Y' and qtr(date) le 2 group by id; quit;

srinath3111 · ‎05-04-2018

Hi, As per your query i think double trailing '@@' should solve your issue. If you could elaborate your query with a small instance that would be appreciated. Thanks, Srinath

srinath3111 · ‎03-15-2018

Hi, I have variables in file like Name sex dob var1-var4 Here i wanted to merge the multiple records into single record based on the name,dob,gender variables. xx M 22/11/1992 2 0 7 0 xx M 22/11/1992 0 6 0 3 yy F 24/8/1989 2 0 6 0 yy F 24/8/1989 0 9 0 8 zz M 22/11/1992 2 0 7 0 zz M 22/11/1992 0 6 0 3 required xx M 22/11/1992 2 6 7 3 yy F 24/8/1989 2 9 6 8 zz M 22/11/1992 2 6 7 3 Thanks

srinath3111 · ‎03-13-2018

Hi, proc import table="table_name" out=lib.dataset_name dbms=access; uid="userid"; pwd="password"; database="filepath\filename.mdb"; run; Thanks.

srinath3111 · ‎03-13-2018

Hi, Then try, data ds2; merge ds(where=(not val) in=null) ds; by id; if not null; run; Thanks

srinath3111 · ‎03-13-2018

Hi , data ds; infile datalines; input id val; datalines; 1 1 2 0 3 5 4 0 5 2 ; run; data ds1; set ds; array dat[*] _all_; do i=1 to dim(dat); if dat(i)=0 then delete; end; output; run; Thanks

Online Status	Offline
Date Last Visited	‎06-22-2021 10:14 AM

Re: Best way to "transpose"/make wide this data

Replace string with another string

Re: Got struck Please help.

identifying data gaps in the data

Re: How to know weather the data set contains special characters in ea...

How to know weather the data set contains special characters in each v...

Re: %let from string with multiple values separated by +

Re: Convert character to numeric

Re: I have data set need to count column b values how many times it re...

Re: SAS coding

Re: PROC EXPORT DBMS=EXCEL

Re: %let from string with multiple values separated by +

Re: Multiple records to one observation

Re: How do I create a calculated column in an existing dataset

Re: Syntax error

Re: Issue with Data step import

Re: Best way to "transpose"/make wide this data

Replace string with another string

Re: Got struck Please help.

identifying data gaps in the data

Re: How to know weather the data set contains special characters in ea...

How to know weather the data set contains special characters in each v...

Re: %let from string with multiple values separated by +

Re: Convert character to numeric

Re: I have data set need to count column b values how many times it re...

Re: SAS coding

Re: Multiple records to one observation

To standardize data

Re: Import data in sas from Access 2013

Re: how to remove the entire records of each id if it has values as ei...

Re: how to remove the entire records of each id if it has values as ei...