About fabdu92

fabdu92 · ‎02-10-2017

Hi, I have two tables A and B In table A I have only one row with an undetermined number of column. In my table B I have two columns ID, VALUE with 0 rows. I would like to insert three rows for each of the A column The ID would be 1, 2, and 3. The VALUE would be equal to each value of the first (and only row) of table A. Exemple My table A is like this: Col1 Col2 Col3 Col4 ... ZZS KJP UOI RJS ... My table B should be something like ID VALUE 1 ZZS 2 ZZS 3 ZZS 1 KJP 2 KJP 3 KJP 1 UOI 2 UOI 3 UOI 1 RJS 2 RJS 3 RJS ... As I am a crap in SAS macro I have truly no idea of how to do it...Can you help me? Thanks

fabdu92 · ‎02-10-2017

Thanks Kurt, it is indeed working. Have a good day

fabdu92 · ‎02-10-2017

Hi, I try to do something very easy: I have a global variable c and a SAS table A. This is working: data WORK.B; set WORK.A (firstobs= 2 obs= &c.); run; This is not... data WORK.B; set WORK.A (firstobs= 2 obs= &c.-1); run; Isn't it possible to do it without creating another new variable?? Thanks for reply

fabdu92 · ‎01-20-2017

Great, Thank you Kurt!

fabdu92 · ‎01-20-2017

Hi, I have this kind of proc sql PROC SQL; CREATE TABLE B1 AS SELECT A AS TYPE, B AS AMOUNT FROM WORK.A1; QUIT; RUN; I would like to cast B in integer. For now it's a varchar. And I would like to do it inside this proc sql if possible. Is it possible? Thanks for answers

fabdu92 · ‎01-12-2017

If it was that easy I would do it. 🙂 But the provider send the file in pdf, and I can't ask him to modify that... And it should be imported in a data set automatically so...I can't manually modify it in txt. No solutions? 😞 Even difficult one?

fabdu92 · ‎01-12-2017

Hi all, It's difficult to google this: the results are all pdf file, treating about proc import with excel or csv... I wouldl ike to impoirt pdf file into a sas dataset. Do you know how to do it? Thanks for answers

fabdu92 · ‎11-23-2016

Hi all, As you know, Excel is limited by its number of rows. According to this, I have a user requirement telling that: "The maximum number of records is 1.048,576 rows" I have to export a table in an Excel sheet with famous PROC EXPORT I want to perform this requirement by exporting the table in the Excel sheet if the number of rows is less, or else displaying a error in the Excel sheet telling something like "Too much data: the number of records is N", and replace N by the number. But honestly, I am not an expert in SAS, even more a beginner than expert so I really don't know if there is a way to do it. Can you help me? Thanks

fabdu92 · ‎08-02-2016

Hi, I have an issue with some numbers which represent amounts while exporting in Excel like this: proc export data=INF_SUM outfile="/data/appli/file/ggg.xls" dbms=xls replace; sheet="catalog"; run; In my sas table INF_SUM I have amounts like for example "43.87" whereas on ggg.xls it is transformed like "43.86895", which don't represent an amount anymore if you don't manually ask Excel to transform the column concerned. Do you know I can do to keep formats? I work with Excel 2010 and SAS Enterprise Guide 7.1 Thank you for help

fabdu92 · ‎07-20-2016

Hi, I have a table A and I want to duplicate each row into a table B, N times. In table A Ifor each row have: a date d In table B i would like: the date d + 1 month for each new row a number m, calculated according to new date So I do something like data B; set A; do i=0 to N; d = INTNX('month', d, +1, 'e'); m =...; output; end; run; But the issue with this, is that the original record from A is deleted and we have only date d+1 to d+n and no longer d. I would like the programm to understand it need to keep the initial date too, and to calculate for this date the number m Can you help me? Thank you very much

fabdu92 · ‎06-29-2016

