hi all i have tried the code mentioned in the above doc
libname new 'C:\Users\nitesh\Documents\My SAS Files\9.4';
filename trans 'C:\Users\nitesh\Downloads\ZIPPROCSQL';
proc cimport library=new infile=trans;
run;
libname sql 'C:\Users\nitesh\Documents\My SAS Files\9.4';
but i am getting error in proc stmt. is there any other way to do it.
thank you.
That is because the REAL SAS TABLE which is attached with this VIEW is missing/gone . You can't open this view unless the REAL table is included in .
Please post log with the code and the error message.
188 libname new 'C:\Users\nitesh\Documents\My SAS Files\9.4';
NOTE: Libref NEW refers to the same physical library as SASUSER.
NOTE: Libref NEW was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\nitesh\Documents\My SAS Files\9.4
189 filename trans 'C:\Users\nitesh\Downloads\ZIPPROCSQL';
190
191 proc cimport library=new infile=trans;
192 run;
ERROR: Invalid file, C:\Users\nitesh\Downloads\ZIPPROCSQL.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE CIMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
193
194 libname sql 'C:\Users\nitesh\Documents\My SAS Files\9.4';
NOTE: Libref SQL refers to the same physical library as NEW.
NOTE: Libref SQL was successfully assigned as follows:
Engine: V9
Physical Name: C:\Users\nitesh\Documents\My SAS Files\9.4
I would suspect that the issue is either a misspelling or missing file extenstion in your file C:\Users\nitesh\Downloads\ZIPPROCSQL .
Make sure that the full file name is used. If there is an extension to the file then use it. If the file you want to import is in a folder name ZIPPROCSQL then add it to the filename.
Less likely could be a lack of permission to read the file, check for file properties.
it was a zipfile and i extracted it in a folder
@Ksharp .sasview files
getting the above msg
That is because the REAL SAS TABLE which is attached with this VIEW is missing/gone . You can't open this view unless the REAL table is included in .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.