About nicnad

nicnad · ‎02-28-2013

One last thing, how do I add the numbre of elements in variable source? Thank you for your help.

nicnad · ‎02-28-2013

Thank you very much for the explanation. This works perfectly.

nicnad · ‎02-28-2013

Thank you very much for your quick reply. This works perfectly. Just to clarify, when you say as long as my data is already grouped by name did you mean sorted by name? Also, I think the date in my real table is not formated properly because I get the following error in the put statement : Format $YYMMDD was not found or could not be loaded. How do I fix this error? Thank you for your help and time.

nicnad · ‎02-28-2013

Hi, Lets say I have the following table : Name Date Source Bob 2012-01-01 test1 Bob 2012-01-02 test1 Bob 2012-01-03 test2 Alex 2012-02-02 test5 Alex 2012-02-03 test5 What is the SAS procedure to obtain the following table : Name Source Bob test1 - 2012-01-01, test1 - 2012-01-02, test2 - 2012-01-03 Alex test5 - 2012-02-02, test5 2012-02-03 To be more specific, I want to concatenate source & " - " & date and for each concatenated sources and date, I want to separate them with ", ". Is this something that can be done in SAS? Thank you for your help and time.

nicnad · ‎02-28-2013

Thank you all for your replies!

nicnad · ‎02-27-2013

This is exactly what I needed it works great. One thing is that I am using the set procedure on 10 different table. Is there an another then writing 10 if statements? Can I just state something like source_table = in? Also I see that the length of my variable source_table is set to 5 (with the first value being test1 I guess) so when afterwards I use a longer string it is truncated to 5 chars only. How do I solve this% Thank you very much for your help and time.

nicnad · ‎02-27-2013

Reeza thank you very much for this quick reply. The set and keep procedure work well. The only thing is that I am not able to make the part in bold work. data want; set mylib.test1 (keep=name date) mylib.test2 (keep=name date) indsname=source; ERROR 22-322: Syntax error, expecting one of the following: END, KEY, KEYS, NOBS, POINT. ERROR 76-322: Syntax error, statement will be ignored. source_table=source; run; The error points on the equal sign between indsname=source

nicnad · ‎02-27-2013

Hi Lets say I have the two following table : Table : mylib.Test1 Name Date Var1 Var2 John 2012-01-01 aaa bbb Bob 2012-01-02 eee ccc Peter 2012-01-03 ffff ddd Table : Mylib.test2 Name Date Var9 Bob 2012-01-04 ttt Fred 2012-01-05 yyy Will 2012-01-05 vvv I want to merge the two tables, so that I have all the names, dates, and the source table dates (and if name should be repeated, have the multiple entries) like this : Name Date Source_Table John 2012-01-01 test1 Bob 2012-01-02 test1 Peter 2012-01-03 test1 Bob 2012-01-04 test2 Fred 2012-01-05 test2 Will 2012-01-05 test2 Thank you very much for your help and time.

nicnad · ‎02-20-2013

Thank you very much for the precision. Best regards.

nicnad · ‎02-20-2013

Thank you very much for the reply. Exactly what I needed.

nicnad · ‎02-20-2013

Thank you very much for the quick reply. This is exactly what I was looking for. Where can I find each argument I can put in a proc print statement?

nicnad · ‎02-19-2013

