About GreggB

GreggB · ‎04-25-2018

thanks. all that matters is that baker and able get codes that belong to east high.

GreggB · ‎04-25-2018

Nomatch contains the list of students who have no access_code nor a link. I put in a request for these students and received a file named Extra_codes that has a code and a link for each student. The access_code is unique but the link is unique only to the school. I want to "transfer" the access_code and link from Extra_codes to Nomatch. (a copy/paste, if you will). The n count of school in Nomatch is the same as the n count of schoolname in Extra_codes. My 2 data sets: Nomatch school last first access_code link east high able hotel east high baker india west elem charlie juliet west elem delta kilo north mid echo lima north mid foxtrot mike north mid golf nove Extra_Codes schoolname access_code link east high 22 https://lovesas.com/43 east high 17 https://lovesas.com/43 west elem 77 https://lovesas.com/55 west elem 80 https://lovesas.com/55 north mid 89 https://lovesas.com/98 north mid 03 https://lovesas.com/98 north mid 20 https://lovesas.com/98

GreggB · ‎02-27-2018

SAS is running a batch submit and opening in Enterprise. Where can I change settings so that double clicking simply opens the program in the editor?

GreggB · ‎12-19-2017

%let yr=1718; %inc 'H:\Macros\my_macros.sas'; proc import datafile="G:\Departments\Research\test scores\GT\&yr.\GIFT.csv" out=one dbms=dlm replace; getnames=yes; delimiter=','; run; proc print data=one (obs=5); run; data WORK.ONE ; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile "G:\Departments\Research\test scores\GT\&yr.\GIFT.csv" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; informat dob mmddyy10.; format gift_date cutoffdate $10. sasi_id best12. id10 best12. stud_id best12. lname $18. fname $22. guardians $37. address $27. city $13. state $4. zip $7. l_update $10. phone $14. sex $3. race $3. lunch $3. grade $4. lep $3. iep $1. sch_code $11. school $23. lschcode $2. nschcode $5. teacher $18. del_d $4. edate $4. e1date $4. e2date $4. duprec $3. check1 $1. flag $1. gtflag $2. refrd $1. refrd_d $4. refpmr $2. refnam $2. cogat_t best12. cogat_v best12. cogat_nv best12. cogat_q best12. cogat_g best12. cogat_d $10. cogatb_t $2. cogatb_v cogatb_nv cogatb_q cogatb_g $2. cogatb_d $10. olsat_tot $2. olsat_v $2. olsat_nv best12. olsat_g best12. olsat_d $4. olsatb_tot $2. olsatb_v $2. olsatb_nv best12. olsatb_g best12. olsatb_d $4. tcs_tot $2. tcs_v $2. tcs_nv best12. tcs_g best12. tcs_d $4. tcsb_tot $2. tcsb_v $2. tcsb_nv best12. tcsb_g best12. tcsb_d $4. raven $2. raven_g best12. raven_d $4. raven1 $2. raven1_g best12. raven1_d $4. o_apt_name $2. o_apt_t best12. o_apt_v best12. o_apt_m best12. o_apt_q best12. o_apt_g best12. o_apt_d $4. o_apt1_nam $2. o_apt1_t best12. o_apt1_v best12. o_apt1_m best12. o_apt1_q best12. o_apt1_g best12. o_apt1_d $4. itbs_r $2. itbs_m $2. itbs_g best12. itbs_d $10. mat7_rc $2. mat7_mc best12. mat7_g best12. mat7_d $4. tn_tr $2. tn_tm best12. tn_g best12. tn_d $4. mapfr $2. mapfrrit best12. mapfrlxl best12. mapfm best12. mapfmrit best12. mapfg best12. mapfd $10. mapwr $2. mapwrrit best12. mapwrlxl best12. mapwm best12. mapwmrit best12. mapwg best12. mapwd $10. mapsr $2. mapsrrit best12. mapsrlxl best12. mapsm best12. mapsmrit best12. mapsg best12. mapsd $10. scr_ela $4. scr_math $4. scr_g $3. scr_d $10. pass_ela $3. pass_math $4. pass_g $3. pass_d $10. actrss $3. actmss best12. actg $3. actd $10. o_ach_name $2. o_ach_v best12. o_ach_m best12. o_ach_g best12. o_ach_d $4. o_ach1_nam $2. o_ach1_v best12. o_ach1_m best12. o_ach1_g best12. o_ach1_d $4. pd_gr $6. pd_g $6. pd_gr_d $10. ptp_v $2. ptp_nv $2. ptp_g best12. ptp_d $10. pti_v $2. pti_nv best12. pti_g best12. pti_d $10. apt_att $1. gtstatus $15. ngt $2. gtserve $5. aform $4. gtmodel $3. cm $1. cm1 $2. cm2 $2. cm3 $2. cm4 $2. cm5 $2. reviewteam $2. daname $7. datot $2. dav best12. danv best12. daq best12. dag best12. dad $10. dbname $6. dbe $2. dbr best12. dbm best12. dbg best12. dbd $10. dcname $2. dcv $2. dcnv best12. dcgpa $2. dcg best12. dcd $4. artstatus $2. artdanrfby $2. artdanname $2. artrfdan $4. artdanscr1 $2. artdanscr2 $2. artdanscr3 $2. artscdan $4. artdanstat $12. artdanmodl $5. artnedan $4. artdrarfby $2. artdraname $2. artrfdra $4. artdrascr1 $2. artdrascr2 $2. artdrascr3 $2. artscdra $4. artdrastat $12. artdramodl $5. artnedra $4. artmusrfby $2. artmusname $2. artrfmus $4. artmusscr1 $2. artmusscr2 $2. artmusscr3 $2. artscmus $4. artmusstat $12. artmusmodl $5. artnemus $4. artvarfby $2. artvaname $2. artrfva $4. artvascr1 $2. artvascr2 $2. artvascr3 $2. artscva $4. artvastat $12. artvamodl $5. artneva $4. achhistory $2. extran1 best12. extran2 best12. extrac1 $2. extrac2 $2. extrac3 $2. ; input sasi_id id10 stud_id stateid lname $ fname $ guardians $ address $ city $ state $ zip $ l_update $ phone $ dob sex $ race $ lunch $ grade $ lep $ iep $ sch_code $ school $ lschcode $ nschcode $ teacher $ del_d $ edate $ e1date $ e2date $ duprec $ check1 $ flag $ gtflag $ refrd $ refrd_d $ refpmr $ refnam $ cogat_t cogat_v cogat_nv cogat_q cogat_g cogat_d $ cogatb_t $ cogatb_v $ cogatb_nv $ cogatb_q $ cogatb_g $ cogatb_d $ olsat_tot $ olsat_v $ olsat_nv olsat_g olsat_d $ olsatb_tot $ olsatb_v $ olsatb_nv olsatb_g olsatb_d $ tcs_tot $ tcs_v $ tcs_nv tcs_g tcs_d $ tcsb_tot $ tcsb_v $ tcsb_nv tcsb_g tcsb_d $ raven $ raven_g raven_d $ raven1 $ raven1_g raven1_d $ o_apt_name $ o_apt_t o_apt_v o_apt_m o_apt_q o_apt_g o_apt_d $ o_apt1_nam $ o_apt1_t o_apt1_v o_apt1_m o_apt1_q o_apt1_g o_apt1_d $ itbs_r $ itbs_m $ itbs_g itbs_d $ mat7_rc mat7_mc mat7_g mat7_d $ tn_tr $ tn_tm tn_g tn_d $ mapfr mapfrrit mapfrlxl mapfm mapfmrit mapfg mapfd $ mapwr $ mapwrrit mapwrlxl mapwm mapwmrit mapwg mapwd $ mapsr $ mapsrrit mapsrlxl mapsm mapsmrit mapsg mapsd $ scr_ela $ scr_math $ scr_g $ scr_d $ pass_ela $ pass_math $ pass_g $ pass_d $ actrss $ actmss actg $ actd $ o_ach_name $ o_ach_v o_ach_m o_ach_g o_ach_d $ o_ach1_nam $ o_ach1_v o_ach1_m o_ach1_g o_ach1_d $ pd_gr $ pd_g $ pd_gr_d $ ptp_v $ ptp_nv $ ptp_g ptp_d $ pti_v $ pti_nv pti_g pti_d $ cutoffdate $ apt_att $ gtstatus $ ngt $ gtserve $ gift_date $ aform $ gtmodel $ cm $ cm1 $ cm2 $ cm3 $ cm4 $ cm5 $ reviewteam $ daname $ datot $ dav danv daq dag dad $ dbname $ dbe $ dbr dbm dbg dbd $ dcname $ dcv $ dcnv dcgpa $ dcg dcd $ artstatus $ artdanrfby $ artdanname $ artrfdan $ artdanscr1 $ artdanscr2 $ artdanscr3 $ artscdan $ artdanstat $ artdanmodl $ artnedan $ artdrarfby $ artdraname $ artrfdra $ artdrascr1 $ artdrascr2 $ artdrascr3 $ artscdra $ artdrastat $ artdramodl $ artnedra $ artmusrfby $ artmusname $ artrfmus $ artmusscr1 $ artmusscr2 $ artmusscr3 $ artscmus $ artmusstat $ artmusmodl $ artnemus $ artvarfby $ artvaname $ artrfva $ artvascr1 $ artvascr2 $ artvascr3 $ artscva $ artvastat $ artvamodl $ artneva $ achhistory $ extran1 extran2 extrac1 $ extrac2 $ extrac3 $ ; run; Problem Obs: (personal identifying data changed by me) SAS Output Obs school dob gift_date cutoffdate sasi_id id10 stud_id lname fname guardians address city state zip l_update phone sex race lunch grade lep iep sch_code lschcode nschcode teacher del_d edate e1date e2date duprec check1 flag gtflag refrd refrd_d refpmr refnam cogat_t cogat_v cogat_nv cogat_q cogat_g cogat_d cogatb_t cogatb_v cogatb_nv cogatb_q cogatb_g cogatb_d olsat_tot olsat_v olsat_nv olsat_g olsat_d olsatb_tot olsatb_v olsatb_nv olsatb_g olsatb_d tcs_tot tcs_v tcs_nv tcs_g tcs_d tcsb_tot tcsb_v tcsb_nv tcsb_g tcsb_d raven raven_g raven_d raven1 raven1_g raven1_d o_apt_name o_apt_t o_apt_v o_apt_m o_apt_q o_apt_g o_apt_d o_apt1_nam o_apt1_t o_apt1_v o_apt1_m o_apt1_q o_apt1_g o_apt1_d itbs_r itbs_m itbs_g itbs_d mat7_rc mat7_mc mat7_g mat7_d tn_tr tn_tm tn_g tn_d mapfr mapfrrit mapfrlxl mapfm mapfmrit mapfg mapfd mapwr mapwrrit mapwrlxl mapwm mapwmrit mapwg mapwd mapsr mapsrrit mapsrlxl mapsm mapsmrit mapsg mapsd scr_ela scr_math scr_g scr_d pass_ela pass_math pass_g pass_d actrss actmss actg actd o_ach_name o_ach_v o_ach_m o_ach_g o_ach_d o_ach1_nam o_ach1_v o_ach1_m o_ach1_g o_ach1_d pd_gr pd_g pd_gr_d ptp_v ptp_nv ptp_g ptp_d pti_v pti_nv pti_g pti_d apt_att gtstatus ngt gtserve aform gtmodel cm cm1 cm2 cm3 cm4 cm5 reviewteam daname datot dav danv daq dag dad dbname dbe dbr dbm dbg dbd dcname dcv dcnv dcgpa dcg dcd artstatus artdanrfby artdanname artrfdan artdanscr1 artdanscr2 artdanscr3 artscdan artdanstat artdanmodl artnedan artdrarfby artdraname artrfdra artdrascr1 artdrascr2 artdrascr3 artscdra artdrastat artdramodl artnedra artmusrfby artmusname artrfmus artmusscr1 artmusscr2 artmusscr3 artscmus artmusstat artmusmodl artnemus artvarfby artvaname artrfva artvascr1 artvascr2 artvascr3 artscva artvastat artvamodl artneva achhistory extran1 extran2 extrac1 extrac2 extrac3 stateid 5043 East High 20982 0 191 191 0 Smith Connor Pete "Maker Kyndle or Maker Hope "Ch" 136 Fair Pl TX 00643 555 12/ M W F 9 9 00 Left 30-01-000 8 Wats / / / / / / T F F / . . 0 0 0 0 0 / 0 0 0 0 0 / 0 0 0 0 / 0 0 0 0 / 0 0 0 0 / 0 0 0 0 . 0 0 . 0 0 . . 0 0 0 0 0 . . 0 0 0 0 0 / 0 0 0 . 0 0 0 . 0 0 0 . 93 240 0 47 225 8 . 0 0 0 0 0 0 . 91 241 0 58 235 8 04/1 743 583 8 05/0 0 0 . 0 0 . . 0 0 0 . . 0 0 0 / / 0 / 0 0 0 . 0 0 / 06/14/2000 0 No N/A 12/ 0 F . 0 0 0 0 0 / . 0 0 0 0 / . 0 0 0 / / / / Inel N/ / / / / Inel N/ / / / / Inel N/ / / / / Inel N/ . . 0 0 3003484000

