About act_nico_ven

act_nico_ven · ‎07-25-2016

WHOOOOHUU, Thank you so much @Tom , works perfectly, But, How works that Loop?? hahaha please!!, I don't understand the conditions in the WHERE statement,

act_nico_ven · ‎07-25-2016

@Tom Exactly my friend, i really needed that drawing hehehe, My original data is generated in a PROC SQL. The Data Step is a option, but i really wish make a column into the PROC SQL code, it sound imposible, right? hahaha

act_nico_ven · ‎07-25-2016

Hi @Tom , I did not know that RETAIN statement, it is very usefull, thanks! In my third post, I placed a second text file, more real to my data, The idea, more or less; it is search the NumS_Com info in the NumS column, if find the NumS_Com then i need look for my PRINCIPAL NumS associated, THAT "NumS" has the "-" character. Sorry for the BAD drawing hahaha, Sees the relation each the rows, the other values are complementary to "1-1-598". "1-1-598" is my PRINCIPAL value associted to "-" character. IMPORTANT: I can not sort.

act_nico_ven · ‎07-23-2016

Hi @ballardw, thank you for prompt response, I´m very newbie with SAS code and i did not see that little mistake in the example data, sorry! Not necessarily the last two digits are equal or cero value, The PRINCIPAL it is the "NumS" that i really need to group by the example data in three row, of course, the idea is assign that PRINCIPAL´ number to each complementary row. Attachment example corrected.

act_nico_ven · ‎07-21-2016

Sorry my friend @ballardw !! I modified the post already!!

act_nico_ven · ‎07-21-2016

Hi everyone, I have a problem to create a column with a formula that allow me group by the field named OBJECTIVE in the attachment example. The "NumS_Com" column represents a complementary information of the "NumS" column, when "NumS_Com" is equal to "-" character means that "NumS" value is like a PRINCIPAL registry, and when "NumS_Com" it is equal to registry in the "NumS" row above represents the complementary information. I need a column with the PRINCIPAL register as in the field named OBJECTIVE on the example. I would like to achieve the result shown in the column entitled OBJECTIVE, Could you help me please!? Thanks in advance!

Online Status	Offline
Date Last Visited	‎08-10-2016 01:36 PM

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Re: Create a new column in DataSet with a Macro - PROC SQL

Create a new column in DataSet with a Macro - PROC SQL