Hey Kieng, Really appreciate the work you have put in to make these videos. Personally, I think they are fantastic and way better than any of the paid SAS tutorials I have reviewed. I have one question I'd like to ask you, I'm using SAS EG but learning the syntax from the Base SAS to understand concepts just on a high level. The question is when I import an excel file and view the system generated code, I happen to notice the letters 'n' and the character '$' towards the end just before the semi-colon. Do you know what is the reason for that? Cheers!
I am having issues with the pathing - under the PROC IMPORT, datafile= “C:\Users\shaworth2\Documents\tabdelim.txt”; keeps adding a = to the end in the log and says it can be read. Any advice?
Dear Kieng, When trying to import the respective txt file, I receive the following error: ERROR: Physical file does not exist, /sas/prd/software/config/Lev1/SASApp_TACM/C:\Users\valena\Desktop\SAS\Tutorials\Delimited.txt. Any idea how to deal with this issue? Thanks in advance!
/* Importing Excel Files*/ PROC IMPORT OUT= Trans_April DATAFILE= "/folders/myfolders/sasuser.v94/Program_Structure/Trans_April.xlsx" DBMS=XLSX REPLACE; GETNAMES = YES; /*Put yes if the first row is the headers*/ MIXED = YES; USEDATE= YES; SCANTIME=YES; RANGE="Trans_Apr$"; RUN; Does not work. Log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 74 PROC IMPORT OUT= Trans_April 75 DATAFILE= "/folders/myfolders/sasuser.v94/Program_Structure/Trans_April.xlsx" 76 DBMS=XLSX REPLACE; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 77 GETNAMES = YES; /*Put yes if the first row is the headers*/ 78 MIXED = YES; _____ 180 79 USEDATE= YES; _______ 180 80 SCANTIME=YES; ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order.
81 RANGE="Trans_Apr$"; 82 RUN;
Couldn't find range in spreadsheet Requested Input File Is Invalid 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.01 seconds cpu time 0.00 seconds
Hey Kieng,
Really appreciate the work you have put in to make these videos. Personally, I think they are fantastic and way better than any of the paid SAS tutorials I have reviewed.
I have one question I'd like to ask you, I'm using SAS EG but learning the syntax from the Base SAS to understand concepts just on a high level. The question is when I import an excel file and view the system generated code, I happen to notice the letters 'n' and the character '$' towards the end just before the semi-colon. Do you know what is the reason for that?
Cheers!
I am having issues with the pathing - under the PROC IMPORT, datafile= “C:\Users\shaworth2\Documents\tabdelim.txt”; keeps adding a = to the end in the log and says it can be read. Any advice?
Dear Kieng,
When trying to import the respective txt file, I receive the following error:
ERROR: Physical file does not exist, /sas/prd/software/config/Lev1/SASApp_TACM/C:\Users\valena\Desktop\SAS\Tutorials\Delimited.txt.
Any idea how to deal with this issue? Thanks in advance!
I LOVE YOU ROMULO ❤
missed the semi colon from the DATA .
Great vid
Why is your last name pronounced "i, v"
/* Importing Excel Files*/
PROC IMPORT OUT= Trans_April
DATAFILE= "/folders/myfolders/sasuser.v94/Program_Structure/Trans_April.xlsx"
DBMS=XLSX REPLACE;
GETNAMES = YES; /*Put yes if the first row is the headers*/
MIXED = YES;
USEDATE= YES;
SCANTIME=YES;
RANGE="Trans_Apr$";
RUN;
Does not work.
Log
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73
74 PROC IMPORT OUT= Trans_April
75 DATAFILE= "/folders/myfolders/sasuser.v94/Program_Structure/Trans_April.xlsx"
76 DBMS=XLSX REPLACE;
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
77 GETNAMES = YES; /*Put yes if the first row is the headers*/
78 MIXED = YES;
_____
180
79 USEDATE= YES;
_______
180
80 SCANTIME=YES;
________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
81 RANGE="Trans_Apr$";
82 RUN;
Couldn't find range in spreadsheet
Requested Input File Is Invalid
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.01 seconds
cpu time 0.00 seconds
83
84
85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
97
START LEARNING SAS from this top training center
www.grafx-itsolutions.com/courses/latestcourses/sas.html