topic Re: Exported data set to examine if changes I coded were made. Receiving import error. in New SAS User

Exported data set to examine if changes I coded were made. Receiving import error.

gtucke1 — Sun, 25 Sep 2022 13:42:10 GMT

I needed to delete 2 observations. I wanted to check the dataset to make sure the changes had been made. Below are my export and import statements. I continue to get the following error for the import statement:

Proc export data = ICPNEED.cg_relation_fix
Outfile = 'C:\Users\gtuck\OneDrive\Documents\Gretchen Dissertation\SAS\Working Data Set\cg_realtion_fix.xlsx'
DBMS = XLSX Replace;
Sheet = "cg_relation_fix";
Run;

Proc import datafile = 'C:\Users\gtuck\OneDrive\Documents\Gretchen Dissertation\SAS\Working Data Set\cg_relation_fix.xlsx'
DBMS = xlsx
OUT = ICPNEED.relation_fix
Replace;
Run;

From the log:

329 Proc import datafile = 'C:\Users\gtuck\OneDrive\Documents\Gretchen Dissertation\SAS\Working
329! Data Set\cg_relation_fix.xlsx'
330 DBMS = xlsx
331 OUT = ICPNEED.relation_fix
332 Replace;
333 Run;

ERROR: Physical file does not exist, C:\Users\gtuck\OneDrive\Documents\Gretchen
Dissertation\SAS\Working Data Set\cg_relation_fix.

Re: Exported data set to examine if changes I coded were made. Receiving import error.

PaigeMiller — Sun, 25 Sep 2022 13:45:59 GMT

Why don't you just check this in SAS instead of Excel?

Re: Exported data set to examine if changes I coded were made. Receiving import error.

gtucke1 — Sun, 25 Sep 2022 13:58:42 GMT

Hi,

What is the procedure for checking in SAS?

Re: Exported data set to examine if changes I coded were made. Receiving import error.

Tom — Sun, 25 Sep 2022 16:08:27 GMT

The SAS log should show whether or not two observations were deleted.

Example: This data step ended up deleting 5 observations.

214  data want;
215    set sashelp.class;
216    if age=12 then delete;
217  run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.WANT has 14 observations and 5 variables.

Re: Exported data set to examine if changes I coded were made. Receiving import error.

PaigeMiller — Sun, 25 Sep 2022 21:30:27 GMT

Every SAS user interface has a data set viewer, in every interface I know, you double-click on the actual data set on the left side of the screen. To be more specific, I would have to know what SAS user interface you are using. Once you have the data set viewable on your screen, you can confirm the two observations are no longer present.

Checking the log will tell you if records were deleted, and how many. It won't tell you if you deleted the right records. In some cases, it is trivial to delete the right records; in other cases it is not so trivial and requires careful checking.

Re: Exported data set to examine if changes I coded were made. Receiving import error.

Kurt_Bremser — Mon, 26 Sep 2022 01:05:10 GMT

Typo:

Outfile = 'C:\Users\gtuck\OneDrive\Documents\Gretchen Dissertation\SAS\Working Data Set\cg_realtion_fix.xlsx'

datafile = 'C:\Users\gtuck\OneDrive\Documents\Gretchen Dissertation\SAS\Working Data Set\cg_relation_fix.xlsx'

realtion vs. relation