topic ı have diffuculties using sas acadenic on demand the file and code given but due to ı am new begine in SAS Software for Learning Community

ı have diffuculties using sas acadenic on demand the file and code given but due to ı am new begine

misoysal — Fri, 10 Mar 2023 12:52:50 GMT

ı have data including 5 column 16 lines ı have also code as

filename aa “data-13-1.csv”;

proc import datafile=aa out=one dbms=csv replace;

run;

ods graphic off;

proc corr data=one;

var XO YO;

with X1 Y1 ;

run;

proc import datafile=aa out=one dbms=csv replace;

run;

ods graphic off;

proc corr data=one;

var XO YO;

with X1 Y1 ;

run;

bu ı have difficulties to import data to the code page

Re: ı have diffuculties using sas acadenic on demand the file and code given but due to ı am new be

Tom — Fri, 10 Mar 2023 13:20:06 GMT

Can you explain what the problem is?

You posted code, but no log of the run, so we don't know what the issue is.

You posted code that is reading from a CSV file, but you did not show any of the CSV file contents.

My guess just from looking at the code you posted is that the CSV file is not in the current working directory of the SAS session that is running the PROC IMPORT. So you need to change the filename statement to give the fully qualified filename and not just a relative filename it currently has.

Re: ı have diffuculties using sas acadenic on demand the file and code given but due to ı am new be

misoysal — Fri, 10 Mar 2023 13:35:56 GMT

if ı send data anad code can you do for me
due to ı am beginner ı could not transfer the data file to the snippet
below the data
[image: image.png]
and this is the code
[image: image.png]
when ı tried to have solution on SAS academic on demand
ı can not transfer the whole data to the area needed
this is my problem ı confronted
kind regards

Re: ı have diffuculties using sas acadenic on demand the file and code given but due to ı am new be

Tom — Fri, 10 Mar 2023 14:16:50 GMT

Your pictures did not make it into your message. (did you reply by email instead of using the Forum site?)

Is the issue UPLOADING the CSV file? SAS/Studio has an UPLOAD feature. Are you having trouble using that? Or is the file too big? You can compress the CSV file using ZIP or GZIP. A CSV file will normally compress to between 10 and 20 percent of its original size. So perhaps that version will not exceed the file size limits.

Or is the issue getting the SAS code to point to where you did upload the file? In the SAS/Studio interface you can browse to your files. If you see the file you want to read then ask for its properties and that should show you the full path to the file that you can copy and paste into your FILENAME statement.

Re: ı have diffuculties using sas acadenic on demand the file and code given but due to ı am new be

tom_grant — Fri, 10 Mar 2023 14:55:31 GMT

Additional note - you can right-click on file (CSV) & go to properties & then copy the full path to the file.