About mansour_ib_sas

mansour_ib_sas · ‎02-13-2019

Hello, I want to change the special characters using this code. It's remain to define the size of observation. the function length does not work could you, please, help me? %macro tt(); data test1; set test; %do i=1 %to %sysfunc(length(var)); lettre=substr(var,&i.,1); type=indexc(lettre,'3A3B3C'x); if type then do; substr(var,&i.,1)=translate(lettre,'414243'x,'3A3B3C'x); end; else do; substr(var,&i.,1)=lettre; end; %end; run; %mend; %tt; Whith this method, the code work correctely data test1; set test; var1=translate(var,'ABC','3A3B3C'x); run; NB: these are tests that I do for myself Thank you

mansour_ib_sas · ‎01-29-2019

hello RW9, Quentin and thank you for your ansewer, @Quentin It is the first solution that you proposed to me that I wanted to put in place. Nevertheless, I have a question. Using the base language in this step: %macro tt(variable=); data test; set sashelp.class; reg=catx('/',&variable); run; %mend; %tt(variable=%bquote(age,weight)); the evaluation is not realized. But whith macro code in step data (your first solution) then evaluation is realized. Is it related to the phase comiplation ==> generation of the text. And in the phase execution, the function is evaluated? Thank you

mansour_ib_sas · ‎01-29-2019

hello, can concatenate two macros variables and realize an arithmetic operation as follows: %macro tt(variable=); data test; set sashelp.class; reg=%sysevalf(catx('/',&variable)); run; %mend; %tt(variable=%bquote(age,weight)); Thank you

mansour_ib_sas · ‎01-22-2019

