About Steelers_In_DC

Steelers_In_DC · ‎07-30-2015

What is it that you are trying to achieve?

Steelers_In_DC · ‎07-30-2015

RW9, I'm a beginner at arrays. I ran what you have and get the following error. Can you assist? 22 GOPTIONS ACCESSIBLE; 23 data want2 (drop=i); 24 set have; 25 array var{*}; ERROR: The array var has been defined with zero elements. 26 count_miss=0; 27 do i=1 to dim(var); 28 if var{i}=0 then count_miss=sum(count_miss,1); ERROR: Too many array subscripts specified for array var. 29 end; 30 run;

Steelers_In_DC · ‎07-30-2015

I'm sure there will be some good array solutions, but this is the first thing that came to mind. If it is only a handful of variables it's a viable solution. data have; infile cards dsd; input Client Var1 Var2; cards; 1,245,2699 2,0,0 3,3694,0 4,1548,0 5,0,3554 ; run; data want; set have; count = sum((var1 ne 0)+(var2 ne 0)); run;

Steelers_In_DC · ‎07-30-2015

I'm assuming there is a lot more that goes along with this. Here is a solution for you, but based on any other nuances to the data or size of data there is a chance there is a much better solution: data have; infile cards dsd; input var1$ var2$ var3 var4; cards; A,,32,12 B,,25,14 ,C,,18 ,D,15,13 ; run; data want; set have; if not missing(var1) then var12 = var1; if not missing(var2) then var12 = var2; drop var1 var2; run;

Steelers_In_DC · ‎07-30-2015

Do you need the MMM to be in a date format? I tried using monname. and month. as formats but it is not working for me. If you use this code it will be a character and not a date. Also, I changed yearmonth to monthyear but I do not see a problem with the way it was formatted before. Run this and let me know: data want; format monthyear monyy7.; set have; _datepart = datepart(invoice_date); monthyear = _datepart; year = year(_datepart); quarter = qtr(_datepart); month = substr(input(put(monthyear,monyy7.),$7.),1,3); drop _:; run;

Steelers_In_DC · ‎07-30-2015

Here's a solution for you: data have; infile cards dsd dlm= '*'; informat var1 $2. var2 comma. var3 percent. var4 comma. var5 percent.; input Var1 Var2 Var3 Var4 Var5; cards; AA*19,176*48.4%*20,001*49.6% AS*9,717*24.5%*9,609*23.8% BA*8,694*21.9%*8,891*22% BB*2,032*5,1%*1,849*4.6% ; run; proc transpose data=have out=tran;id var1;var var2 var3 var4 var5; data prep; set tran; sum = sum(aa,as,ba,bb); run; proc transpose data=prep out=want (rename=(_NAME_ = var1));id _name_;var sum aa as ba bb;

Steelers_In_DC · ‎07-30-2015

Here you go: data have; infile cards dsd; informat Name $2. Invoice_Date ymddttm16.; format Name $2. Invoice_Date datetime.; input Name Invoice_Date; cards; A,2014-02-12 20:12 B,2014-04-01 19:00 D,2014-05-03 23:31 E,2014-07-29 17:10 R,2014-09-15 10:31 F,2015-03-10 12:12 G,2015-06-02 21:18 GF,2015-06-09 10:13 DF,2015-06-27 15:11 ; run; data want; format yearmonth monyy7.; set have; year = year(datepart(Invoice_Date)); month = month(datepart(Invoice_Date)); yearmonth = datepart(Invoice_Date); quarter = qtr(datepart(Invoice_Date)); run;

Steelers_In_DC · ‎07-30-2015

