cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Nasser_DRMCP
yesterday
  • 280 Posts
  • 44 Likes Given
  • 11 Solutions
  • 5 Likes Received

Re: proc nlin how to determine the initial parameters

by Lapis Lazuli | Level 10 in Statistical Procedures
‎06-18-2018 08:47 AM
‎06-18-2018 08:47 AM
Thanks Rick for your quick response I checked the documentation (your link) but i do not manage to find the correct syntax. I took a look at the "Iteratively Reweighted Least Squares" paragraph. and the syntax you suggested does not seem to work . ... View more

Re: proc nlin how to determine the initial parameters

by Lapis Lazuli | Level 10 in Statistical Procedures
‎06-18-2018 08:29 AM
‎06-18-2018 08:29 AM
I succeed to determine the starting values but I don't know how many values should be contained inside the input table ... View more

proc nlin how to determine the initial parameters

by Lapis Lazuli | Level 10 in Statistical Procedures
‎06-18-2018 04:13 AM
‎06-18-2018 04:13 AM
  %let a= 54.8829483019154; %let b= 61.8215366579612 ; %let c= 8.4693242460909 ; proc nlin data=TXPTE_GENEALL method= MARQUARDT MAXITER=500; parms a=&a b=&b c=&c ; model GENEALL = 1 / (a + ((TRIM-b)/c)**2); output out= MODEL_GENERALISTE_CTX predicted= ESTIM_GENEALL parms= A B C; run; Hello,     I have a dataset "TXPTE_GENEALL" that holds 32 values. by lauching the this proc nlin, the problem I encounter is tha the ESTIM_GENEALL column get only one value for each observations. and the message is below: WARNING: Step size shows no improvement. WARNING: PROC NLIN failed to converge. NOTE: Negative model SS. Check model and initial parameters.   I Wonder how to determine the correct values a, b, c. thanks a lot in advance for your help Nasser ... View more

Re: concatenate all columns having same starting name

by Lapis Lazuli | Level 10 in SAS Programming
‎04-30-2018 02:58 AM
‎04-30-2018 02:58 AM
hello novinosrin   thanks for your help. but I get this message "The CATS function call does not have enough arguments" by attempting your suggestion. however it works with var= catx('', of class: ); ... View more

concatenate all columns having same starting name

by Lapis Lazuli | Level 10 in SAS Programming
‎04-27-2018 12:01 PM
‎04-27-2018 12:01 PM
Hello,   I have a data set that holds 20 columns classe_1, classe_2, classe_3....classe_20. possibles classe values : 5, 4, 17, C, B2. i would like to concatenate all columns that begins with class_ thanks for your help in advance regards Nasser ... View more

Re: Cumulative Sum by 2 Groups

by Lapis Lazuli | Level 10 in SAS Programming
‎04-17-2018 06:07 AM
‎04-17-2018 06:07 AM
I found the solution by doing that proc sort data=have ; by product month_amo month_prod ; run ; data want ; set have ; by product month_amo ; retain amount_cumul ; if first.month_amo then amount_cumul = amount ; else amount_cumul + amount ; run ; ... View more

Re: Cumulative Sum by 2 Groups

by Lapis Lazuli | Level 10 in SAS Programming
‎04-17-2018 05:55 AM
‎04-17-2018 05:55 AM
hello RW9,   thanks for your respons. but whenever a post a question , it is because i did not found the solve my problem by taking a look in the docs. Here is my dataset "have". I would like to get the amout_cumul for each product/month_amo group , for example the first cumul would be 11 + 12 +13 , the second 21+22+23... Data have ; infile datalines ; input product ~ $4. month_amo month_prod amount ; datalines ; PRD1 201801 201801 11 PRD1 201801 201802 12 PRD1 201801 201803 13 PRD1 201802 201801 21 PRD1 201802 201802 22 PRD1 201802 201803 23 PRD1 201803 201801 31 PRD1 201803 201802 32 PRD1 201803 201803 33 PRD2 201801 201801 41 PRD2 201801 201802 42 PRD2 201801 201803 43 PRD2 201802 201801 51 PRD2 201802 201802 52 PRD2 201802 201803 53 PRD2 201803 201801 61 PRD2 201803 201802 62 PRD2 201803 201803 63 ; ... View more

