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: 
bhufman
‎12-13-2020
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: What is the purpose of macros?

by Calcite | Level 5 in New SAS User
‎12-13-2020 02:07 PM
‎12-13-2020 02:07 PM
You basically use Macros if you find yourself needing a certain code constantly, that way you don't keep recoding the same thing. Essentially they are meant to save you a lot of time! ... View more

Re: Running a Chi Square

by Calcite | Level 5 in SAS Programming
‎12-06-2020 04:25 PM
‎12-06-2020 04:25 PM
            ... View more

Re: Running a Chi Square

by Calcite | Level 5 in SAS Programming
‎12-06-2020 04:18 PM
‎12-06-2020 04:18 PM
Thanks for this tip! I'm still getting the warning about the output for ChiSq and the Error that the ChiSq File doesn't exist. ... View more

Running a Chi Square

by Calcite | Level 5 in SAS Programming
‎12-06-2020 04:01 PM
‎12-06-2020 04:01 PM
I am trying to get this output to run for a Chi Square, here is my Code: ODS Trace on; Proc Freq Data=hypanl.hypanalysis2; Tables hypreldeathInd * StateCd / Nopercent norow nocum chisq; Run; ODS Trace Off; ODS OUTPUT CrossTabFreqs=HRslt.Percents (KEEP = Cd DeathInd Frequency ColPercent WHERE = (DeathInd = 1 AND MISSING (Cd)=0)); ODS OUTPUT Chisq=HRslt.ChiSqResults (DROP=TABLE WHERE= (Statistic= 'Chi Square')); PROC PRINT DATA=H.Percents; RUN; PROC PRINT DATA=H.ChiSqResults; RUN; I am getting this Error in the log: ERROR: File H.ChiSq.DATA does not exist. 91 RUN; And these Warnings: WARNING: Output 'Chisq' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. WARNING: Output 'CrossTabFreqs' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used.   Any suggestions on whats happening, particularly with the Error... ... View more

Re: Match-Merge Data Sets

by Calcite | Level 5 in SAS Programming
‎12-06-2020 03:42 PM
‎12-06-2020 03:42 PM
Have you tried using the YDRIF statement? AgeAtVisit = YRDIF(BirthDt, VisitDt, 'Age'); FORMAT AgeAtVisit 2.0; ... View more

Merging Problems

by Calcite | Level 5 in New SAS User
‎12-03-2020 08:49 PM
‎12-03-2020 08:49 PM
In the program I am working on I am looking to have 573 observations after everything is merged, however I am either coming up with 598 or 0, and the variable Age is also dropping.   Here is my code: Proc contents Data= Hyptabs.vitals; Run; Data Work.lastvitals; Set Hyptabs.vitals; By SSN; IF Last.SSN= 1; Run; Data Hypanl.Hypanalysis2; Retain SSN StateCd GenderCd EthCd RaceCd AgeAtVisit SBP DBP WtLb HypRelDeathInd; Merge HypTabs.Demog (IN = InDemog Drop = EthRaceCd) Hyptabs.Contact (IN= InContact Keep= SSN StateCd) Work.LastVitals (IN = InLastVitals Drop= HtIN) Hyptabs.NDI (IN= INNDI Drop=Deathdt ICD10 CODCD); By SSN; IF Incontact=1 AND InDemogs = 1 AND InVitals = 1; If Indvbl = . THEN Hypre1DeathInd = 0; Else IF Indvbl = 0 THEN HypReIDeathInd= 0; ELSE IF IndVbl = 1 THEN HypRelDeathInd = 1; AgeAtVisit1 = YRDIF(BirthDt, VisitDt, 'AGEAtvisit'); FORMAT AgeAtVisit 2.0; DROP BirthDt VisitDt; Run; Proc Print Data=Hypanl.hypanalysis2; Run;     One of the things that the log is saying that I'm really not sure about is the log saying this:  NOTE: Variable AgeAtVisit is uninitialized. NOTE: Variable InDemogs is uninitialized. NOTE: Variable InVitals is uninitialized. NOTE: Variable Indvbl is uninitialized. What does that mean, and is that where my problem lies? ... View more

Libname Error Help

by Calcite | Level 5 in New SAS User
‎12-02-2020 09:23 PM
‎12-02-2020 09:23 PM
Hi everyone,  Below is the Libname statements I am using, I keep getting an Error on Libname "HypeResults." Here is a copy of the Libname and the log:   %LET CourseRoot = /folders/myfolders/My Folders/BIOS6680; LIBNAME HypTabs "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations"; LIBNAME Hypan1 "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis"; Libname HypResults "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/5_Results"; /* Enter additional LIBNAME statements */ /* Enter any necessary options in an OPTIONS statement*/ OPTIONS FMTSEARCH= (Hyptabs.hypformats WORK LIBRARY) NOFMTERR;     1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 * Instructions: 74 1) Change the path in the %LET statement to the location of the BIOS 6680 course root folder 75 2) Submit the %LET and LIBNAME statements below *; 76 %LETCourseRoot = /folders/myfolders/My Folders/BIOS6680; 77 LIBNAME HypTabs"/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations"; NOTE: Libref HYPTABS was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/3_Tabulations 78 LIBNAME Hypan1 "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis"; NOTE: Libref HYPAN1 was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/4_Analysis 79 Libname HypResults "/folders/myfolders/My Folders/BIOS6680/Cancer RCT/Data/5_Results"; ERROR: HypResults is not a valid SAS name. ERROR: Error in the LIBNAME statement. 80 /* Enter additional LIBNAME statements */ 81 /* Enter any necessary options in an OPTIONS statement*/ 82 OPTIONS FMTSEARCH= (Hyptabs.hypformats WORK LIBRARY) 83 NOFMTERR; 84 85 86 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 98   Do you initially see anything wrong with my HypResults Libname? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-13-2020 05:29 PM
Quick links