GreggB · ‎12-19-2017

Code I have: data WORK.ONE ; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile "G:\Departments\Research\test scores\GT\&yr.\GIFT.csv" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; A few vars have double quotes surrounding them causing that obs to read in incorrectly. How can I edit the infile statement?

GreggB · ‎12-15-2017

Code: %let test=3701_Prelim_Score_Roster - %sysfunc(today(),ddmmyyn6.); I want this to resolve to 3701_Prelim_Score_Roster - 12DEC17 instead of 3701_Prelim_Score_Roster - 151217.

GreggB · ‎11-06-2017

I have 3 data sets (state, district, school). The State and District data sets listed below are the entire set but the school data set has 189 obs. After each obs in the school data set, I want to include the corresponding district and state observation based on the testgrade. DATA I WANT: recordtype schoolid Teacher testgrade elalev1pct1 elalev1pct2 elalev1pct3 3School 12 SMITH 3 100 0 0 2District 3701999 3 40.8 29 30.2 1State 9999999 3 40 28.6 31.4 3School 12 JONES 5 40 13.3 46.7 2District 3701999 5 44.5 30.8 24.6 1State 9999999 5 44.7 29.1 26.1 THE 3 DATA SETS I HAVE: DATA SET = STATE recordtype schoolid teacher testgrade elalev1pct1 elalev1pct2 elalev1pct3 1State 9999999 3 40 28.6 31.4 1State 9999999 4 45.4 31.3 23.3 1State 9999999 5 44.7 29.1 26.1 1State 9999999 6 49.9 23.5 26.6 1State 9999999 7 46.4 24.4 29.2 1State 9999999 8 46.2 26.9 26.9 DATA SET = DISTRICT recordtype schoolid teacher testgrade elalev1pct1 elalev1pct2 elalev1pct3 2District 3701999 3 40.8 29 30.2 2District 3701999 4 44.4 34 21.6 2District 3701999 5 44.5 30.8 24.6 2District 3701999 6 47.8 23.5 28.7 2District 3701999 7 46.3 26.3 27.5 2District 3701999 8 48.7 26.4 24.9 DATA SET = SCHOOL recordtype schoolid Teacher testgrade elalev1pct1 elalev1pct2 elalev1pct3 3School 12 SMITH 3 100 0 0 3School 12 JONES 5 40 13.3 46.7 3School 12 MOORE 4 8.3 25 66.7 3School 12 ABLE 7 27.8 27.8 44.4 3School 12 BAKER 8 31.6 36.8 31.6 3School 13 DELTA 6 30.7 34.2 35.1 3School 13 ECHO 4 0 8.3 91.7 3School 13 FOXTROT 3 9.5 52.4 38.1 3School 13 GAMMA 5 58.8 29.4 11.8

