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: 
Chris_C
‎11-29-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Adding Variables to SAS after importing an excel document

by Calcite | Level 5 in SAS Programming
‎11-28-2018 10:58 PM
‎11-28-2018 10:58 PM
The Data is not mine I am just doing some volunteer work to help an old high school teacher out so I am hesitant to alter the data that was provided to me. There are multiple excel sheets for classes so I planned on stacking them together and the easiest way to read would be if they were in the wide rows.   @Tom   Obs Year Exam Day Time Type Q1 Q2 Q3 Q4 Q5 Q6 Overall 1 . . Percent 0 29.7 0 0 0 0 4.9 2 2 B 2 Mid Hours 0 5.8 0 0 0 0 5.8   ... View more

Re: Adding Variables to SAS after importing an excel document

by Calcite | Level 5 in SAS Programming
‎11-28-2018 09:33 PM
‎11-28-2018 09:33 PM
The file is .xlsx and here is the code I am using @r_behata.   PROC IMPORT OUT= WORK.ExamBDay4_0             DATAFILE= "\\Client\D$\SASDATA\Year_2_Exam_B_Day_4_0-morning.xlsx"             DBMS=EXCELCS REPLACE;      RANGE="Sheet1$"; RUN; DATA ExamBDay4_0; SET ExamBDay4_0; INPUT Q1_Hours Q1 Percent Q2_Hours Q2_Percent Q3_Hours Q3_Percent Q4_Hours Q4_Percent Q5_Hours Q5_Percent Q6_Hours Q6_Percent Overall_Hours Overall_Percent; RUN; PROC PRINT DATA=ExamBDay4_0; RUN;QUIT; ... View more

Adding Variables to SAS after importing an excel document

by Calcite | Level 5 in SAS Programming
‎11-28-2018 08:18 PM
‎11-28-2018 08:18 PM
 While working with an excel document I want to condense the data into one row by adding variables Q1_Hours and Q1_Percent through Q6_Hours and Q6_Percent. I am confused because the normal ways to create variables through the INPUT after the data step is not working. One section of the data looks as follows (In the excel document). Anyone have any advice or tips?   Year Exam Day Time Type Q1 Q2 Q3 Q4 Q5 Q6 Overall 2 B 4 Mid Hours 0.0 13.3 7.5 0.0 0.0 7.5 28.3         Percent 0.0 98.6 38.9 0.0 0.0 57.3 32.5 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-29-2018 09:01 AM
Quick links