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 .
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.