GreggB · ‎10-24-2017

my data set has the vars listed below (along with a unique student ID). The values can = . , 1, 2, 3 , 4 or 5. For each observation I only want to keep the scores that are ge 3. Next, I want to create a variable named MET_AP, which will be a string of the names of the exams with a value ge 3 separated by a dash (if more than one occurrence). Data I Want: ID MET_AP 1 APbio2015 - APchem2015 2 APcalcBC2015 - APlit2015 - APphys12015 3 APworldhist2015 List of variables with values = . , 1, 2, 3, 4, 5 APbio2015 APcalcAB2015 APcalcABsub2015 APcalcBC2015 APchem2015 APengl2015 APlit2015 APenv_scr2015 APphysB2015 APphys_elect2015 APphys_mech2015 APphys12015 APphys22015 APstats2015 APworldhist2015 APmacro2015 APmicro2015 APeurohist2015 APgovt2015 APgovt_US2015 APgeogr2015 APint_engl2015 APhist2015

GreggB · ‎10-12-2017

I have pre and post-test data that is expressed in percentiles. Is there a test of significance (maybe similar to McNemars) that would test to see if the gains (or losses) are significant at a certain confidence level? Essentially, did Instructor A's students make significant gains, significant losses, or neither? instructorID studentID Pre Post A 1 42 80 A 2 99 90 B 3 14 20 B 4 50 50

