topic Re: create libraries that are assigned automatically in New SAS User

create libraries that are assigned automatically

Sarra-Matri — Sat, 08 May 2021 01:19:32 GMT

in my Sas studio i imported csv files into a new folder and i created from csv tables of other SAS by using proc procedure .

now i have to create library that is assigned automatically. When i type libname mylib "path of folder" it works but the library is empty

any help please?

Re: create libraries that are assigned automatically

SASKiwi — Sat, 08 May 2021 02:53:51 GMT

Please post the code you are using to create the library and to add tables to it.

Re: create libraries that are assigned automatically

Sarra-Matri — Sat, 08 May 2021 13:49:38 GMT

The following code is to import csv files :
PROC IMPORT DATAFILE="/home/u58228061/my_project/country_classification.csv"
DBMS=CSV
OUT=country_classification;
RUN;

PROC IMPORT DATAFILE="/home/u58228061/my_project/goods_classification.csv"
DBMS=CSV
OUT=goods_classification;
RUN;
PROC IMPORT DATAFILE="/home/u58228061/my_project/gsquarterly_december-2020-revised.csv"
DBMS=CSV
OUT=gsquarterly_december_revised;
RUN;

For creating librabry i tried this :
Libname mylib "/home/u58228061/my_project";

Re: create libraries that are assigned automatically

SASKiwi — Sun, 09 May 2021 00:25:44 GMT

Try this:

Libname mylib "/home/u58228061/my_project";

PROC IMPORT DATAFILE="/home/u58228061/my_project/country_classification.csv"
DBMS=CSV
OUT= mylib.country_classification;
RUN;

PROC IMPORT DATAFILE="/home/u58228061/my_project/goods_classification.csv"
DBMS=CSV
OUT= mylib.goods_classification;
RUN;
PROC IMPORT DATAFILE="/home/u58228061/my_project/gsquarterly_december-2020-revised.csv"
DBMS=CSV
OUT= mylib.gsquarterly_december_revised;
RUN;