About Steelers_In_DC

Steelers_In_DC · ‎04-09-2015

I am currently using this: proc datasets lib=tran1214 nolist;contents data=_all_ noprint out=MDJ.tran1214;quit;run; I can search the output to find a table that has one or several variables that I need to use. There is one table that has a corrupted table so it will not work. I would like to do something like this (this does not work) proc datasets lib=wbdw nolist; contents data = ABS_02PORTFOLIO_CONVERSION ; contents data = ACLS_CONCENTRATION_FACT ; contents data = ACLS_CUSTOMER_DIMENSION ; contents data = ACLS_LOAN_DIMENSION ; contents data = AGENDA_ACTIVITY_DIM ; contents data = AGENDA_ATTEND_FACT ; contents data = AGENDA_CONTACT_FACT ; currently I'm taking this output with several hundred tables and putting it into excel to search for variables. Is there a way to list multiple datasets rather than _all_? I'm using the output to feed into this: proc sql; create table WANT as select DISTINCT MEMNAME from &check_lib where /*MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME)="ACCT_PARTICIPATED_AMT") AND*/ /*MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME)="ACCT_CUST_INTEREST_BAL_AMT") AND*/ /*MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME)="ACCT_FEE_CURRENT_PAYOFF_AMT") AND*/ /*memname in (select distinct MEMNAME from &check_lib where upcase(NAME) contains "DEFAULT_DATE_END") AND*/ MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME) contains "PD"); quit; I've tried a few things with no viable solutions, any help will be appreciated. Thanks in advance.

Steelers_In_DC · ‎04-09-2015

I see what you meant about the union now, I misunderstood what you were asking for. Yes I would build a data set with the date range first and then join. I've used proc expand for this as well.

Steelers_In_DC · ‎04-09-2015

Here you go, hope this helps: data have; infile datalines dsd; informat monyear2 date9.; format monyear2 date9.; input monyear $ monyear2 val $ Category $; datalines; ,31MAR2015,0 1,mkt1 mar-15,,0 2,mkt2 mar-15,,0 1,mkt7 ; run; data want; set have; /*if using characters*/ if monyear = '' then balamt = '0'; /*if using numbers*/ if monyear2 = . then balamt2 = 1; run;

Steelers_In_DC · ‎04-09-2015

I'm at a loss, take a look and see if this helps: SAS/GRAPH(R) 9.2: Statistical Graphics Procedures Guide, Second Edition

Steelers_In_DC · ‎04-09-2015

I'm not sure if this will work but try just=right or just=r.

Steelers_In_DC · ‎04-09-2015

You only have 2 IDs in your output, is that a mistake? I don't know why you are dropping 10. Here is a solution but it has three IDs: data have; infile cards dsd; input MOTHER_ID BIRTH_YR birth_num; cards; 5,2009,1 7,2004,1 10,2005,1 10,2008,2 10,2010,3 12,2006,1 12,2008,2 14,2004,1 14,2006,2 14,2008,3 ; run; data want; do until (last.mother_id); set have; by mother_id; if birth_num = 2 then _flag = 1; end; do until (last.mother_id); set have; by mother_id; if _flag = 1 then output; end; where birth_num < 3; drop _:; run;

Steelers_In_DC · ‎04-08-2015

This will get you the same thing in a datastep: data tao_want; set tao; retain m_value; by type; if first.type then m_value = value; if m_value > value then m_value = value; run;

Steelers_In_DC · ‎04-08-2015

You can use the min() with sql: proc sql; create table want as select *,min(Mvalue) as min_Mvalue from have group by type order by type;

Steelers_In_DC · ‎04-08-2015

I'm not sure if I'm reading this correctly but I think the error is you don't have set statement: data ilo.demo; set ilo.demo; If gender= " " then sex=.; If gender="male" then sex=1; If gender="female" then sex=2; run; What you probably want to start with is this: data test; set ilo.demo; If gender= " " then sex=.; If gender="male" then sex=1; If gender="female" then sex=2; run;

Steelers_In_DC · ‎04-08-2015

Please give an example of what code you are using that give you an empty dataset. If the data is imported correctly it's subsequent code that is the issue, not the import.

Steelers_In_DC · ‎04-08-2015

try this as a template: ods _all_ close; ods tagsets.ExcelXP path='PATH' file='OUTPUT.xml' style=printer; ods tagsets.ExcelXP options(sheet_name='SHEET NAME ONE' AUTOFILTER = 'ALL'); proc print data=FILE1 noobs; var _all_;run;quit; ods tagsets.ExcelXP options(sheet_name='SHEET NAME TWO' AUTOFILTER = 'ALL'); proc print data=FILE2 noobs; var _all_;run;quit; ods tagsets.ExcelXP close;

