About tazz_bh

tazz_bh · ‎11-16-2021

Hello everyone! Is it possible to automate the SAS package export process? I have been exporting my jobs one by one (since I want each job to be in a separate package) through the Export SAS Package Wizard. I use this method to secure backup of some of the most important jobs. However, as the number of folders and Jobs increase, it becomes more difficult to manage this entire export process and so I would like to know if there is any way to make this export automatically, even if I have to create a parameter table, for example, pointing out which folders I would like to export.

tazz_bh · ‎05-11-2021

How can I use lag over partition by in proc sql? PROC SQL; CREATE TABLE WANT AS select t1.account_id from (select h1.account_id, lag(ACCOUNT_STATUS) over (partition by account_id order by ACCOUNT_CHANGE_DATE) as prev_status from HAVE h1 ) t1 where prev_status NOT = 'B1' and ACCOUNT_STATUS = 'B1' and account_change_date >= '1Dec2020'd and account_change_date < '1Jan2021'd; QUIT; Thank you!

tazz_bh · ‎04-27-2021

I am trying to send email via Data Integration Studio if I have a specific condition, as follows: My condition is that if my situation variable, which comes from &_INPUT is = 'true', I send the email, if not, the program ends. However, the following code sends the email even if the sitution is = 'false' or any other string. What am I missing? data _null_; set &_INPUT; if situation ='true' then call symput('message','this is my message'); run; filename mymail email ("mymail@xxx.com") subject='This is my subject'; data _null_; file mymail; put "&message"; run;

tazz_bh · ‎03-25-2021

I am trying to mix a code since there is no GUI to do what I need.

tazz_bh · ‎03-25-2021

I have this diagram: With this data: And I wall I want is to put NYC and LAX in a single field. In this example I have only two cities, but at any given moment I can have several other cities, so I need a code that is malleable enough to concatenate all cities rows, regardless of the number of cities I have in this column. Should I use a User Written code to do so?

tazz_bh · ‎03-25-2021

I transposed rows to columns. I can also do catx () for all rows, but it follows the same logic: The column number (cities) will be fixed at 1, but the number of rows will be unknown, so CATX would have to be made for an unknown number of rows. Do you think it's easier that way?

tazz_bh · ‎03-25-2021

The objective is to join all the observations in Table 1 in a single column and all the observations in Table 2 in a single column, so that each of these two tables has only one column. The columns in Tables 1 and 2 are created automatically if there is data in my source table. That is, if there are 30 cities, col 1 to col 30 are created automatically. If there are only 3 cities, only col 1 to col 3 will be created. And this same logic is used for the state table (table 2). The point is that the number of columns that tables 1 and 2 have can be different each time I run my job. Since cities and states can be inserted or excluded from my source table.

tazz_bh · ‎03-25-2021

The columns in Tables 1 and 2 are created automatically if there is data in my source table. That is, if there are 30 cities, col 1 to col 30 are created automatically. If there are only 3 cities, only col 1 to col 3 will be created. And this same logic is used for the state table (table 2)

tazz_bh · ‎03-25-2021

would like to combine data from multiple cells into one cell using SAS Data Integration Studio. My data is divided into three different tables, as follows: Table 1 (Number of columns is unknown) Col 1 Col 2 Col 3 City A City B City C Table 2 (Number of columns is unknown) Col 1 Col 2 Col 3 State A State B State C Table 3 Variable 1 Variable 2 x y Desired final table: That is, I want to create a final table in which I can join the data from table 1 (Number of columns is unknown) in just one field and the data from table 2 (Number of columns is also unknown) in another field, separating the respective values with a comma. Variable 1 Variable 2 States Cities x y State A, State B, State C City A, City B, City C Can someone help me with the code so I can count columns and then CATX () without having to do mappings, since I don't know how many columns I will have? In addition, the next time I run the job, some city may have left the list, which reduces my number of columns.

Online Status	Offline
Date Last Visited	‎11-16-2021 02:20 PM

Is it possible to automate the SAS package export process?

LAG over partition by in a PROC SQL?

Error seding email using SAS Data Integration Studio

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

How to combine data from multiple cells into one cell

Re: LAG over partition by in a PROC SQL?

Re: LAG over partition by in a PROC SQL?

Re: LAG over partition by in a PROC SQL?

Is it possible to automate the SAS package export process?

LAG over partition by in a PROC SQL?

Error seding email using SAS Data Integration Studio

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

Re: How to combine data from multiple cells into one cell

How to combine data from multiple cells into one cell