Re: Cumulative Sum by 2 Groups

by Lapis Lazuli | Level 10 in SAS Programming
‎04-17-2018 04:50 AM
‎04-17-2018 04:50 AM
hello, sorry for that. this is better data cars ; set sashelp.cars (keep=Make Type Invoice where=(Make in ('Buick' 'Cadillac')) ); run ; ... View more

Cumulative Sum by 2 Groups

by Lapis Lazuli | Level 10 in SAS Programming
‎04-17-2018 04:38 AM
‎04-17-2018 04:38 AM
data cars ; set sashelp.cars (keep=Make Type Invoice where=(Make in ('Buick' 'SUV')) ); run ; Hello,     for example in this "cars" dataset, I would like to get a column "invoice_cumul"  that cumul invoice by make, type thanks in advance for your help Nasser ... View more

Re: macro to export dataset into excel file : a blank at end

by Lapis Lazuli | Level 10 in SAS Programming
‎04-16-2018 03:28 AM
‎04-16-2018 03:28 AM
Hello,    the best solution is proc export. even if the accent are not correctly tranfered.. because "ods and proc print" It lasts too long. and I have too specify the format numx10.5 in a previous data step to get the ',' as separator (instaed of '.')     Nasser ... View more

Re: macro to export dataset into excel file : a blank at end

by Lapis Lazuli | Level 10 in SAS Programming
‎04-10-2018 05:31 AM
‎04-10-2018 05:31 AM
Hello Kurt thanks. by doing that, I managed to get a file that I can open into excel. but I encounter some problems with format. a number a text "non classé" is transfered "non classé" numbers like -3014.3 is correctly transfered but I would like the separator comma (instead of dot) many thanks to everybody for your precious help Proc export data=&tdb_mens. DBMS=CSV outfile="&repwork.&tdb_mens..csv" replace ; DELIMITER=';' ; RUn ; ... View more

Re: macro to export dataset into excel file : a blank at end

by Lapis Lazuli | Level 10 in SAS Programming
‎04-09-2018 12:36 PM
‎04-09-2018 12:36 PM
For Base SAS Software ... Custom version information: 9.3_M2 Image version information: 9.03.01M2P080112 For SAS/STAT ... Custom version information: 12.1 Image version information: 9.03.01M0P081512 For SAS/GRAPH ... Custom version information: 9.3_M2 For SAS Integration Technologies ... Custom version information: 9.3_M2 For SAS/ACCESS Interface to Oracle ... Custom version information: 9.3_M1 For SAS/ACCESS Interface to ODBC ... Custom version information: 9.3_M2 For SAS/ACCESS Interface to Netezza ... Custom version information: 9.3 Image version information: 9.03.01M0P051111 ... View more

Re: macro to export dataset into excel file : a blank at end

by Lapis Lazuli | Level 10 in SAS Programming
‎04-09-2018 12:30 PM
‎04-09-2018 12:30 PM
Thanks reeza I try your suggestion but... ERROR: Unable to load module 'SpreadsheetML' from template store! ERROR: No body file. EXCEL output will not be created ... View more

Re: macro to export dataset into excel file : a blank at end

by Lapis Lazuli | Level 10 in SAS Programming
‎04-09-2018 12:23 PM
‎04-09-2018 12:23 PM
the required module is not installed. by trying the proc export , the log says this: The SAS/ACCESS Interface to PC Files is not installed. Please install this module in order to IMPORT/EXPORT to these file types. ... View more

Re: macro to export dataset into excel file : a blank at end

by Lapis Lazuli | Level 10 in SAS Programming
‎04-09-2018 12:06 PM
‎04-09-2018 12:06 PM
Yes Kurt. I just need to export values to Excel. even if try with csv extension, it takes also a long time %Let xlsfile = &repwork.&tdb_mens..csv ; ... View more
Contact Me
Online Status
Offline
Date Last Visited
yesterday
Likes given to
Likes from
Quick links