This macro seems to work fine except that my defined vars (school, dob and recnum) are all blank when I open data set ONE in the work library. However, when I submit the PROC PRINT DATA=ONE  statement all of those defined vars show up in the output as I expect. Vars in question are colored red.   code: %MACRO getdata(file=); DATA a&file;    INFILE  "G:\Departments\Research\test scores\SAT\&year.\&file..txt" truncover lrecl=2601;    INPUT  schcode $1-6 cohort_year $59-62 last $113-147 first $148-182 mi $183 sex $184 ethnic $201-202 dobchar $203-212 student_id $234-263 gradyr $635-638 gradmon $640-641 graddate $635-641 testyr $659-662 testmon $664-665 testday $667-668 testdate $659-668 gr $669-670 total_rd 672-675 eb_read_write_sect_rd 676-678 math_sect_rd 679-681 read_rd 682-683 writ_lang_rd 684-685 math_rd 686-689 science_rd 690-691 socstud_rd 692-693 words_context_sub_rd 694-695 evidence_sub_rd 696-697 expr_ideas_sub_rd 698-699 eng_conv_sub_rd 700-701 algebra_sub_rd 702-703 adv_math_sub_rd 704-705 prob_data_analysis_sub_rd 706-707 essay_read_sub_rd 708 essay_analysis_sub_rd 709 essay_writ_sub_rd 710 gpa $1912-1913 yrsart $1933-1935 yrseng $1936-1938 yrslang $1939-1941 yrsmath $1942-1944 yrssci $1945-1947  yrssoc $1948-1950 activ $2131 sports $2202 @1 line $char2601.;        *** DEFINE SCHOOL. ***;    school=put(schcode,actfmt.);    *** DEFINE DOB. ***;    dob=input(dobchar,yymmdd10.);   RUN; %MEND; %getdata(file=104268_SAT_ 20170605_000023); %getdata( file=104268_SAT_20170620_ 000024);   DATA one; SET a104268_SAT_20170630_000025         a104268_SAT_20170605_000023 ;    *** DEFINE RECORD NUMBER. ***;    recnum=_n_; run; proc print data=one; run; ... View more

My code is below. My approach is clunky at best. I submit it, see if there is an error, adjust the code and resubmit. How can I edit it so that SAS determines the dimensions needed?     data coregrades; set core2; format mark1-mark5 $3. course_name1-course_name5 $8. name1-name5 $30. point1-point5 1. course_number1-course_number5 $8.; by student_number; retain name1-name5 course_name1-course_name5 mark1-mark5 point1-point5 course_number1-course_number5; if first.student_number then do; name1=' '; name2=' '; name3=' '; name4=' '; name5=' '; course_name1=' '; course_name2=' '; course_name3=' '; course_name4=' '; course_name5=' '; mark1=' '; mark2=' '; mark3=' '; mark4=' '; mark5=' '; point1=.; point2=.; point3=.; point4=.; point5=.; course_number1=' ';course_number2=' ';course_number3=' ';course_number4=' ';course_number5=' '; markcount=1; end; array names {5} name1-name5; array course_names {5} course_name1-course_name5; array marks {5} mark1-mark5; array points {5} point1-point5; array course_numbers {5} course_number1-course_number5; names {markcount} = name; course_names {markcount} = course_name; marks {markcount} = mark; points {markcount} = point; course_numbers {markcount} = course_number; markcount+1; drop name course_name mark point course_number; if last.student_number; run; ... View more

Is it possible to suppress the rows that show the n count? I only want percentages   Code: ods pdf file='fakepath.pdf'; proc tabulate data=one; where elatook ne ''; class efagrade /*school*/; class elalev1 elalev2; tables elalev1='Literary Text'*(n*f=6.0 pctn<elalev1>='PCT'*f=6.0) all='TOTAL'*(n*f=6.0) elalev2='(LT)Meaning/Context'*(n*f=6.0 pctn<elalev2>='PCT'*f=6.0) all='TOTAL'*(n*f=6.0) efagrade='Grade' all='Total' /rts=25 misstext='0' printmiss; format elalev1-elalev2 perf.; run; ODS pdf close; ... View more

SAS appears to resolve the macro variable &shyr. The error occurs in the DATA step when I attempt to create a permanent data set.   My code: options SYMBOLGEN; %let yr=2017; %let shyr=%qsubstr(&yr,3,2); %put &shyr; ***** LIBNAME *****; libname eocep "G:\Departments\Research\test scores\EndOfCourse\&yr."; data one; .. run; /*the data step is error-free*/   *CREATE RAW PERM DATA SET*; data eocep.eocep_spr&shyr._raw; set one; run;   LOG:   177 *CREATE RAW PERM DATA SET*; SYMBOLGEN: Macro variable SHYR resolves to 17 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 178 data eocep.eocep_spr&shyr._raw; NOTE: Line generated by the macro variable "SHYR". 1 eocep.eocep_spr17_raw                                --                               22                                 --                                200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored. 179 set one; 180 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set EOCEP.EOCEP_SPR may be incomplete. When this step was stopped there were 0 observations and 142 variables. WARNING: Data set EOCEP.EOCEP_SPR was not replaced because this step was stopped. WARNING: The data set WORK._RAW may be incomplete. When this step was stopped there were 0 observations and 142 variables. WARNING: Data set WORK._RAW was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.01 seconds ... View more

I keep reading conflicting info.  Does CALL SYMPUTX automatically convert the value assigned to the macro variable to character (assuming it is numeric) or is the numeric format preserved? ... View more

I need to calculate when this person turned 6 and then count the the number of days from the servedate to the date he turned six, essentially TurnedSix-Servedate (expressed in days)   data temp; infile datalines dsd missover; informat dob servedate mmddyy8.; input dob servedate; cards; 10/20/10, 01/20/16 ; run; proc print; format dob servedate mmddyy.; run; data need; set temp; TurnedSix= ; DaysServed= ; run; ... View more

Can 2 different tables be created in a single proc sql statement or does it require 2 different statements?   PROC SQL; CREATE TABLE WORK.PAYROLLMASTER AS SELECT * FROM SASUSER.PAYROLLMASTER; QUIT; PROC SQL; CREATE TABLE WORK.MARCHFLIGHTS AS SELECT * FROM SASUSER.MARCHFLIGHTS; QUIT; ... View more

I have the var Code1 that has the following values: Code1 Frequency *DD  *OHI AU  EH  HH  ID   LD  MD  OH  SP  VH   They are formatted like so: proc format; value $ iepfmt EM='1. Intellectual Disabilities' TM='1. Intellectual Disabilities' HH='2. Hearing Impairments' SP='3. Speech Impairments' VH='4. Visual Impairments' EH='5. Emotional Disturbance' OH='6. Orthopedic Impairments' '*OHI'='7. Other Health Impairments' LD='8. Specific Learning Disabilities' MD='10. Multiple Disabilities' AU='11. Autism' '*TBI'='12. Traumatic Brain Injury' '*DD'='13. Developmental Delay' ID='1. Intellectual Disabilities' '*PMD'='1. Intellectual Disabilities' ; run; I want to sort the variable Code 1 according to the number in char string of the format so that '1. Intellectual Disabilities'  appears first etc and '13. Developmental Delay'  appears last in the printout.       ... View more