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: 
jacksonan123
‎03-01-2023
  • 283 Posts
  • 8 Likes Given
  • 4 Solutions
  • 28 Likes Received

Re: Input text file into SAS university

by Lapis Lazuli | Level 10 in SAS Programming
‎06-12-2017 07:05 PM
‎06-12-2017 07:05 PM
My code is below (same as yours that worked) but it did not run because numerics were converted to characters and it found no observations in the fit files.smr. Do you see any error in your code that I tried? %macro datm1; %do i=1% to 2; data NEW&i; libname OLD "/folders/myfolders/bootprocess/"; infile "/folders/myfolders/bootprocess/FIT&i..smr/"; INPUT @ ; /*DATA NAME IS CHECK WHICH IS INDEXED W/'THETA =' THIS MUST BE EXACT*/ S=INDEX (infile,'THETA ='); IF S>0 THEN DO; Input @'=' KAF KAS CL V3 D1 ALAG LOGIT; output; end; KEEP KAF KAS CL V3 D1 ALAG LOGIT; PROC PRINT; RUN; %end; %mend datm1; %datm1; run; ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Re: Input text file into SAS university

by Lapis Lazuli | Level 10 in SAS Programming
‎06-12-2017 06:52 PM
‎06-12-2017 06:52 PM
I moved the libname outside the macro and removed the = sign after the infile. However for some reason I get no errors but the log states that Work.new1 has 0 observations and 7 variables. I know that the file has data. Do you have any idea why is does not read the data? ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more

Input text file into SAS university

by Lapis Lazuli | Level 10 in SAS Programming
‎06-12-2017 01:53 PM
‎06-12-2017 01:53 PM
I have the following code for which I get an error that htere are no data lines or infile statement.   options symbolgen mtrace notes source MPRINT; %macro datm1; %do i=1% to 2; data NEW&i; libname OLD "/folders/myfolders/bootprocess/"; /*Input D*/ /*datafile="/folders/myfolders/bootprocess/FIT&i..smr/";*/ infile ="/folders/myfolders/bootprocess/FIT&i..smr/"; INPUT @ 1 CHECK  $CHAR200.@; /*DATA NAME IS CHECK WHICH IS INDEXED W/'THETA   =' THIS MUST BE EXACT*/ S=INDEX(CHECK,'THETA     ='); /*DO LOOP TO PICK OUT CORRECT LINE OF CODE LINE W/STRING WILL BE NUMBERED WITH 1 OTHERS=0*/ /*SCAN FUNCTION ALLOWS VARIABLES TO BE OUTPUT FROM THAT POSITION WITH THE DESIRED NAME*/ IF S>0 THEN DO;  THETA_=SUBSTR(CHECK,S+0,110);  KAF=SCAN(THETA_,3,' ');  KAS=SCAN(THETA_,4,' ');  CL=SCAN(THETA_,5,' ');  V3=SCAN(THETA_,6,' ');  D1=SCAN(THETA_,7,' ');  ALAG  =SCAN(THETA_,8,' ');  LOGIT= SCAN(THETA_,9,'   ');   OUTPUT;  END;   KEEP  KAF  KAS CL V3 D1 ALAG LOGIT;  *PROC PRINT; RUN; %end; %mend datm1; %datm1; run;   The files fit1.smr  and fit2.smr are identical  and the program was written to capture the theta values. : THETA: 1)K0 2)KAS 3)CL 4)V3 5)D1 6)LAG2 7)LOGIT ETA: ERR: ABRIKA1.lst 14.307 eval=631 sig=4.1 sub=18 obs=18 CCIL=NNNN NVI2.0 PV2.0 THETA = 4.96 4.96 470 2210 1.11 4.2 0.151 ETASD = 0.278568 0.00316228 ERRSD = ... View more

Re: Merging

by Lapis Lazuli | Level 10 in SAS Programming
‎02-15-2017 05:34 AM
‎02-15-2017 05:34 AM
The code worked very well.   Thanks ... View more

Merging

