About yaswanthj

yaswanthj · ‎12-04-2015

Dear, You can try many ways to get it done... As @dcruik Proc sql is good to use and we can use datastep as well for the same... try below code .... data A; input X $ Y; cards; Apples 1 Oranges 3 Pears 3 ; run; data b; input X $ Y; cards; Apples 1 Watermellon 1 Oranges 3 Pears 3 Banana 2 ; run; /*method 1*/ proc sql; create table want as select * from b where x not in (select distinct x from a); quit; /*Method two */ Proc sort data=a; by x;run; Proc sort data=b; by x;run; data want; merge a(in=_x) b(in=_y); by x; if _y and not _x; run;

yaswanthj · ‎02-16-2015

Hi, You can try below code. it should work. data usa canada australia; set info; if upcase(country)='USA' then output usa; if upcase(country)='CANADA' then output Canada; if upcase(country)='AUSTRALIA' then output Australia; run; When you use upcase function. String should be in upper case as above. whatever case in data, it should be populated in the output. Let me know if you need any help. Thanks, Yaswanth J.

yaswanthj · ‎03-20-2014

Hi DF Thanks For your input. I could not able to get the output wd your code. Thanks and Regards, Yaswanth

yaswanthj · ‎03-20-2014

Hi Reeza, It Will be Name and group by ID . Thanks, Yaswanth J.

yaswanthj · ‎03-20-2014

Dear All.. I have huge data. so Im just taking example and explaining the situation. I have data like below ID name logline stdtc endtc 101 a 1 01-jan-2013 03-jan-2013 101 a 2 05-jan-2013 06-jan-2013 101 b 1 01-jan-2013 03-jan-2013 101 b 2 05-jan-2013 06-jan-2013 101 c 1 01-jan-2013 03-jan-2013 101 c 2 05-jan-2013 06-jan-2013 102 a 1 01-jan-2013 03-jan-2013 102 a 2 04-jan-2013 06-jan-2013 102 b 1 01-jan-2013 03-jan-2013 102 b 2 04-jan-2013 06-jan-2013 102 b 3 07-jan-2013 10-jan-2013 In my output There should be gap between the end date and start date of the next log line. which means for the id 101 end date is like "03-jan-2013" and log line 2 start date is "05-jan-2013" for the name "a". in the scenario there is gap(one day) in between this. So i should need in the output as if there is a gap as mentioned. output need to get like below OUTPUT: 101 a 1 01-jan-2013 03-jan-2013 101 a 2 05-jan-2013 06-jan-2013 101 b 1 01-jan-2013 03-jan-2013 101 b 2 05-jan-2013 06-jan-2013 101 c 1 01-jan-2013 03-jan-2013 101 c 2 05-jan-2013 06-jan-2013 With Best Regards, Yaswanth J.

yaswanthj · ‎12-23-2013

Hi Sanjeev, This code may will help you.. data have; input number text&$30.; cards; 1 1.YOUR NAME IS 'SANJEEV.' 2 2.YOUR NAME IS 'SRINATH.' ; run; proc print; run; data want; set have; /*text=compress(text,'.','d');*/ text =substr(strip(text),indexc(text ,'.')+1,length(text )-indexc(text ,'.')); proc print;run; Thanks, Yaswanth J.

yaswanthj · ‎12-23-2013

Hi .. You can use any condition, which is provided by tom, jegadish and karthik. and also you can use proc sql to print the same result. where if you use the proc sql, it should take less time to execute the code rather than using data step. Thanks, yaswanth proc sql; select * from sasuser.admit where actlevel in ('HIGH','LOW') and fee gt 100; quit; Thanks, yaswanth

yaswanthj · ‎10-08-2013

Hi .. Small update to the @data_null_; code.. data pattern; do until(last.id); do until(last.col1); set ranks; by id col1; length p pattern $128; p = catX('_',p,_name_);/*Updated cats(p,_name_) to catX('_',p,_name_)*/ end; pattern = catx('_',pattern,p); call missing(p); end; drop col1 _name_ p; run; Hope this will helps.. Thanks,Yash.

yaswanthj · ‎10-04-2013

Is it possible using DATA STEP.. same result as proc sql and proc freq???

yaswanthj · ‎09-26-2013

This Discussion is worth reading Regarding macro Global&local variables Thanks all..

yaswanthj · ‎09-26-2013

Hi HDG.. We can do this using proc rank very easily ..here is the code for you..this may help for your requirement.. data cluster; input date:mmddyy. cluster_id code:$1.; format date mmddyy10.; cards; 05/31/2000 1 A 05/31/2000 1 B 05/31/2000 3 C 05/31/2000 3 E 05/31/2000 5 F 05/31/2001 1 A 05/31/2001 2 B 05/31/2001 5 C 05/31/2001 7 D 05/31/2001 7 E 05/31/2001 7 F ;;;; run; proc print; run; proc rank data = cluster ties = dense out = want; by date; var cluster_id; ranks clstr_wnt; run; proc print data = want; run; Thanks, Yash...

yaswanthj · ‎09-25-2013

thanks Scott.. i have updated the word in my previous reply..

yaswanthj · ‎09-25-2013

I think you get same result. what ever mentioned in the above.. If you can try like below you get your result..declaring the second date locally.. %macro one (input); %two; %put the value is &date; %mend; %macro two; data _null_; call symput('date','12SEP2008'); run %mend; %macro two; %let date=31DEC2006; %mend; %one(&date); %put _user_; Thanks, Yash.

yaswanthj · ‎09-25-2013

Thanks

yaswanthj · ‎09-25-2013

Hi.. If you want to create new flags as string and numeric. data tmp; length value $ 4; input value; cards; 1234 sys ;; run; data flag; set tmp; string1 = anyalpha(value); if string1 = 1 then string = value;else number=value; * then string = value;*else value = numeric; drop string1; /*put value= flag=;*/ run; proc print noobs;; run; Thanks, Yash

Online Status	Offline
Date Last Visited	‎11-28-2017 12:50 AM

Re: Subtracting two SAS data sets

Re: how to create multiple dataset from one dataset?

Re: Need help on comparing end dates with start date in second line

Re: Need help on comparing end dates with start date in second line

Need help on comparing end dates with start date in second line

Re: how to extract perticular word.

Re: Subset data based on Numeric & Character Variables

Re: row sorting

Re: Count different columns

Re: global macro

Re: How to find the correct PAN #(ex: ABCDF1234J)in a given data.

Re: How to select last n rows of input records using SQL?

How To import .xlsx file in to sas using infile statment

Re: how to extract perticular word.

Re: proc sql count problem

Re: How to scan comma delimited macro variable list?

Re: how to create multiple dataset from one dataset?

Re: Subtracting two SAS data sets

Re: how to create multiple dataset from one dataset?

Re: Need help on comparing end dates with start date in second line

Re: Need help on comparing end dates with start date in second line

Need help on comparing end dates with start date in second line

Re: how to extract perticular word.

Re: Subset data based on Numeric & Character Variables

Re: row sorting

Re: Count different columns

Re: global macro

Re: data manipulation

Re: global macro

Re: global macro

Re: Error when i import doc file into sas..

Re: need the logic to tell if this value looks like numeric