Hi, I have the following descriptive statitics that I run on the variable Calculation1 in SAS EG 4.1 : /* ------------------------------------------------------------------- Code généré par une tâche SAS Généré le : 19 février 2013 à 17:50:32 Par tâche : Statistiques descriptives Données en entrée : SASUSER.QUERY_FOR_QUERY1_FOR_PPVS_SCEN3 Serveur : SASMain ------------------------------------------------------------------- */ PROC SQL; %_SASTASK_DROPDS(WORK.SORTTempTableSorted); QUIT; /* ------------------------------------------------------------------- Il est inutile de trier la table SASUSER.QUERY_FOR_QUERY1_FOR_PPVS_SCEN3. ------------------------------------------------------------------- */ PROC SQL; CREATE VIEW WORK.SORTTempTableSorted AS SELECT Calculation1 FROM SASUSER.QUERY_FOR_QUERY1_FOR_PPVS_SCEN3; QUIT; /* ------------------------------------------------------------------- Exécuter la procédure Means ------------------------------------------------------------------- */ TITLE; TITLE1 "Statistiques descriptives"; TITLE2 "Résultats"; FOOTNOTE; FOOTNOTE1 "Généré par le Système SAS (&_SASSERVERNAME, &SYSSCPL) le %SYSFUNC(DATE(), FRADFDE9.) à %SYSFUNC(TIME(), TIME6.)"; PROC MEANS DATA=WORK.SORTTempTableSorted FW=12 PRINTALLTYPES CHARTYPE VARDEF=DF MEAN STD MIN MAX N ; VAR Calculation1; RUN; /* ------------------------------------------------------------------- Fin du code de la tâche. ------------------------------------------------------------------- */ RUN; QUIT; PROC SQL; %_SASTASK_DROPDS(WORK.SORTTempTableSorted); QUIT; TITLE; FOOTNOTE; I then create an sql table using the following code : PROC SQL; CREATE TABLE SASUSER.FINAL AS SELECT QUERY_FOR_QUERY1_FOR_PPVS_SCEN3.CUSTOMER_ID, WHERE QUERY_FOR_QUERY1_FOR_PPVS_SCEN3.Calculation1 >= 5.1554977; /* THIS NUMBER IS THE MEAN PLUS TWO TIMES THE STD DEVIATION */ QUIT; In fact, I want to calculate the mean and std dev for all the records of variable Calculation1 in table QUERY_FOR_QUERY1_FOR_PPVS_SCEN3 and use this value as a filter in my proc sql. How do I do that automatically (having a dynamic variable)? Thank you for your help and time.

nicnad · ‎02-19-2013

Hi, I often use proc print data procedure to summarize variable like this proc print data = test.mytest; sum nb_total Mt_Total_CAD; run; How can I set my preference in terms of format? Here is what I would like the output to look like : Font: Calibri, 11 pt, no spacing before of after the characters How do I do that? Thank you for your help and time

nicnad · ‎02-14-2013

Yes, I tought there was maybe an option that I wasn't aware of, but I guess we are limited to displaying 9 chars. Thank you for your quick reply.

nicnad · ‎02-14-2013

Hi, I am using SAS EG 4.1. I was wondering if there is a way to display the full names of tables and code in the process flow view. As of right now, each icon name is restricted to 9 characters. I would like to have the full name displayed with no limit regarding the number of characters. Is this something that can be done? Thank you for your help and time!

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Missing values in addition or substraction generate error

Re: Count occurence of each word in a table

Re: Count occurence of each word in a table

Count occurence of each word in a table

Re: Select at least one item per category radomly, with a minimum % of...

Re: Select at least one item per category radomly, with a minimum % of...

Re: Select at least one item per category radomly, with a minimum % of...

Select at least one item per category radomly, with a minimum % of the...

Re: Conditional Count

Re: Conditional Count

Re: Macro to count the number of records

Re: Macro to count the number of records

Re: SAS EG 4.1 - Process flow icon name display

Re: Select records that contains variable from another table

Re: Set SAS tableset with # in table name

Re: Group by a variable and concatenate another variable

Re: Group by a variable and concatenate another variable

Re: Group by a variable and concatenate another variable

Group by a variable and concatenate another variable

Re: Merge two variables from two tables

Re: Merge two variables from two tables

Re: Merge two variables from two tables

Merge two variables from two tables

Re: proc print data format preferences

Re: Use descriptives statistics values in a sql table filter

Re: proc print data format preferences

Use descriptives statistics values in a sql table filter

proc print data format preferences

Re: SAS EG 4.1 - Process flow icon name display

SAS EG 4.1 - Process flow icon name display