by Lapis Lazuli | Level 10 in SAS Programming
‎02-14-2017 04:35 PM
‎02-14-2017 04:35 PM
I am using the following code to merge data sets newl4 and newd4 after they have been sorted by wsubj: data all; merge newl4(in=inp) newd4(in=ine); by wsubj ; if inp and ine; run;   newd4 subj time cmt conc 1 0.25 1 0 1 0.25 2 0 1 0.25 3 0 1 0.25 4 0 1 0.25 5 0 1 0.25 6 0 1 0.25 7 0 1 0.25 8 0 1 0.25 9 0 1 0.25 10 0 1 0.25 11 0.2242009 1 0.25 12 0 1 0.25 13 0 1 0.25 14 0 1 0.25 15 0 1 0.25 16 0 1 0.25 17 0 1 0.25 18 0 1 0.25 19 0 1 0.25 20 0 1 0.25 21 0 1 0.25 22 0 1 0.25 23 0 1 0.25 24 0   Newl4 subj time cmt conc 1 0.25 1 0 1 0.25 2 0 1 0.25 3 0 1 0.25 4 0 1 0.25 5 0 1 0.25 6 0 1 0.25 7 0 1 0.25 8 0 1 0.25 9 0 1 0.25 10 0 1 0.25 11 0 1 0.25 12 0 1 0.25 13 0 1 0.25 14 0 1 0.25 15 0 1 0.25 16 0 1 0.25 17 0 1 0.25 18 0 1 0.25 19 0 1 0.25 20 0 1 0.25 21 0 1 0.25 22 0 1 0.25 23 0.0960861 10.25 24 0   The only difference between them is that newd5 and newl4 have a conc in different cmt(i.e., newd4-cmt 11 and newl4 cmt23). Whe I try to merge them I only get a value for conc in cmt 11 of 0.22, while cmt 23=0.  Can someone  give me code that will result in both cmt11 and cmt23 showing the values in newd4 and newl4 in the merged data set all? ... View more

Re: Box Cox-Two Distributions in same data set

by Lapis Lazuli | Level 10 in Statistical Procedures
‎11-22-2016 08:18 AM
‎11-22-2016 08:18 AM
Not sure if that would help but I may try it later. ... View more

Re: Box Cox-Two Distributions in same data set

by Lapis Lazuli | Level 10 in Statistical Procedures
‎11-21-2016 07:23 PM
‎11-21-2016 07:23 PM
My goal is to do a linear regression with the data which if not normal would violate the assumptions for the regression.   I chose that bin size because it appeared to coincide with the observed histogram.  There may be subpopulations involved but at this point we are not sure but we are investigating.   I was not aware of Proc FMM.   Are there any normality requirements for using Proc FMM? ... View more

Box Cox-Two Distributions in same data set

by Lapis Lazuli | Level 10 in Statistical Procedures
‎11-21-2016 01:33 PM
‎11-21-2016 01:33 PM
I have non-transformed data  whose histograms show two distributions.   Therefore, would it be okay to apply the Box Cox analysis seperately to the distributions above and below CLud > 250000 and Clud<250000 in this case?  I ask because when I do seperate analyses, the resulting tests for normality and the QQ plots are vastly improved.   A follow-up question would be should one analyze as two distributions if the transformed data show two distinct distributions? ... View more

Re: Multiple Comparisons

by Lapis Lazuli | Level 10 in Graphics Programming
‎11-01-2016 01:15 PM
‎11-01-2016 01:15 PM
Yes this would work quite well.   Thanks ... View more

Re: Multiple Comparisons

by Lapis Lazuli | Level 10 in Graphics Programming
‎11-01-2016 04:28 AM
‎11-01-2016 04:28 AM
The reply was helpful. ... View more

Multiple Comparisons

