About Linlin

Linlin · ‎02-26-2013

try: data want; merge set1(in=a rename =(result=r1)) set2(in=b rename=(result=r2)); by id year month; if a and b; r_diff=r1-r2; run;

Linlin · ‎02-25-2013

Hi, Did you use dataset HOMEWRK2.BONE. or HOMEWRK2.test? It would be helpful if you post your code.

Linlin · ‎02-24-2013

Hi try: data test; set homewrk2.test; age=int((dov-dob)/365.25); /*create age groups*/ if age <= 12 then agegrp=1; else if 12 <= age < 20 then agegrp=2; else if age >=20 then agegrp=3; run;

Linlin · ‎02-24-2013

here is the answer:

Linlin · ‎02-23-2013

The example below may save you some typing: data mktdata; input date mmddyy10.; format date mmddyy10.; cards; 01/02/2000 01/02/2001 01/02/2002 01/02/2003 01/02/2004 ; %macro test; %do year=2000 %to 2004; data yr&year.mktdata; set mktdata(where=(year(date)=&year)); run; %end; %mend; %test

Linlin · ‎02-22-2013

Hi changing %daterange(05Jan2013,20Jan2013,obs=5) to %print_n(05Jan2013,20Jan2013,obs=5)

Linlin · ‎02-22-2013

I don't think it is possible because there are so many common addresses.

Linlin · ‎02-20-2013

try: data temp1(keep=ssn code) temp2(keep=s_ssn s_code rename=(s_ssn=ssn s_code=code)); set have; data want; set temp1 temp2; run;

Linlin · ‎02-20-2013

Hi, try the code below to see if you get what you want (repace the RED part with your real dataset name, the dataset you want to add obsevations on): %macro LMGenerate(mymktdata,yeartag); data &mymktdata.highliquidity; *blah blah; run; data &mymktdata.lowliquidity; *blah blah; run; *this is basically difference of above 2 datasets data _&mymktdata; update &mymktdata.lowliquidity(in = a) &mymktdata.highliquidity(in =b); by year; if a & b then do; netpremium=lowliquiditytotal-highliquiditytotal; output; end; run; %mend LMGenerate; %LMGenerate(yr2010mktdata,2010 ) %LMGenerate(yr2011mktdata,2011 ) *global data; data want; set your_global_dataset_name _:; run;

Linlin · ‎02-19-2013

Hi , try adding another macro variable: %macro LMGenerate(mymktdata,yeartag,dsn); data &mymktdata.highliquidity; *blah blah; run; data &mymktdata.lowliquidity; *blah blah; run; *this is basically difference of above 2 datasets data &dsn._ liquiditypremiums; update &mymktdata.lowliquidity(in = a) &mymktdata.highliquidity(in =b); by year; if a & b then do; netpremium=lowliquiditytotal-highliquiditytotal; output; end; run; %mend LMGenerate; %LMGenerate(yr2010mktdata,2010,aaa ) %LMGenerate(yr2011mktdata,2011,bbb )

Linlin · ‎02-19-2013

Hi, I added the RED line to fix the missing problem. data have; input id v1-v7; cards; 7 7 7 7 7 7 7 7 1 1 2 3 4 5 6 7 2 3 4 5 4 3 3 2 3 4 5 6 7 6 5 4 4 3 4 5 6 4 3 2 5 5 5 5 5 5 5 5 6 2 2 2 2 2 2 2 ; data want(drop=i j); set have; retain answer1-answer7 0; array _v(*) v1-v7; array _w(*) answer1-answer7 ; do i=1 to 7;do j=1 to 7; if _v(j)=i then _w(i)+1; end;end;output; do i=1 to 7; _w(i)=0; end; proc print;run; /* you could use informat to convert the responses to numbers. example */ data test; input a $20.; cards; Less than 1 hour 2-3 hours 4-5 hours 6-7 hours 8-9 hours 10-15 hours 16 hours or more ; proc format; invalue trial 'Less than 1 hour'=1 '2-3 hours'=2 '4-5 hours'=3 '6-7 hours'=4 '8-9 hours'=5 '10-15 hours'=6 '16 hours or more'=7; data want; set test; b=input(a,trial.); proc print;run;

Linlin · ‎02-18-2013

