About WilliamB

WilliamB · ‎01-31-2018

Hello, I would like to keep that individuals who have 211 in the name variable. Example 211BWBC I want to keep 210ECFP I delete But I would not like to create new columns by separating the variable name. I would like to use the scan function. Thanks for your help. data table; input Note Name $; cards; 8.3860559819623 210WEAO 15.5453663184726 211BWBC 17.6964655703656 210ECFP 13.1571255262187 211PKKJ 9.68736898002401 211HVHQ 10.6813100977326 211POMB 10.550264669724 211ZNQQ 0.0137936072989309 210AMJL 12.1139082894838 209XBZI 9.61956573832501 211LPJF 16.6234269133052 211WVEI 3.97311995569568 210JTFB 15.3252688167527 211TIIF 12.1379157216451 211KQLL 0.340648291882129 211DGMD 0.580565770662087 209QZTW 13.7217455692869 211ODHO 14.5722830026303 211XQJC 4.80396668369969 211ISBM 2.35396936861499 210KBGQ 7.50175770970474 211KGHH 6.14469376072229 209CXSG 11.977944705167 210TSHR 15.0357006553603 209YYNH 17.2611601306417 211QTUA 12.89070855245 210ZZXT 16.9492553096389 210NVEQ 8.17649698621122 211YOSP 18.0045428790637 211YYUO 14.9754022888188 211BYNS 3.0461865950108 211RNCD 12.957558565645 210LOBX ; run;

WilliamB · ‎01-15-2018

Sas Table Hello, I have a first SAS table Name C1 Thomas 1 Tho 1 Fabien 2 Fab 2 I would like to create a program where if C1 (n) = C1 (n-1) from the observation before then Name (n ) = Name (n-1) I want to get this Name C1 Thomas 1 Thomas 1 Fabien 2 Fabien 2 I have a very large table, so I can not rename individually any observation. Thanks for your help

WilliamB · ‎01-14-2018

Hello, I have a first table: Name C1 Thomas 5 To 5 Fab 4 Fabien 4 Nelson 9 2 nd table Fabien Thomas Nelson I would like to create a 3rd table that brings together individuals with the same values of 'C1'. But that the value of 'Name' is the one present in table 2. I would like to get this: Name C1 Count Fabien 5 2 Thomas 4 2 Nelson 9 1 I do not want to rename the values of name. And I would like to have a variable count that counts the number of times that the individual appeared Example: Fabien and Fab count = 2 Thanks for your help

WilliamB · ‎01-14-2018

Hello, I have a first SAS table Name C1 Thomas 2 Fabien 7 Nelson 9 2nd Sas table Name R1 Thomas TB Fabien AB Didier Ajac I would like to create a 3rd table, which shows the individuals in table 1 who are present in table 2, and concatenate the characteristics. But keep all individuals from table 2 even if they are not present in table 1. If possible in proc SQL. Thank you I want to get this Name C1 R1 Thomas 2 TB Fabien 7 AB Didier . Ajac Thanks for your help

WilliamB · ‎01-14-2018

Hello, I would like to use Proc SQL. I have a SAS table: An individual with the same characteristics is the same person I would like to count the number of individuals with same characteristics, and get this table: Name C1 C2 C3 Count Thomas 1 2 3 3 Thomas 3 4 3 1 Thomas 1 2 5 1 Fabien 1 2 3 2 Fabien 7 8 9 1 An individual with not the same characteristics, is not the same person, so we have 3 thomas and 2 fabien. But the first thomas was recorded 3times, and the first fabien 2 times. Thanks for your help

WilliamB · ‎01-13-2018

Hello, I have a database (.txt) made up of percentage: 50 40 20 10 41 But they must not be in this form Which format or informat would allow to have this in sas table : 0.5% 0,4% 0,2% 0.1% 0,41% Thanks for your help

WilliamB · ‎12-20-2017

Hello, I'd like to make a decision tree that starts with the 'age' variable and then processes the variable 'DebtRatio'. And another decision tree that starts this time by 'DebtRatio' then 'age'. Because I want only 2 split, I want to see the difference of decisions in these 2 cases. How to do this? Thanks for your help. proc hpsplit data=train seed=15531 maxdepth=2 splitonce ; model SeriousDlqin2yrs = DebtRatio age ; grow Ftest; prune costcomplexity; code file='treesc.sas'; rules file='projetrules.txt'; output out = scoredtraining ; run; quit;

WilliamB · ‎12-06-2017

Hello, I would like to understand the proc hpsvm, I looked at some examples, but I do not understand the difference between: - Number of Support Vectors on Margin This one ok - Number of Support Vectors What is this? Thanks for your help

WilliamB · ‎11-27-2017

Hello, i would like to import all these csv files from this folder into sas quickly. Then concatenate all in one table. Thanks for your help.

WilliamB · ‎10-26-2017

Since a few days I get this error, and I can not use the software anymore. Do you have a solution?

WilliamB · ‎05-18-2017

Hi, In a more complex program, I need to set 2 conditions in my "if". I need to keep a macro. But the "&" and "and" do not work. Do you have a solution thank you. Here is a simple program: data toto; input u; cards; 5 5 9 8 17 14 15 ; run; %macro p (i); %if i>5 and i<10 %then %do; data titi; set toto; run; proc print; run; %end; %mend; %p (9)

