Can this DATA step be incorporated into the PROC SQL step so that course_numbers beginning with '08' are excluded when table stud4 is created?    proc sql; create table stud4 as SELECT S.*,CC.COURSE_NUMBER, CC.SECTION_NUMBER, CC.SCHOOLID as cc_schoolID, T.TEACHERNUMBER, T.LASTFIRST as TEACHER, courses.course_name FROM stud3b as s left join myoracle.cc as cc on s.ID=cc.studentid left join myoracle.teachers as t on cc.teacherid=t.ID left join myoracle.COURSES as courses on cc.COURSE_NUMBER=courses.course_number where cc.termid ge 2800 order by s.student_number; quit; data stud4a; set stud4; if course_number in:('08') then delete; run; ... View more

I just downloaded and installed SAS/ACCESS Interface to ODBC. I'm running SAS 9.4 on Windows 64 bit machine.    My task is to connect to a  live oracle database (known as Powerschool).    The IT dept gave me this info (changed to nonsense in this post):   datasrc=fakesource user=fakeuser password=fakepw;   SAS LOG   libname mydblib odbc datasrc=fakesource user=fakeuser password=XXXXXXXXXX; ERROR: The ODBC engine cannot be found. ERROR: Error in the LIBNAME statement.   ... View more

  I want to use proc format on the values below. Example:  1.0-1.9 is 'Pre-functional'. I have to format them as character due to other values such as P1,P2, etc.   will this work?   proc format; value $ engproffmt '1.0 - < 1.9' = 'Pre-functional';     1.0-1.9 2.0-2.9 3.0-3.9 4.0-4.9 5.0-5.9 6.0 P1 P2 P3 P4 8 9 W X ... View more

  dates vary in length. single digit months and single digit days do not have leading zeroes. WHENCREATED 9/20/2018 7:58 AM 9/2/2018 7:00 AM 11/20/2018 9:58 AM     data WORK.CHRONIC_ABSENTEEISM; infile 'G:\FAKEPATH\Chronic_Absenteeism.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; informat WHENCREATED ???; format SchoolYear 4. CollectionID $4. DISTRICTCODE 4.; input SchoolYear CollectionID $ DISTRICTCODE WHENCREATED; run; ... View more

I want to learn how to export html files to our organization's website. Is this the documentation I should use?   https://documentation.sas.com/api/docsets/pcfsicg/9.4/content/pcfsicg.pdf?locale=en     ... View more

my data looks like: DOB 08/13/2003   what I want: month    day       year Aug         13         03   This is to help students with bubbling an answer document.        ... View more

Data I have:   ID             ELASS  MATHSS SCISS SOCSS 1                  100 1                               210 1                                               325 1                                                            225 2                  120        2                              225            2                                               410       2                                                            228   I want one obs per ID, like so:   ID             ELASS  MATHSS SCISS SOCSS 1                 100        210          325     225 2                  120       225          410     228 ... View more

 I'm using PROC REPORT and outputting a pdf file using ODS. I want to preserve the blanks. For example, the 1 should be centered under Standard.   my output:         my footnote statements: footnote1 height=9pt "Standard Grade 3 Grade 4–5 Grade 6 Grade 7 Grade 8"; footnote2 height=9pt " 1 Number Sense and Base Ten Number Sense and Base Ten The Number System The Number System The Number System";   ... View more

I need to ensure that the header rows of these 6 files are identical before I combine them into one data set.   Code:   %macro getdata(num=,dsn=); proc import datafile="G:\Departments\Research\test scores\SC_ALT\2018\School_District_of_Oconee_County_4604-Grade_&num..csv" out=&dsn dbms=dlm; delimiter=','; guessingrows=all; run; proc contents data=&dsn varnum; title"&dsn."; run; %mend; %getdata(num=3,dsn=gr3); %getdata(num=4,dsn=gr4); %getdata(num=5,dsn=gr5); %getdata(num=6,dsn=gr6); %getdata(num=7,dsn=gr7); %getdata(num=8,dsn=gr8); ... View more

my data set :   student    session      test_date        grade  able             1              nov 30              11 baker                           nov 30              11 charlie                         nov 30               12 delta             2             nov 30               10 echo                            nov 30               12 foxtrot                          nov 30               11   what I want:   student    session      test_date        grade  able             1              nov 30              11 baker           1              nov 30              11 charlie          1             nov 30               12 delta             2             nov 30               10 echo             2              nov 30               12 foxtrot           2             nov 30               11   I found this code in a previous post but don't know how to apply it:   %macro process(variable); retain help_&variable; if not missing(&variable) then _&variable = &variable; else &variable = _&variable; drop _&variable; %mend; data want; set have; %process(sex) %process(country) %process(period) run; ... View more