yaswanthj Tracker

Re: Subtracting two SAS data sets

yaswanthj — Fri, 04 Dec 2015 09:08:03 GMT

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;

Re: how to create multiple dataset from one dataset?

yaswanthj — Mon, 16 Feb 2015 07:40:13 GMT

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.

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

yaswanthj — Fri, 21 Mar 2014 02:42:38 GMT

Hi DF

Thanks For your input.

I could not able to get the output wd your code.

Thanks and Regards,

Yaswanth

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

yaswanthj — Fri, 21 Mar 2014 02:41:34 GMT

Hi Reeza,

It Will be Name and group by ID .

Thanks, Yaswanth J.

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

yaswanthj — Thu, 20 Mar 2014 14:19:25 GMT

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.

Re: how to extract perticular word.

yaswanthj — Mon, 23 Dec 2013 11:19:39 GMT

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.

Re: Subset data based on Numeric & Character Variables

yaswanthj — Mon, 23 Dec 2013 08:54:08 GMT

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

Re: row sorting

yaswanthj — Tue, 08 Oct 2013 09:58:15 GMT

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.

Re: Count different columns

yaswanthj — Fri, 04 Oct 2013 14:02:28 GMT

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

Re: global macro

yaswanthj — Thu, 26 Sep 2013 10:20:55 GMT

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

Re: data manipulation

yaswanthj — Thu, 26 Sep 2013 09:01:25 GMT

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...

Re: global macro

yaswanthj — Wed, 25 Sep 2013 11:20:47 GMT

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

Re: global macro

yaswanthj — Wed, 25 Sep 2013 10:32:06 GMT

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.

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

yaswanthj — Wed, 25 Sep 2013 10:04:43 GMT

Thanks

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

yaswanthj — Wed, 25 Sep 2013 10:02:12 GMT

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

Re: lack of quit statement in proc sql

yaswanthj — Wed, 25 Sep 2013 09:35:17 GMT

Hi ..

Go though the below link, this question is already posted by PGstats...

https://communities.sas.com/thread/37050?start=0&tstart=0

Please go though,you will get good idea about why we should be write the quit, in the end of proc sql;

Thanks,

Yash

Re: global macro

yaswanthj — Wed, 25 Sep 2013 09:24:44 GMT

Hi .

Macro parameters are always local to the macro that defines them. So that you already define the macro variable inside the macro..which means local

And you are passing the local macro parameter..So that you have a result of local macro variable value ..

Thanks,

Yash

Re: Concatenation of 2 fields (need to retain Leading Zeros)

yaswanthj — Fri, 20 Sep 2013 16:26:53 GMT

What was the alue for "OUT_REC" variable?

Yash

Re: Proc Import not successful

yaswanthj — Fri, 20 Sep 2013 12:02:36 GMT

Hi..

There is a semicolon(;) in between the datafile and out. so that you can not generate the file to dataset. please remove semicolon(;) and run. you will get the results with out any error..

proc import datafile="E:\Sridhar\Analytics\SAS Course Material\case study\computer_peripherels\comp.csv"

Out=lib1.comp dbms=csv;

run;

Thanks,

Yaswanth J.

Re: Proc Import not successful

yaswanthj — Fri, 20 Sep 2013 11:33:20 GMT

Hi Srider,

You can import the CSV file using infile statement. this should be easy way to import the file..to sas..

data want;

infile "E:\Sridhar\Analytics\SAS Course Material\case study\computer_peripherels\comp.csv";

/*input var */

run;

Thanks,

Yashu