About Mattress58

Mattress58 · ‎02-10-2016

how can I get these on the same row to look like this Region Vehicle year1 color1 year2 color 2 South impala 2014 blue 2015 black Region Vehicle year1 color1 year2 color 2 South impala 2014 blue South impala 2015 black

Mattress58 · ‎12-03-2015

I came up with this ,case when ci_month between INTNX('MONTH',TODAY(),0,'B') and INTNX('MONTH',TODAY(),0,'E') then 1 when ci_month between INTNX('MONTH',TODAY(),1,'B') and INTNX('MONTH',TODAY(),1,'E') then 2 when ci_month between INTNX('MONTH',TODAY(),2,'B') and INTNX('MONTH',TODAY(),2,'E') then 3 when ci_month between INTNX('MONTH',TODAY(),3,'B') and INTNX('MONTH',TODAY(),3,'E') then 4 when ci_month between INTNX('MONTH',TODAY(),4,'B') and INTNX('MONTH',TODAY(),4,'E') then 5 when ci_month between INTNX('MONTH',TODAY(),5,'B') and INTNX('MONTH',TODAY(),5,'E') then 6 else 0 end as mth_lst

Mattress58 · ‎12-03-2015

How can I create add a column and if the ci_month date below is in this month then put a 0 and if it is in next month put a 1 and call the column W_Month proc sql; create table report5 AS SELECT ci_month from mydata ; quit; example if today's date is 12/3/2015 and ci_month 20423 (which is 12/1/2015) then W_Month would be 1. If ci_month was 20454 (which is 1/1/2016) then W_Month would be 2.

Mattress58 · ‎12-02-2015

How can I compare two columns to get which one is first alphabetically? I want to put which is first in a 3rd column. Example: Column1 = Kelly Column2 = Katie Column3 would be Katie because it is first alphabetically. dataset = Rentals

Mattress58 · ‎12-02-2015

Data set = mydata I need to compare column1 and column2 and create a column3 that gives me which comes first alphabetically. Example: Column1 = San Francisco Column2 = San Diago Column3 would = San Diago becaue San Diago comes before San Francisco alphabetically. How can I dio this?

Mattress58 · ‎08-27-2015

Thank you both for the help.

Mattress58 · ‎08-27-2015

I created a table named rentals. This is what it pulls back. ScoreX WeightX 1 10 0 23 0 45 4 20 2 20 1 5 1 5 I need to come up with the result being Score 3 Which is a formula of (sum All weightX wher scoreX not = to 0) / (sum All weightx where score = to 1) so 60/20 How can I do this?

Online Status	Offline
Date Last Visited	‎02-11-2016 07:35 AM

combine rows where one row has null value

Re: If date is in this month or not

If date is in this month or not

Compare two columns first alphabetically?

Comparing Two strings

Re: Sum up with

Sum up with

Compare two columns first alphabetically?

combine rows where one row has null value

Re: If date is in this month or not

If date is in this month or not

Compare two columns first alphabetically?

Comparing Two strings

Re: Sum up with

Sum up with