topic Re: convert/import sas view tables to data sets in SAS Programming

convert/import sas view tables to data sets

nit123 — Thu, 31 Dec 2015 02:36:24 GMT

hi all i have tried the code mentioned in the above doc

http://support.sas.com/documentation/cdl/en/sqlproc/69049/HTML/default/viewer.htm#n0jov4xsixn4dqn12dn5zfk4qstz.htm

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.

Re: convert/import sas view tables to data sets

ballardw — Wed, 30 Dec 2015 17:18:20 GMT

Please post log with the code and the error message.

Re: convert/import sas view tables to data sets

nit123 — Wed, 30 Dec 2015 17:41:59 GMT

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

Re: convert/import sas view tables to data sets

ballardw — Wed, 30 Dec 2015 18:44:34 GMT

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.

Re: convert/import sas view tables to data sets

nit123 — Wed, 30 Dec 2015 18:47:04 GMT

it was a zipfile and i extracted it in a folder

Re: convert/import sas view tables to data sets

Ksharp — Thu, 31 Dec 2015 01:42:55 GMT

That is to say ZIPPROCSQL file is not SAS Transfer File ? so you can't use proc cimport for that file.
Unzip it firstly and see what exactly this file is .

Re: convert/import sas view tables to data sets

nit123 — Thu, 31 Dec 2015 01:44:56 GMT

@Ksharp .sasview files

Re: convert/import sas view tables to data sets

Ksharp — Thu, 31 Dec 2015 01:53:49 GMT

If that was a SAS VIEW file, just double click it in SAS and it will be open ,no need other SAS code .

Re: convert/import sas view tables to data sets

nit123 — Thu, 31 Dec 2015 01:57:53 GMT

getting the above msg

Re: convert/import sas view tables to data sets

Ksharp — Thu, 31 Dec 2015 02:32:26 GMT

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 .