WilliamB · ‎11-08-2016

Hi, I have data, which represent the duration of functioning of machines until they break down. When the observations are negative: the machine did not break down, thus the observation is censored (State=1 if censored, status=0 if observed). I used the maximum likelihood, with a Weibull distribution. But I would like to Wald tests, LM (score), and LR tests How to make them? Proc logistic? Thank you for your help My code: --------------------------------------------------------------------------- title 'TEST Weibulls'; options ls=75 ps=60 pageno=1 nocenter; data lr1samp; input tt @@; * State=1 if censored, status=0 if observed; days=abs(tt); status=(tt<0); drop tt; datalines; 6 11 17 42 43 52 75 82 144 148 168 207 212 279 -388 416 443 552 600 600 629 -655 708 743 864 -873 1061 -1225 1257 -1659 -2137 -2188 -2441 -2591 2842 2867 -2880 3509 -4864 5090 ; proc print; title2 'The data as SAS sees it'; run; proc lifereg; title2 'USE PROC LIFEREG TO FIT A WEIBULL DISTRIBUTION'; model days*status(1) = / dist=Weibull; run; ---------------------------------------------------------------------------

WilliamB · ‎10-28-2016

Hi, I have a csv table, and at the end of each column, I have the total of the column that appears. I would separate the last line, and that the line is not an observation but the total. ..... , ...... , ...; 02/10/2016,126,473 03/10/2016,213,648 04/10/2016,242,809 05/10/2016,235,807 06/10/2016,285,1013 07/10/2016,260,905 08/10/2016,132,400 09/10/2016,150,446 10/10/2016,256,655 11/10/2016,249,790 ,611246,1864947 ,611246,1864947 here in the last line, the total of column 2 and 3. I want : ... ......... .... .... Thank you for your help.

WilliamB · ‎10-27-2016

Hi, I have a csv file: 01/02/2009,146,394 02/02/2009,278,791 03/02/2009,224,637 04/02/2009,275,725 05/02/2009,276,1Â 101 06/02/2009,247,1Â 103 07/02/2009,154,412 08/02/2009,192,609 09/02/2009,308,992 10/02/2009,333,1Â 287 11/02/2009,342,1Â 250 12/02/2009,375,1Â 975 13/02/2009,275,1Â 019 14/02/2009,120,487 15/02/2009,133,567 16/02/2009,210,770 I remove Â with the command 'compress', no problem. But to remove the space, there is a problem, the command 'compress', does nothing. Why? My goal is not to change the csv file but to transform eg: 1Â 056 -- compress --> 1 056 --> compress --> 1056 data toto; infile 'C:\.........................\sessionsetpagesvues.csv' dlm=',' firstobs=8 truncover; input Index_des_jours :ddmmyy. Sessions :numx. x3 $; x4=compress(x3,'Â ','a'); x5=compress(x4,'','s'); Pages_vues= input(x5, numx.); run; proc print data=toto(obs=350);run; proc contents data=toto;run; x5=compress(x4,'','s'); This command does not work why? Thank you for your help.

WilliamB · ‎10-27-2016

Hello I have a excel table and for the thousands I have a "Â" and therefore I would like to remove the "Â" to keep numeric variables without changing the .xlsx file. My goal transform this: 1Â 056 988 --> 988 1Â 056 ---> 1056 Sometimes, there is no "Â": 17923 232 641 17924 240 735 17925 323 1Â 208 17926 233 769 17927 194 634 17928 150 428 17929 146 394 17930 278 791 17931 224 637 17932 275 725 17933 276 1Â 101 17934 247 1Â 103 17935 154 412 17936 192 609 17937 308 992 17938 333 1Â 287 17939 342 1Â 250 17940 375 1Â 975 17941 275 1Â 019 ..... I should probably create a informat? Finally, the last line is the total of columns 2.3. Here is the false start code. data toto; infile 'C:\.........\SPV11.xlsx' dlm=',' firstobs=8 truncover; input x1 :ddmmyy. x2 :numx. x3 :numx.; run; proc print data=toto(obs=350);run; Attachements: my .xlsx file. Is there any simple solution to those operations? Thank you!

Online Status	Offline
Date Last Visited	‎12-23-2022 06:44 PM

Keep last record

Creating a cumulative column

Get week number

Transpose an array

Concatenate two tables with dates

Remove duplicates

Re: SQL, Select the best line

SQL, Select the best line

Link two tables with a date year and month

Macro Variable if

Re: Get week number

Re: Record the evolution of individuals

Get week number

Transpose an array

Re: Find individuals

Find individuals

Keep variable values across rows

Rename and gather people through another table

Gathering information

Count the number of individuals with the same characteristics

Percentage

PROC HPSPLIT Decision Tree

Proc HPSVM

Gather all csv files from a folder into a single sas table.

How to solve "The Security package failed while authenticating the use...

%If %then %do

Three Classical Tests; Wald, LM(Score), and LR tests

Last observation: total of column

Compressing spaces

Change 1Â 056 ---> 1056