topic Re: How do I use a file saved in my library in SAS Software for Learning Community

How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 20:02:41 GMT

DATA SoilData;
INPUT Year $ Sample $ Treatment $ Salts $ OM $ NH4 $ NO3 $ P $ @@;
compost.compiled;
run;

PROC Print data=SoilData;
run;

I get an error message

ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase.

ERROR 557-185: Variable compost is not an object.

Re: How do I use a file saved in my library

Reeza — Wed, 14 Sep 2022 20:29:51 GMT

Your first set of code doesn't specify an input location of where to get the data from.

INPUT implies you're trying to read from a text file originally?

Re: How do I use a file saved in my library

ballardw — Wed, 14 Sep 2022 20:32:14 GMT

If you want to use an existing data set in a data step you would typically use SET libname.datasetname.

Other statements that may be used to bring in data from existing data sets would be MERGE, to combine data record by record from two or more sets, and UPDATE or MODIFY for specific approaches to changing values of variables when the new value are in a separate data set.

The particular error you show is because you used a code construct with a point between elements that SAS cannot recognize what you intended.

Re: How do I use a file saved in my library

Reeza — Wed, 14 Sep 2022 20:35:12 GMT

How to use a file you have that already exists, SAS7BDAT

*Path to where the files are stored;
libname myFiles '/home/fkhurshed/Demo1/';

*creates a data set called Sample in the work library;
Data sample;
set myFIles.inputData; *assigns it the data set inputData from the myFiles folder;
run;

*use the file directly without creating a temporary copy;
proc freq data=myFiles.inputData;
table Age Sex;
run;

If it's a text file, you first need to import it into SAS then you can use it.

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 20:40:20 GMT

I already have the file stored in my library and saved to folder compost named compiled. When i open it it gives me my table. I need to be able to insert my table into my program so i can run code on it. So instead of hand typing the hundreds of lines what is the notation for adding the file i have saved in my library?

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 20:44:13 GMT

I am using an excel file i have imported into sas and then saved to my library. I am trying to have the table it generates show up in sas so i can run analytics on it. does that make sense?

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 20:45:37 GMT

It is an excel file. I have read and watched videos online on how to import data into sas which i can do. The problem i have is what do you do once it is saved in sas. How do you access it to run code on it. Instead of hand typing the data i should be able to reference it. But when i do i get this error code.

Re: How do I use a file saved in my library

Reeza — Wed, 14 Sep 2022 20:51:53 GMT

So instead of the myFiles library in my example use the compiled library.

What is the data set name?

You would not be using any INPUT if the data set is already created, only the SET statement as in the example posted.

data class;
set sashelp.class;
run;

proc freq data=sashelp.class;
table age sex;
run;

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 20:54:45 GMT

When i run this line
data SoilAnaylsis;
set compost.compiled;
run;
it then gives me the error
The table "WORK.SOILANAYLSIS" cannot be opened because it does not contain any columns.

which is why i input the column names

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 20:58:31 GMT

for some reason my table didnt have columns. So i reimported the table and now it is working.

Re: How do I use a file saved in my library

Tom — Wed, 14 Sep 2022 21:03:26 GMT

The only reason that the dataset SOILANAYLSIS created by the data step:

data SoilAnaylsis;
  set compost.compiled;
run;

Would not have any variables would be if the input dataset COMPOST.COMPILED did not have any varaibles.

You probably overwrote your dataset in your earlier attempts.

Recreate it by re-running the code you use to create it from the EXCEL in the first place.

Then try your simple data step that makes a copy of it into the new dataset SOILANALYSIS again.

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 21:04:32 GMT

exactly. Thank you for your help.

Re: How do I use a file saved in my library

anthonysimerlin — Wed, 14 Sep 2022 21:04:48 GMT

thank you for your help!