Hi, Sorry for the simple question, I am quite new on SAS EG. I created a process with one prompt, and a lot of Query Builder tasks. The path of the process is linear (one path), until a node followed by two paths: two distinct tasks. The two paths are finally joined for the process ending. Following the choice of the prompt, I would like only one path run. Of course I can modify all Query Builder by SAS EG programs and say: if &prompt = A then execute a macro But I would to do it only once at the beginning of the path, and that SAS EG understand it has to not run anytthing on the path. I am sure there is a way to do it. Can you help me on this? Thank you very much

fabdu92 · ‎06-28-2016

Hey Reeza, I've tried differently but always the same problem... When I put PM, I have the result expected, that means "31MAY2016" Now I have calculated on the previous task a new data: *DT_END which is equals to INTNX('month', INITIAL_DATE, + DURATION , 'e') This is working. So on my filter I do: WHERE %_eg_WhereParam( DT_END, PM, GE, TYPE=D, IS_EXPLICIT=0 ); And still with this, it's like I have not written this filter...It output all rows not only those where DT_END >= PM

fabdu92 · ‎06-27-2016

Thank you for your answer but yo misunderstood: My prompt is PM, Initial_date and duration are data gotten from a previous task.

fabdu92 · ‎06-24-2016

Hi, I am stuck on an issue when I try to write a filter. The program doesn't log me errors, but the filter is not taken into account. I have 3 data: # one date prompt named "pm" # one date named "initial_date" # one number named "duration" I want to select only rows where the end of the month of initial_date+duration (months) >= pm The filter I wrote is this one: WHERE %_eg_WhereParam( INTNX('month', INITIAL_DATE, + DURATION , 'e'), PM, GE, TYPE=D, IS_EXPLICIT=0 ); Can you tell me where the mistake is? Thank you by advance

fabdu92 · ‎06-02-2016

Hi, I have a dataset like this: DataA DataB DataC ajbg 34 31/01/2000 hytv 20 31/08/1995 ytffg 54 28/02/2005 ... I would like to duplicate rows for each row. How many times? Exactly the number of time of DataB: 34 times for the first row, 20 for the second one, 54 for the third, in the way we have something like that at the end. DataA DataB DataC ajbg 34 31/01/2000 ajbg 33 29/02/2000 ajbg 32 31/03/2000 ajbg 31 30/04/2000 ajbg 30 31/05/2000 ... hytv 20 31/08/1995 hytv 19 30/09/1995 hytv 18 31/10/1995 hytv 17 30/11/1995 hytv 16 31/12/1995 hytv 15 31/01/1996 ... ytffg 54 28/02/2005 ytffg 53 31/03/2005 ytffg 52 30/04/2005 ytffg 51 31/05/2005 ytffg 50 30/06/2005 ... Is there a way to do this? Thanks for help, I am only a beginner on SAS

Online Status	Offline
Date Last Visited	‎05-02-2018 10:36 AM

Re: Macro variable inside call execute

Macro variable inside call execute

Re: Num8 to YYMMDDN8

Unknown variable name with space query

Re: Create a merge table

Create a merge table

Re: Macro around several proc sql

Re: Macro around several proc sql

Macro around several proc sql

Re: Macro modify macro variable value

Re: PROC SQL NOPRINT default value

Re: Proc Transpose case

Re: PROC Transpose all variables

Re: Extract a number somewhere in a string

Re: Insert rows according to another table rows values

Re: PROC SQL NOPRINT default value

SAS EG: Don't run a process path

Insert rows according to another table rows values

Re: calcul in obs

calcul in obs

Re: PROC SQL CAST

PROC SQL CAST

Re: proc import pdf

proc import pdf

PROC EXPORT conditionning number of rows

Excel export format issue

do loop intnck first row deleted

SAS EG: Don't run a process path

Re: Compare intnx and prompt

Re: Compare intnx and prompt

Compare intnx and prompt

Duplicating rows following condition