About Angel_Saenz

Angel_Saenz · ‎02-03-2017

I need to convert date character $CHAR6. to date DATE9. for example EDATE is a var I have, FDATE is a var I want: $CHAR6. DATE9. EDATE FDATE 201001 01JAN2010 201612 01DEC2016 201306 01JUN2013

Angel_Saenz · ‎02-03-2017

Thanks Reeza for example cold you please explain how do this proc sql to proc summary and proc tabulate? PROC SQL; SELECT STATE, STORE, PRODUCT, Count(NSALES) AS SALES FROM BIGSHOP GROUP BY STATE, STORE, PRODUCT; quit; I think if you help me to convert this PROC SQL to proc summary and proc tabulate everything is clear for me and the future.

Angel_Saenz · ‎02-02-2017

I agree with you Reeza you too always help me with my questions, Im just starting to use sas Im newbie sorry if my questions are too basics other problem is that I dont know english very well my lenguage is spanish and is difficult for me ask and explain in english my questions well thank you for your patience, in other way for agroup I have 2 solutions: 1 proc freq 2 proc summary what do you thing is better?

Angel_Saenz · ‎02-02-2017

Hello ballardw you always help me with my questions, I prefer use sas code not proc sql because some process I know how do it with proc sql, but I want to learn how do it with code sas pure

Angel_Saenz · ‎02-02-2017

I have a dataset with duplicates by ID or can be (ID2 ID3) I need two things: 1. one dataset with non-duplicates, for example if 3 obs has ID=1, so the result I want is one dataset just with one obs with ID=1 2. other dataset with all duplicates, for example if 3 obs has ID=1, the result is one dataset with 3 obs with ID=1

Angel_Saenz · ‎02-02-2017

I have a dataset with duplicates by ID I need two things: 1. one dataset with non-duplicates, for example if 3 obs has ID=1, so the result I want is one dataset just with one obs with ID=1 2. other dataset with all duplicates, for example if 3 obs has ID=1, the result is one dataset with 3 obs with ID=1

Angel_Saenz · ‎02-02-2017

thank you Shmuel, I used if not (first.ID and last.ID); but the result was the same original dataset, I need output all duplicates, triplicates etc into another dataset

Angel_Saenz · ‎02-02-2017

Thank you christinakwang I need output all duplicates, triplicates etc into another dataset

Angel_Saenz · ‎02-01-2017

How can I agroup in a summary if i have this obs: STATE STORE SALES AL A 1 AL A 2 AL B 1 AK C 2 AK C 2 AZ D 1 AZ D 1 AZ E 0 AZ E 5 AR F 1 AR F 1 The result I want is: STATE STORE SALES AL A 3 AL B 1 AK C 4 AZ D 2 AZ E 5 AR F 2 (using sas code not proc sql)

Angel_Saenz · ‎02-01-2017

How can I find duplicates obs by one or two variables? (using sas code, not proc sql)

Angel_Saenz · ‎02-01-2017

thank you Reeza I solved that situation

Angel_Saenz · ‎02-01-2017

Thank you Reeza that works very good, just two more questions: 1. like pyments are numeric some obs are nulls so is a . and vector is like .1 .012 and my vector is char, how can I do to my vector is numeric? 2. how can I quit the var _NAME_ in mi dataset result? thank you

Angel_Saenz · ‎01-31-2017

I have 3 dataset with different information date, example: DATASETNAME ID PAYMENTS INFORMATIONDATE DS1 1 0 31Jan2016 DS1 2 1 31Jan2016 DS2 1 2 29Feb2016 DS2 2 1 29Feb2016 DS3 1 1 31Mar2016 DS3 2 1 31Mar2016 I want RESULT: ID PAYMENTDS1 PAYMENTDS2 PAYMENTDS3 VECTOR 1 0 2 1 021 2 1 1 1 111 (using data step, not proc sql if is possible)

Angel_Saenz · ‎01-31-2017

Thank you Ballardw, do you know other way using just sas code? not using proc sql

Angel_Saenz · ‎01-31-2017

How can I obtain IDnumber unique and CostumerNumber if data set is like: Te problem is CostumerNumbe(num) in some information months is missing and in others not. The data set has 600 milllons of obs. Idnumber(char) CostumerNumbe(num) INFORMATION DATE 100 . 31May2013 100 1234 30Jun2013 100 . 31Jul2013 100 1234 31Aug2013 100 . 30Sep2013 100 . 31Oct2013 100 1234 30Nov2013 100 1234 31Dec2013 100 1234 31Jan2014 100 . 28Feb2014 101 . 31May2013 101 6754 30Jun2013 101 6754 31Jul2013 101 . 31Aug2013 101 6754 30Sep2013 101 . 31Oct2013 101 6754 30Nov2013 101 . 31Dec2013 101 6754 31Jan2014 101 . 28Feb2014 The result I want is: Idnumber(char) CostumerNumbe(num) 100 1234 101 6754

Online Status	Offline
Date Last Visited	‎09-12-2022 03:25 PM

Re: index unique in more than one var

Re: index unique in more than one var

index unique in more than one var

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Easy way to comvert ds1 to ds2

proc freq like group by

List of all datasets in a library showing number of observations of ea...

round tens

All datasets of a library with access permission

Re: index unique in more than one var

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Re: proc freq like group by

Convert date character $CHAR6. to date DATE9.

Re: agroup and summary (using sas code not proc sql)

Re: agroup and summary (using sas code not proc sql)

Re: agroup and summary (using sas code not proc sql)

Re: finding duplicates obs (using sas code)

Re: finding duplicates obs (using sas code)

Re: finding duplicates obs (using sas code)

Re: finding duplicates obs (using sas code)

agroup and summary (using sas code not proc sql)

finding duplicates obs (using sas code)

Re: obtain vector with 3 var (using data step, not proc sql if is poss...

Re: obtain vector with 3 var (using data step, not proc sql if is poss...

obtain vector with 3 var (using data step, not proc sql if is possible...

Re: Obtain to IDnumber unique and CostumerNumber

Obtain to IDnumber unique and CostumerNumber