filename copy temp; data _null_; infile proc import datafile="G:\Departments\Research\test scores\EndOfCourse\2021\Spring\Preliminary_Score_Ro - 26MAY21.csv" firstobs=4 ; file copy; input; put _infile_; run; proc import datafile=copy dbms=csv out=eoc replace; guessingrows=all; run; LOG 96 filename copy temp; 97 data _null_; 98 infile proc import datafile="G:\Departments\Research\test ------ 23 ERROR 23-2: Invalid option name IMPORT. 98 ! infile proc import datafile="G:\Departments\Research\test -------- 23 98 ! scores\Preliminary_Score_Ro - 26MAY21.csv" ERROR 23-2: Invalid option name DATAFILE. 99 firstobs=4 100 ; 101 file copy; 102 input; 103 put _infile_; 104 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 105 proc import datafile=copy dbms=csv out=eoc replace; 106 guessingrows=all; 107 run; WARNING: Physical file does not exist, C:\Users\XXXXX\AppData\Local\Temp\SAS Temporary Files\_TD1356_5CG9231V8L_\#LN00077. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds ... View more

That reads the data in nicely. I was hoping to be able to get the values in row 1 and assign them as variable names (without have to use the RENAME option in the data step.   Obs Data_extract_produced_by_28BCB4 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8 VAR9 VAR10 VAR11 VAR12 VAR13 VAR14 VAR15 VAR16 VAR17 VAR18 VAR19 VAR20 VAR21 VAR22 VAR23 VAR24 VAR25 1 Time Posted Teacher SIS Code Student Last Name Student First Name MI Subject Scale Score Letter Grade Test Indicator Tested School Name Tested School Code Reported School Code SC Virtual School Program Bubbled Last Name Bubbled First Name Bubbled MI State ID Student ID PS Grade Race/Ethnicity Gender Birthdate Course Number Course Name ... View more

data I have: School TeamLead enrichID ps_Last ps_first Keowee Bravo, Echo 21004 West Ken data I want: School TeamLead enrichID ps_Last ps_first hlink North smith, joe 12345 delta alpha =HYPERLINK("https://docs.google.com/forms/d/e/viewform?usp=pp_url&entry.1462554928="&B2&"&entry.756145072="&A2&"&entry.1518077367="&C2&"&entry.1394336521="&E2&"&entry.127408784="&D2&   This is observation 1. the hyperlink for observation 2 follows below. The salient point is that B2 is now B3, A2 is now  A3, etc.   =HYPERLINK("https://docs.google.com/forms/d/e/viewform?usp=pp_url&entry.1462554928="&B3&"&entry.756145072="&A3&"&entry.1518077367="&C3&"&entry.1394336521="&E3&"&entry.127408784="&D3&"     ... View more

Correct. ... View more

difficult to explain..."IEP SDOC@Home" (in red) actually looks like the the red text at the bottom left. ID LAST_NAME FIRST_NAME MIDDLE_NAME DOB GENDER GRADE_LEVEL STATE_STUDENTNUMBER STUDENT_NUMBER ALERT_OTHER GUARDIANEMAIL HOME_PHONE STREET CITY ZIP COURSE_NUMBER SECTION_NUMBER TERMID CC_SCHOOLID PREVTCHNUM TEACHERNUMBER TCHFIRST TCHMID TCHLAST STATUS EMAIL COURSE_NAME ENGL_PROF 23509 **** Ca***** S**** 1/16/2017 M 8 5687983422 10*** IEP ************cess03@gmail.com 864-***-***8 231 *** H*** Dr M****** Rest 29664 2916C202 1 3000 30 8351 7391 A** * ****ad 1 *****ad@sdoc.org MS Science 9 23551 ******* Dan*** ****** 12/25/2007 M 7 ********* 10*** "IEP SDOC@Home" krisneddie143@gmail.com 810-***-0*** *** ******* Ln Seneca 29672 2.92E+03 20 3000 26 1590 2587 ******er B Williams 1 jb*******@sdoc.org MS Lang Arts 9 23551 ******* Dan*** ****** 8/30/2007 M 7 5854056186 10631 "IEP SDOC@Home" krisneddie143@gmail.com 810-558-0765 *** ******* Ln Seneca 29672 2110M700 15 3000 26 22414 9261 *****lle R K***** 1 i******@sdoc.org Mathematics 7 9 "IEP SDOC@Home" ... View more

1. I used the </> icon. 2. I copied from the log. ***** are to mask the data 3. No embedded chars 4. I copied from the LOG. Do you want a PROC  PRINT?   ... View more

1584 SDOC@Home","**********143@gmail.com","810-***-****","215 Jas*** Ln","Seneca","29672","2 89 110M700","15",3000,26,22414,"9261","******","R","Ki****",1,"i******@sdoc.org","Mathema 177 tics 7","9" 187 ID=. LAST_NAME=****143@gmail.com FIRST_NAME=810-***- **** MIDDLE_NAME=2** Jas*** Ln DOB=Seneca GENDER=29 GRADE_LEVEL=. STATE_STUDENTNUMBER=15 STUDENT_NUMBER=3000 ALERT_OTHER=26 GUARDIANEMAIL=22414 HOME_PHONE=9**1 STREET=I******* CITY=R ZIP=K***** COURSE_NUMBER=1 SECTION_NUMBER=i******@sdoc.org TERMID=. CC_SCHOOLID=9 PREVTCHNUM= TEACHERNUMBER= TCHFIRST= TCHMID= TCHLAST= STATUS=. EMAIL= COURSE_NAME= ENGL_PROF= _ERROR_=1 _N_=1583 ... View more

Observation 23262 is the continuation of 23261 . "IEP causes a return to a new line ... View more