by Lapis Lazuli | Level 10 in Graphics Programming
‎10-26-2016 10:13 AM
‎10-26-2016 10:13 AM
 I have the following data set which has INCL, slope, and CLnr/CLr values.  I found code to compare slopes or CLnr/CLr between the different INCL classes.  My question is can one compare both slope and CLnr/CLr values simultaneously between the INCL classes? The post was altered due to invalid HTLM but all of the slopes and CLnr/CLr values should be in the same columns. INCL Drug Slope  Slope  CLnr/CLr CLnr/CLr CIDof Aztreonam 1.43   0.724 CIDof Carumonam 1.14   0.265 CIDof Cefepime   1.04   0.176 CIDof Cefetamet 1.22   0.25 CIDof Ceftazidime 1.17   0.351 CIDof Cidofovir   1.1   0.176 CIDof Ciprofloxacin 1.06   0.639 CIDof Meropenem 1.06   0.316 CIDof Metoclopramide 3.43   3.76 CIDof Tiotropium 1.7   0.932 NOCIDof Aztreonam 1.43   0.724 NOCIDof Carumonam 1.14   0.265 NOCIDof Cefepime   1.04   0.176 NOCIDof Cefetamet 1.22   0.25 NOCIDof Ceftazidime 1.17   0.351 NOCIDof Ciprofloxacin 1.06   0.639 NOCIDof Meropenem 1.06   0.316 NOCIDof Metoclopramide 3.43   3.76 NOCIDof Tiotropium 1.7   0.932 NOCIDCIPR Aztreonam 1.43   0.724 NOCIDCIPR Carumonam 1.14   0.265 NOCIDCIPR Cefepime   1.04   0.176 NOCIDCIPR Cefetamet 1.22   0.25 NOCIDCIPR Ceftazidime 1.17   0.351 NOCIDCIPR Meropenem 1.06   0.316 NOCIDCIPR Metoclopramide 3.43   3.76 NOCIDCIPR Tiotropium 1.7   0.932 NOCIPRO Aztreonam 1.43   0.724 ... View more

Re: Formatting a put c $

by Lapis Lazuli | Level 10 in SAS Programming
‎09-27-2016 05:53 AM
‎09-27-2016 05:53 AM
A reply from Support@SAS.com pointed out the file had a Unix format and that the input statement should contain termstr=lf which allowed the input to be read. ... View more

Re: Formatting a put c $

by Lapis Lazuli | Level 10 in SAS Programming
‎09-21-2016 01:52 PM
‎09-21-2016 01:52 PM
To all:   I got an answer from SAS consulting and the issue was that the file was UNIX formatted and the addition of termstr=lf resolved the issue.   This command facilitates reading files between UNIX and Windows. ... View more

Re: Formatting a put c $

by Lapis Lazuli | Level 10 in SAS Programming
‎09-21-2016 12:14 PM
‎09-21-2016 12:14 PM
I tried string statements and scans to identify the two lines as being seperate but the output always contains either both on the same line or in this case of the scan syntax only line 1 was output (i.e., $PROBLEM TWO PEAK SEQUENTIAL ZERO AND FIRST ORDER). SAS seems to ignore the second line line2 = '$' || scan(c,2,'$'); ... View more

Re: Formatting a put c $

by Lapis Lazuli | Level 10 in SAS Programming
‎09-21-2016 10:55 AM
‎09-21-2016 10:55 AM
Code in brackets [data _null_ ; infile '/folders/myfolders/bootnew/REF.CTL' firstobs=1 obs=2 truncover; /* INPUT CHARACTER FILE*/ input c $1000.; do i=1 to 2; myfile='/folders/myfolders/bootnew/REF' || trim(left(put(i,8.))) || '.ctl'; file dummy filevar=myfile MOD ; if _n_=2 then do; if i=1 then do; amp_loc=index(c,'&'); first_half=substr(c,1,amp_loc-1); last_half=substr(c,amp_loc+2); end; c= trim(first_half) || trim(left(put(i,8.))) || last_half; end; put c $; end; run;] Original file $PROBLEM TWO PEAK SEQUENTIAL ZERO AND FIRST ORDER $DATA ..\TFIT&i.CSV IGNORE=W   Output file: All on one line $PROBLEM TWO PEAK SEQUENTIAL ZERO AND FIRST ORDER $DATA ..\TFIT1.CSV IGNORE=W   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-01-2023 03:29 PM
Group Hubs for jacksonan123
View All
Likes given to
Likes from
View All
Quick links