Run this program on your desktop (assuming the data are located on your Windows machine).<\/em><\/p>\nFILENAME trans “C:\\Users\\AnnMaria\\Documents\\oldpeople\\sasdata\\trans” ;
\nLIBNAME in “h:\\sasdata” ;
\nPROC CPORT LIBRARY= in FILE = trans MEMTYPE = CATALOG ;<\/p>\n
The FILENAME statement specifies where you want your transport file written, the LIBNAME statement is where your format catalog is located.<\/p>\n
So, this created a transport file to upload.<\/p>\n
3. USE PROC CIMPORT to import the formats<\/strong><\/p>\nRun this program on SAS Web Editor<\/em><\/p>\nFILENAME mydata “\/courses\/myuniv\/dir\/otherdir\/trans” ;
\nLIBNAME test “~\/Projects\/oldpeople\/sasdata\/formats\/ ” ;
\nPROC CIMPORT LIBRARY = test INFILE = mydata ;<\/p>\n
The FILENAME statement refers to the file you created in the previous step.<\/p>\n
The LIBNAME statement is where you want the formats written. This directory must already exist.<\/p>\n
4. Now you’re ready to access your data using SAS Web Editor<\/strong><\/p>\nLIBNAME in “\/courses\/myuniv\/dir\/otherdir\/” access=readonly;
\nLIBNAME saslib “~\/Projects\/oldpeople\/sasdata\/formats\/ ” ;
\nOPTIONS FMTSEARCH = (saslib) ;<\/p>\n
The first LIBNAME statement is the course directory where you uploaded your data<\/strong> .<\/p>\nThe second LIBNAME statement is the folder in the Projects folder where you stored the formats<\/strong>. You could put them in a subdirectory of the same course directory where you uploaded your data. You could put them almost anywhere, really.<\/p>\nOPTIONS FMTSEARCH = tells SAS where to search for the formats it expects.<\/p>\n
<\/p>\n
P.S. Thanks to Tom Edds from SAS for suggesting the cport\/cimport .<\/p>\n","protected":false},"excerpt":{"rendered":"
My saga on uploading and reading an older data set into SAS Web Editor 1. Use FTP to upload So, I did get my data uploaded to SAS Web Editor using ftp. Little hint here, if you are using Filezilla and having trouble connecting, check to make sure that Filezilla is not using sftp. Sometimes…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,8],"tags":[],"class_list":["post-3318","post","type-post","status-publish","format-standard","hentry","category-software","category-technology"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/3318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/comments?post=3318"}],"version-history":[{"count":3,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/3318\/revisions"}],"predecessor-version":[{"id":3320,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/3318\/revisions\/3320"}],"wp:attachment":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media?parent=3318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/categories?post=3318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/tags?post=3318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}