GreggB · ‎09-22-2017

sample data for dob: 12201999 01142000 10091998 Code I tried: dobm=substr(dob,1,2); dobd=substr(dob,3,2); doby=substr(dob,5,4); dobchar=compress(dobm||'/'||dobd||'/'||doby); dobnum=input(strip(dobchar),mmddyy10.); run; ERROR: NOTE: Invalid argument to function INPUT at line 622 column 8. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.

GreggB · ‎09-19-2017

This was much ado about nothing on my part. I deleted @1 line $char2601.; from the INPUT statement. I think the length of it was obstructing my view of the vars in question.

GreggB · ‎09-19-2017

This was much ado about nothing on my part. I deleted @1 line $char2601.; from the INPUT statement. I think the length of it was obstructing my view of the vars in question.

GreggB · ‎09-18-2017

My issue is that the variables dob, school and recnum are missing for all observations when I open "one" in work.library. When I submit PROC PRINT DATA=ONE the values for dob, school and recnum are there. I need these variables in a subsequent step in order to do some matching.

GreggB · ‎09-18-2017

The network drive just went down so that's all of the fun for today.

GreggB · ‎09-18-2017

"fine" was the wrong word. It ran without errors. I'm correcting the schcode format issue.

Online Status	Offline
Date Last Visited	‎05-18-2022 06:46 PM

comparing dates in different formats

using SCAN

Re: show cell values in heat map of a correlation matrix

show cell values in heat map of a correlation matrix

Re: proc sgplot

Re: proc sgplot

Re: proc sgplot

Re: proc sgplot

Re: proc sgplot

Re: proc sgplot

Re: using SCAN

Re: using SCAN

Re: using SCAN

Re: show cell values in heat map of a correlation matrix

Re: proc sgplot

finding columns that are blank

Re: proc sgplot

SAS profile error on load

accidental change in my cursor

Re: proc import vs. libname when reading an xlsx file

Re: Matching on a non-unique variable ?

Matching on a non-unique variable ?

Double clicking a SAS file on Windows 10

Re: Reading a .csv file into SAS with double quotes

Reading a .csv file into SAS with double quotes

%let containing today's date

Interleaving

array processing (?)

Test of Significance for paired data

convert a string to a date value

Re: Macro help - defined variables are all missing

Re: Macro help - defined variables are all missing

Re: Macro help - defined variables are all missing

Re: Macro help - defined variables are all missing

Re: Macro help - defined variables are all missing

SAS Analytics Explorers