Steelers_In_DC · ‎04-08-2015

I have the time right now so I'm taking a guess at what you are looking for. An example of what you are looking for would be helpful. Try this: data have; infile cards; input Year Firm $ Scores; cards; 2005 A 5 2005 B 8 2006 A 7 2006 C 4 2007 A 8 2007 B 10 2007 D 8 2007 E 3 ; run; proc sql; create table prep as select distinct year, sum(scores) as sum_scores from have group by year order by year; data start(drop=l_sum_scores); set prep; by year; l_sum_scores = lag(sum_scores); diff_scores = abs(l_sum_scores - sum_scores); run; proc sql; create table want as select *,mean(diff_scores) as mean_scores from start;

Steelers_In_DC · ‎04-02-2015

I think this is what you are looking for: data have; input Tratamento$ repet Field Result; cards; A_ai 1 1 4 A_ai 1 2 2 A_ai 1 3 2 A_ai 1 4 3 A_ai 1 5 3 A_ai 2 1 3 A_ai 2 2 2 A_ai 2 3 2 A_ai 2 4 4 A_ai 2 5 2 A_ai 3 1 1 A_ai 3 2 1 A_ai 3 3 1 A_ai 3 4 1 A_ai 3 5 1 A_ai 4 1 1 A_ai 4 2 2 A_ai 4 3 1 A_ai 4 4 1 A_ai 4 5 2 A_ai 5 1 2 A_ai 5 2 5 A_ai 5 3 4 A_ai 5 4 2 A_ai 5 5 6 A_ai 6 1 1 A_ai 6 2 1 A_ai 6 3 1 A_ai 6 4 1 A_ai 6 5 1 A_ai 7 1 3 A_ai 7 2 2 A_ai 7 3 2 A_ai 7 4 3 A_ai 7 5 1 A_ai 8 1 2 A_ai 8 2 2 A_ai 8 3 3 A_ai 8 4 4 A_ai 8 5 3 A_ai 9 1 2 A_ai 9 2 1 A_ai 9 3 1 A_ai 9 4 1 A_ai 9 5 2 A_ai 10 1 1 A_ai 10 2 2 A_ai 10 3 1 A_ai 10 4 1 A_ai 10 5 1 ; run; proc transpose data=have out=want(drop=_name_) prefix=field_ ;by Tratamento repet;var field;

Steelers_In_DC · ‎03-31-2015

Try this with the same dataset, depending your resources one could be faster than the other: data want; do while(sum < .9); set have; sum+volume_ratio; output; end; run;

Steelers_In_DC · ‎03-31-2015

I think this is the output you are looking for: data have; infile cards; input product $ customer_name $ volume_ratio; cards; apple customer1 0.278 apple customer2 0.246 apple customer3 0.193 apple customer4 0.190 apple customer5 0.093 ; run; data want; set have; sum+volume_ratio; if sum < round(.9) then output; run;

Online Status	Offline
Date Last Visited	‎07-12-2025 12:12 PM

sql server using 'with'

Re: hive show table and column

hive show table and column

proc sql using or

find edge node

Re: Fill in rows with previous value if next value is the same.

Re: Fill in rows with previous value if next value is the same.

Re: Fill in rows with previous value if next value is the same.

Fill in rows with previous value if next value is the same.

Re: reg ex extract

Re: proc sql using or

Re: Adding quotes to a Macro Variable

Re: How to run a program in EG5.1 without connecting to a server

Re: macro variable in set statements based on today()

Finding all single linked chains: the allChains macro

find edge node

infile 'red x' with no error in log

Re: Extracting Month, Year and quarter

Re: Which Date function can be used to extract month(Character) from t...

Re: How to assign a column value based on another column ??

proc dataset / proc contents

Re: adding a new obs to existing dataset

Re: adding a new obs to existing dataset

Re: How to align contents of column to the right

Re: How to align contents of column to the right

Re: how to retain ordered records

Re: How to assign a column value based on another column ??

Re: How to assign a column value based on another column ??

Re: 0 observations after recoding variables

Re: 0 observations after recoding variables

Re: SAS to generate XML output

Re: Calculating the mean change in scores between dates

Re: PROC TRANSPOSE Doubts and needing some clues

Re: How to get top values that account for 90% of total

Re: How to get top values that account for 90% of total