About Linlin

Linlin · ‎01-06-2012

Using the sample data created by Patrick: data have_A; id=1; array Q3_ {5} 8. (5*2); array Q17_ {9} 8. (9*20); array Q41_ {10} 8. (10*1); array Q52_ {10} 8. (10*1); someOtherVar=0; output; run; data have_B; id=1; FirstName='fn'; LastName='ln'; Agency='A'; Status='1'; run; data want; merge have_a have_b; by id; run; proc sql noprint; select name into :q3 separated by ' ' from dictionary.columns where libname='WORK' and memname='WANT' and upcase(substr(name,1,3))='Q3_' order by name; select name into :q17 separated by ' ' from dictionary.columns where libname='WORK' and memname='WANT' and upcase(substr(name,1,3))='Q17' order by name; select name into :q41 separated by ' ' from dictionary.columns where libname='WORK' and memname='WANT' and upcase(substr(name,1,3))='Q41' order by name; select name into :q52 separated by ' ' from dictionary.columns where libname='WORK' and memname='WANT' and upcase(substr(name,1,3))='Q52' order by name; quit; data want; retain firstname lastname &q52 agency &q3 status &q52 &q41; set want(drop=id); run;

Linlin · ‎01-06-2012

Yes, you can. example: data have; input q30_1 q30_2 q30_3 aa bb; cards; 1 2 3 4 5 ; data want; set have (keep=q30_:); run; proc print;run;

Linlin · ‎01-06-2012

Hi Art, you are more than welcome. Thank you for your contribution to the forum. I have learned a lot from you. Linlin

Linlin · ‎01-05-2012

data have; input aaf bbbf ccc; cards; 1 2 4 2 3 8 ; proc sql noprint; select name into : names separated by ' ' from dictionary.columns where libname='WORK' and memname='HAVE' and lowcase(substr(name,length(name),1))='f'; quit; data want; set have (drop=&names); run; proc print;run; Obs ccc 1 4 2 8 Linlin

Linlin · ‎01-05-2012

data have; input mydate $10.; cards; 2011-01-01 2011-01-02 ; data want (drop=_:); format mydate date9.; set have (rename=(mydate=_mydate)); mydate=input(_mydate,yymmdd10.); run; proc print;run; proc contents; run; Linlin

Linlin · ‎01-05-2012

Hi Reeza, In order to get the missing counts, there must be at least one missing value in the dataset. data class; set sashelp.class; if name='Alice' then age=.; run; proc format; value age 11='Pre Teen' 12='Pre Teen' 13='Teen' 14='Teen' 15='Teen' .,16=' '; run; proc freq data=class; table age; format age age.; run; Cumulative Cumulative Age Frequency Percent Frequency Percent ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ Pre Teen 7 41.18 7 41.18 Teen 10 58.82 17 100.00 Frequency Missing = 2 Linlin

Linlin · ‎01-05-2012

Hi Mike, Happy New Year! Thank you for your explanations!

Linlin · ‎01-05-2012

data have; input dates; informat dates mmddyy10.; format dates date9.; cards; 12/1/2011 1/1/2012 ; proc print; title before change; run; proc datasets library=WORK nolist; modify have; format dates mmddyy10.; proc print; title after change;run;

Linlin · ‎01-04-2012

is this helpful? proc format; value C5R . = " " 1 = "MOTHER (STEP, FOSTER, ADOPTIVE) OR FEMALE GUARDIAN" 2 = "FATHER (STEP, FOSTER, ADOPTIVE) OR MALE GUARDIAN" 3 = "GRANDPARENT" 4 = "OTHER FAMILY MEMBER/FRIEND" 77 = " " 99 = " "; run; data have; input v; format v c5r.; cards; 1 2 2 3 4 77 99 . ; proc freq data=have; tables v; run;

Linlin · ‎01-04-2012

Yes, your code is fine. data demo_bp; input BPQ010 BPQ020 BPQ070 BPQ080; cards; 7 9 8 6 8 10 11 12 9 12 9 19 ; proc print; title from dataset &syslast; run; Data demo_BP1; set demo_BP; If BPQ010 in (7,9) then BPQ010=.; run; proc print; title from dataset &syslast; run; Data demo_BP2; set demo_BP; array _rdmiss BPQ010 BPQ020 BPQ070 BPQ080 ; do over _rdmiss; if _rdmiss in (7, 9) then _rdmiss=.; end; proc print; title from dataset &syslast; run; Linlin

Linlin · ‎01-04-2012

%let month2 = '01AUG11'd; data temp; do i = 1 to 24; v=intnx('month', &month2, -i); format v date7.; output; end; run; data _null_; set temp; call symputx(cats('d',strip(_n_)),put(v,date7.)); run; %put _user_; Linlin

Linlin · ‎01-03-2012

Hi Art, Happy New Year to you! Can you explain the two "??" in your code? if not missing(input(_char(i),?? best32.)) then

Linlin · ‎01-03-2012

you can get what you want by: proc sort data=have out=want nodupkey; by email; run; Linlin

Linlin · ‎12-26-2011

data a; input Company $ market_weight; cards; A 0.5 B 0.3 C 0.2 ; data b; input Investor Company $ investor_weight; cards; 1 A 0.4 1 B 0.6 2 B 1 3 A .2 3 B .3 3 C .5 ; run; proc sort data=b; by investor company; proc transpose data=b out=look1(drop=_name_); by investor; id company; run; data look1; set look1; if a=. then a=0; if b=. then b=0; if c=. then c=0; run; proc transpose data=look1 out=look2(rename=(_name_=company col1=investor_weight)); by investor; run; proc sql; create table want as select Investor, look2.Company, investor_weight,market_weight from look2,a where look2.company=a.company; quit; proc print;run; Linlin

Linlin · ‎12-25-2011

data have; infile cards missover; input A B C D E; cards; 1 12 3.2 . . 1.5 10 4 . 8 1.3 11 5.6 7 9 ; run; data ab (rename=(a=var1 b=var2)); set have(keep=a b); i=_n_; group=1; data cd (rename=(c=var1 d=var2)); set have(keep=c d); i=_n_; group=2; data e (rename=(e=var1)); set have(keep=e); i=_n_; group=3; data want (keep=var:); set ab cd e; by i group; run; proc print; run; Linlin

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: Selecting Alternating Sets of Variables

Selecting Alternating Sets of Variables

Re: How to convert numeric date to sasdate ?

Re: How to delete all variables with the names as ???f

Re: How to convert numeric date to sasdate ?

Re: Using Proc format to code multiple values to missing

Re: Converting character to numeric

To Alter a column definition

Using Proc format to code multiple values to missing

Re: Question About Recoding Variables

Re: using macro's, SQL, do loops to create SAS Variables for dates to ...

Converting character to numeric

Re: finding duplicates

Re: Many to Many match issue

Re: how can I extract name of correlated variables?