data have; input id v1-v7; cards; 1 1 2 3 4 5 6 7 2 3 4 5 4 3 3 2 3 4 5 6 7 6 5 4 4 3 4 5 6 4 3 2 5 5 5 5 5 5 5 5 6 2 2 2 2 2 2 2 ; data want(drop=i j); set have; array _v(*) v1-v7; array _w(*) answer1-answer7; do i=1 to 7;do j=1 to 7; if _v(j)=i then _w(i)+1; end;end;output; do i=1 to 7; _w(i)=0; end; proc print;run; Obs id v1 v2 v3 v4 v5 v6 v7 answer1 answer2 answer3 answer4 answer5 answer6 answer7 1 1 1 2 3 4 5 6 7 1 1 1 1 1 1 1 2 2 3 4 5 4 3 3 2 0 1 3 2 1 0 0 3 3 4 5 6 7 6 5 4 0 0 0 2 2 2 1 4 4 3 4 5 6 4 3 2 0 1 2 2 1 1 0 5 5 5 5 5 5 5 5 5 0 0 0 0 7 0 0 6 6 2 2 2 2 2 2 2 0 7 0 0 0 0 0

Linlin · ‎02-17-2013

Hi, try the code below: %macro LMGenerate(mymktdata); proc rank data=&mymktdata out=deciledrankedscores ties= low descending groups=10; var LM12value; ranks decile; run; data &mymktdata.decile_0 &mymktdata.decile_1 &mymktdata.decile_2 &mymktdata.decile_3 &mymktdata.decile_4 &mymktdata.decile_5 &mymktdata.decile_6 &mymktdata.decile_7 &mymktdata.decile_8 &mymktdata.decile_9; set deciledrankedscores; select(decile); when (0) output &mymktdata.decile_0;/* can I make this output as..."output nameof(mymktdata)+&mymktdata.decile_0"*/ when (1) output &mymktdata.decile_1;/*I need to change the output data sets names to all of the following in the same naming way as above*/ when (2) output &mymktdata.decile_2; when (3) output &mymktdata.decile_3; when (4) output &mymktdata.decile_4; when (5) output &mymktdata.decile_5; when (6) output &mymktdata.decile_6; when (7) output &mymktdata.decile_7; when (8) output &mymktdata.decile_8; when (9) output &mymktdata.decile_9; otherwise; end; run; %mend LMGenerate; %LMGenerate(yr2011mktdata) %LMGenerate(yr2010mktdata)

Linlin · ‎02-16-2013

Hi try changing datepart(ao.agreed_delivery_datetime) FORMAT=date9. as Delivery_Date, to datepart(ao.agreed_delivery_datetime) as Delivery_Date FORMAT=date9.,

Linlin · ‎02-15-2013

data a; input id1; cards; 1 2 3 ; data b; input d2; cards; 1 2 ; data ab; do j=1 to n1; set a nobs=n1 point=j ; do i=1 to nobs; set b nobs=nobs point=i; output; end;end; stop; proc print;run;

Online Status	Offline
Date Last Visited	‎12-04-2020 11:18 PM

Re: How to put sas outputs into word file?

How to put sas outputs into word file?

Re: missing data

missing data

Re: Congratulations Fareeza!

Re: Capturing the last character in a variable value

Re: How to split one string into multiple rows?

Re: can't insert date macro into SQL

Re: Two consecutive visit records, Flag first record

Re: First and last day of month using Macros in proc sql

Re: How to count number of of call in the a week

Re: How to count number of of call in the a week

Re: Can someone help me with the following please?

Re: Can someone help me with the following please?

Re: Concatenate with CATX

Re: How to force two outputs from proc report on one page and keep dif...

Re: solution for loop

Re: I am trying to merge two files and don’t want to get rid of the du...

IN Dataset option

Re: convert month in num

Re: how to substract between (only 1)corresponding variable across dat...

Re: Create new age variable then create agegroups

Re: Create new age variable then create agegroups

Re: where to find all my quesitons posted here

Re: how to split a dataset into 300 sub datasets

Re: 2 "sub-macros" work, but I'm having trouble combining them...

Re: Is it possible to get a zip code based on an address within SAS?

Re: How to stack columns within the same table?

Re: want to write to global dataset from a macro(but it is erasing pre...

Re: want to write to global dataset from a macro(but it is erasing pre...

Re: Cumulative Response

Re: Cumulative Response

Re: can I append a dataset name to other datasetname in sas

Re: Datepart in EG 5.1 SQL

Re: Please help! data management question