About itshere

itshere · ‎10-14-2016

This is how my data looks: (sample) year Month Account Pass/Fail 2016 2 44402 1 2016 2 99921 0 2016 4 11233 1 proc sql; create table test1 as select year, month, sum(passfail=1)as pass, sum(passfail=0)as fail, Count(*) as count From testorg group by year, month, pass,fail quit; Doesnt work tho.. am i not able to add new columns and do a group by in the same query?

itshere · ‎10-14-2016

total number of records for account numbers. pass and fail is currently in one column as 1 or 0. need to separate it.

itshere · ‎10-13-2016

Hi All - I have the following columns: MONTHS, YEAR, ACCOUNT NUMBERS and SCORE Im using Proc sql; I need a table that will do a group by that will give me all the months ( as one column), amount of accounts for that months and SEPARATE the score with PASS and FAIL ( so 2 separate columns for SCORE) thus need to sum up all the pass and/ fails and create its own columns So I will see all the accounts for say january and all the pass and fails for those accounts in jan. THANK YOU!

itshere · ‎10-13-2016

So I did this and it worked but the results showed as MONTH column and the rows were 1-9. What does that mean? My dates vary from 2015 to 2016. I need to capture only 2016 and would need it to say Jan, feb, etc, for just 2016.. how do i include it to say Jan 2016, feb 2016, etc proc sql; create table months as select Month(datepart(purchase_time) as month, Count(*) as count From workbook1 where model = "Nissan" group by month, model; quit;

itshere · ‎10-13-2016

How do i tell Sas to categorize all January dates form 1 to 31 as JANUARY.. and so on for the other months..

itshere · ‎10-13-2016

just coding, creating a query to extract from an already existing table.

itshere · ‎10-13-2016

Hi. I have a dates in the following format. 01JAN2016:12:00:00 (datetime21) In my example I have 2 columns. One with dates and the other one with Car Models. I need to find out all the Nissans that were purchases in Jan, Feb, March, etc ( for the entire year). separated by month. Using PROC SQL; how do i create a query to give me an output that will show Column 1: Months Column 2: Car_Models Table: January 50 February 80 etc. Thanks!1

itshere · ‎09-23-2016

Hi - PLEASE HELP! my Date1 column is in the following format "2012-01-25 12:44:44.0" - [ FORMAT $28 ] and I need to convert it to 25JAN2012:00:00:00 - [ FORMAT DATETIME20] THANK You!!!!

itshere · ‎08-11-2016

Hi - using proc sql; Im trying to make a query that says, if the call happened within 7 days after the case creation then add a 1, otherwise 0 and if the call happened within 31 days after the case creation add a 1, otherwise 0. the date is in the following format 01MAY2016 11:10:00 (datetime20) both case and call. this is my formula currently but it didnt work correct. proc sql; create table test.rock as select A.*, (case when datepart( A.call)>datepart(a.case)+7 then 1 else 0 end) as call_in_7days, (case when datepart( A.call)>datepart(a.case )+31 then 1 else 0 end) as call_in_31days from test.paper A ; but the results were incorrect. please advise if my logic is incorrect.

itshere · ‎07-25-2016

I forgot to mention Im using PROC SQL So i need something that is supported by that.

itshere · ‎07-25-2016

Hello - I currently have 2016-01-01 in my data.. its format is text,20. I want to join it with another table that i have and its format is 01JAN2016 00:00:00 How do I first convert the text DATE into number DATE and then in the correct format to join on this ^ I initially did Input(A.int_date, datetime20.) but it made all the rows blank. Any ideas? Thanks!

itshere · ‎07-19-2016

Hi - I have a table that has an start date and an end date and need to see if a call was made on the start date or the end date. this is my current query but it does not work. rsubmit; proc sql; create table test.field1 as select A.*, B.* from test.rock A left join test.paper B on A.account = B.account and A.start_date = B.call_date or A.end_date = B.call_date ; endrsubmit; So ideally i want to get a table that shows me all the interactions I got that matched the start date and end date WITH the call_date(different table) **the interactions are linked to Call_date which is a different table. This is the error i got... NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized. ERROR: A lock is not available for test.field ERROR: Lock held by process 5229800

itshere · ‎07-19-2016

right now i just have proc sql; create table test1.discovery select A.field, A. region input(A.date1,12.0) as from test1.location ; i tried this before but didnt work... datepart(input(A.date1,12.0))

itshere · ‎07-19-2016

where would i put the datetime20.. what would be the query? I import manually.. so i go to file -> Import data -> etc.

itshere · ‎07-18-2016

Hi - I imported a file into SAS and some columns were converted into number format while others into text? why is that? how do i ensure that columns are imported the way I wanted? is there a way? Im using PROC SQL.. one of my columns that is in a TEXT format is a date 15JUL2016:00:00:00 I want to change it to a date9 format but its not letting me because its in text so I tried to do input(act_date,12.0) but when i opened the new table that column was ALL blank so the input did not work? How do i convert it to a number so i can do the date9 after? Thank you very much!

Online Status	Offline
Date Last Visited	‎10-14-2016 12:39 PM

Re: Group by and create new column

Re: Group by and create new column

Group by and create new column

Re: Count on multiple dates! Help.

Re: Count on multiple dates! Help.

Re: Count on multiple dates! Help.

Count on multiple dates! Help.

Converting Dates SAS PROC SQL

Case Statement logic

Re: Covert date text to number text

Re: Count on multiple dates! Help.

Re: Count on multiple dates! Help.

Re: Count on multiple dates! Help.

Re: Converting Dates SAS PROC SQL

Re: Linking two tables with multiple rules

Re: Group by and create new column

Re: Group by and create new column

Group by and create new column

Re: Count on multiple dates! Help.

Re: Count on multiple dates! Help.

Re: Count on multiple dates! Help.

Count on multiple dates! Help.

Converting Dates SAS PROC SQL

Case Statement logic

Re: Covert date text to number text

Covert date text to number text

Linking two tables with multiple rules

Re: Text to Number (Dates)

Re: Text to Number (Dates)

Text to Number (Dates)