To the method I'm trying to applay, I understood where the problem came. At the scan, I forgot to add space as a separator. Now, I can separate the string charcters correctly. Thank you for you help. data test1; set test; i=1; do while (scan(name,i, " ") ne ' ') ; part=scan(name,i,''); regex = prxparse('/\(/'); if prxmatch(regex, part) >0 then output; i+1; end; run;

mansour_ib_sas · ‎01-21-2019

Thank you for your answer, For your first question, i want to delete the reccord inside a parenthesis by regulare expression. For your second question: data test; input name $25.; cards; test test test test; run;

mansour_ib_sas · ‎01-21-2019

Hello; I'm trying to extract whith regulars expressions the parts of names that are surrounded by paratheses. For started, I try to detect what starts with a parenthesis and no word does match. That is why, i am asking you for help me. Thank you data test; input name $25.; cards; test (ex) (ex) test test test ; run; data test1; set test; i=1; do while (scan(name,i, " ") ne ' ') ; part=scan(name,i); regex = prxparse("/(?<=\()/"); if prxmatch(regex, part) >0 then output; i+1; end; run;

mansour_ib_sas · ‎01-15-2019

Hello can we use the dim function to define the size of vector in a macro ? Thank you

mansour_ib_sas · ‎12-21-2018

Hello, I propose this solution: data companies; length ID $ 3; input ID $ score1 attribute1 attribute2 attribute3; datalines; 001 0.3 1 0 1 002 0.5 0 1 1 003 0.3 1 1 1 001 0.3 1 0 1 003 0.3 1 1 1 ; run; PROC SQL; CREATE TABLE Summary AS SELECT DISTINCT put (score1,5.) as score1, (COUNT(attribute1)) AS attribute1, (COUNT(attribute2)) AS attribute2, (COUNT(attribute3)) AS attribute3, (COUNT(DISTINCT(ID))) AS Total FROM COMPANIES GROUP BY score1; QUIT; proc report data =summary out=summary1(drop=_BREAK_) noprint ; columns score1 attribute1 attribute2 attribute3 total; define score1/DISPLAY; define attribute1 /analysis sum; define attribute2 /analysis sum; define attribute3 /analysis sum; define total /analysis sum; rbreak after / summarize ; compute after; score1='TOTAL'; endcomp; run;

mansour_ib_sas · ‎12-18-2018

Hello, I have the test table and I want to have the table test1. The objectif is to delete the lines that are annulled Thank you for your help data test; input var1 $ var2; cards; A 200 A 100 A -200 A 200 B 100 ; run; data test1; input var1 $ var2; cards; A 200 A 100 B 100 ; run;

mansour_ib_sas · ‎12-12-2018

The variables macros are created with the semicolon. Their display outside the macro requires% SUPERQ. I tried again with the third parameter and the result is the same %macro tt(); data _null_; set sashelp.class; call symputx ('name'||left(_n_),catt(name,';'),'G' ); run; %end; %mend; %tt;

mansour_ib_sas · ‎12-12-2018

Hello, I have this macro that creates me variables macros. I can't understand why on the outside of the macro tt(), variables macros created by call symputx do not display with the semicolon. In the vmacro table, variables macros are created with semicolon. The addition of % SUPERQ, to indeed, allows the display of these variables macros with semicolon (;). Thank you in advance for your help. %macro tt(); data _null_; set sashelp.class; call symputx ('name'||left(_n_),catt(name,';') ); call symput ('nbr',_n_); run; %put name_in = &name1; %do i=1 %to &nbr; %global nname&i; %let nname&i=%SUPERQ(name&i); %end; %mend; %tt; %put &name1; %put &nname1;

mansour_ib_sas · ‎12-11-2018

Hello, i want to delete the 3 numbers that are in the middle. I tried like this; It does not work. Will you please help me thank you data test; input name $; cards; 901-333-444 ;run; proc sql; select name , prxchange( 's/\A -\d{3} / /i',-1,name ) as name1 from test ; quit ;

mansour_ib_sas · ‎12-03-2018

If I want to put a table work in a sgbd in a temperate way; the time of a treatment. At this point, should I inform the dba?

mansour_ib_sas · ‎11-30-2018

hello, I propose this solution: data tac; input randomization visit tac; datalines; 618001 2 8824 618001 3 9088 618001 4 9784 618002 2 7962 618002 3 8318 618002 4 8819 618003 2 10630 618003 3 8906 618003 4 9796 ; run; proc sql; create table test as select a.* ,base_tak from tac as a inner join (select tac as base_tak ,randomization from tac where visit=2) as b on a.randomization=b.randomization ; quit;

mansour_ib_sas · ‎11-30-2018

Thank you for your answer which is very clear. However, before copying a work table into a sgbdr system, do I have to inform a dba for example. Or it's just a storage space like the folders we create in our Windows directories.

Online Status	Offline
Date Last Visited	‎02-29-2020 02:07 PM

first date monday and last day friday

Re: Optimisation request

Optimisation request

Transpose data whith array and conditions

Regular expression, loop, and macro variable

Re: Print whith FCMP

Print whith FCMP

Re: used multi go to in program

Re: used multi go to in program

used multi go to in program

Re: Regular expression, loop, and macro variable

Re: Finding the next value by group processing

Re: [macro] Used Lenght in loop

Re: Grouped macros variables and make arithmitics operations

Re: Grouped macros variables and make arithmitics operations

Re: Overlap in periods

Re: Splitting a macro variable into smaller macro variables.

Re: Using commas between intermediate tables

Re: Creating data in one line with multiple columns using two columns

[macro] Used Lenght in loop

Re: Grouped macros variables and make arithmitics operations

Grouped macros variables and make arithmitics operations

Re: regulare expression; detecte the special charatere '('

Re: regulare expression; detecte the special charatere '('

regulare expression; detecte the special charatere '('

Function dim in macro

Re: Crosstabulate distinct frequencies and totals of binary variables

Delete the lines that are annulled

Re: Create variables macros with semicolon (;)

Create variables macros with semicolon (;)

Using regular expressions for deletion

Re: Copy data work in database (oracle, teradata)

Re: using retain to generate baseline values

Re: Copy data work in database (oracle, teradata)