It seems like you have the solution to me so I might be missing the question. You can use the 'd' modifier to remove all digits from any string. Run this and let me know if this helps: data have; infile cards dsd; format outcome_notes notes $50.; input outcome_notes notes; cards; 123456987987631asdfwerewer,3asd1af6er6da1f adsfadfgsgdrf3216587987adsfaesr,ad3s21fa6we4 asdfaer53467asdf354aew6r8,adsfaser32164648 aerraqewf1165a98s7er,32165a4serasdfas asdfawe6r54251,asdrfawe321a65sd46d321 awerwedf1216476,adsfae32146546 awered32165849684165tgre,adsf321654er ; run; /*I prefer to use a new variable to maintain the original but you don't have to*/ data want; set have; /*new_ will maintain the original column*/ new_outcome_notes = compress(outcome_notes,1,'d'); new_notes = compress(notes,1,'d'); /*using the same name will overwrite the original with the desired*/ outcome_notes = compress(outcome_notes,1,'d'); notes = compress(notes,1,'d'); run;

Steelers_In_DC · ‎07-30-2015

Here you go: data have; format datetime datetime.; datetime = today(); run; data want; set have; date = datepart(datetime); hour = hour(datetime); min = minute(datetime); sec = second(datetime); run;

Steelers_In_DC · ‎07-29-2015

Yup, that's what happens when I do two things at once and don't test.

Steelers_In_DC · ‎07-29-2015

I don't come up with the same numbers that you do but here is a solution, there's probably a neater way to do this with proc summary but I'm not too experienced with it: Data have; infile cards dsd; length County_FIPS $5. Survey_Question $11.; input County_FIPS$ Survey_Question$; cards; 22001,1 (yes) 22001,1 (yes) 22001,2 (no) 22001,1 (yes) 22003,9 (refused) 22003,1 (yes) 22003,1 (yes) 22005,1 (yes) 22005,2 (no) ; proc sql; create table want as select county_fips,count(survey_question)/counts as percent_no from (select county_fips,survey_question,count(survey_question) as counts from have group by county_fips) where survey_question contains 'no' group by county_fips; If you want to count refused you can change 'contains 'no'' to 'not contains 'yes'' but it's 33%, not 67%. Hope this helps. Edit: proc sql; create table want as select county_fips,count(survey_question)/counts as Percent_No format = percent. from (select county_fips,survey_question,count(survey_question) as counts from have group by county_fips) where survey_question not contains 'yes' group by county_fips; Message was edited by: Mark Johnson

Steelers_In_DC · ‎07-29-2015

where not(missing) categ_var and categ_var not like '%B%';

Steelers_In_DC · ‎07-29-2015

Here you go: Data have1; infile cards dsd; input customer$ start_date end_date; cards; 123abd,20140830,20150120 456efg,20130101,20140421 ; data have2; infile cards dsd; input customer$ process_date; cards; 123abd,20140831 123abd,20140829 456efg,20130102 456efg,20120101 ; proc sql; create table want as select distinct a.customer, a.start_date, b.process_date, a.end_date from have1 a inner join have2 b on a.customer = b.customer and a.start_date < b.process_date < a.end_date;

Steelers_In_DC · ‎07-29-2015

If you are only concerned with consecutive records this will work: Data have; input y $ @@; datalines ; mostthat morethis morethis morelike mostlike morelike morelike morelike mostlike ; run; data want; set have; l_y = lag(y); if l_y = y then flag = 'Same'; else flag = 'Diff'; drop l_y; run;

Steelers_In_DC · ‎07-29-2015

Do you have an id number of some kind? If so I'd make sure it was sorted like this, that'll make sure all of your dates are in the right place.: data have; infile cards dsd; informat date date9.; format date date9.; input ID$ date; cards; 1,12NOV2013 1, 1, 2,13NOV2013 2, 2, 3,14NOV2013 3, 3, ; proc sort data=have;by id descending date; data want; set have; by id descending date; retain _date; if first.id then _date = date; if missing(date) then date = _date; drop _:; 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 ??

Re: Wrong Missing Value Problem

Re: Count the number of non-zero occurrences for a variable

Re: Count the number of non-zero occurrences for a variable

Re: Combine two rows into one

Re: Extracting Month, Year and quarter

Re: Adding new column

Re: Extracting Month, Year and quarter

Re: Remove numeric values from a number of fields

Re: Splitting Time

Re: proc sql like operator filtering missing values

Re: Summarizing and Manipulating Data

Re: proc sql like operator filtering missing values

Re: Help with look up customer data in transaction history file.

Re: compare character values in consecutive rows

Re: Variable values