topic Re: How do I import a CSV file into the SAS library in New SAS User

How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 18:00:57 GMT

How do I import a csv file into the library or is it possible?

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 18:03:09 GMT

My end goal is to create a frequency table..it lets me enter the source of the data but the data set is not showing up in the library

Re: How do I import a CSV file into the SAS library

Reeza — Wed, 05 Aug 2020 18:51:04 GMT

Yes it's possible. Use an Import Data task is likely your best bet if you're unfamiliar with SAS.
Or use PROC IMPORT. That creates a SAS data set that can then be worked with in SAS.

Re: How do I import a CSV file into the SAS library

Shmuel — Wed, 05 Aug 2020 18:52:31 GMT

You can use either proc import:

proc import file="Path_and_FileName.csv"
            out=test dbms=csv 
            replace;
     getnames=yes;  /* assume first line contains variable names */
run;

Try it and if any issue post the full log showing your code and messages.

Depending on data types you may have issues especially getting the wrong type.

If possible post also a sample lines from the csv file.

Re: How do I import a CSV file into the SAS library

Reeza — Wed, 05 Aug 2020 19:00:50 GMT

https://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 19:01:11 GMT

I have it now. I need a frequency table for an age group (18-50) along with gender

proc freq data=WORK.SYPHILIS;
	tables genderC genderB age / plots=(freqplot cumfreqplot);
run;

How do I write the code for an age group of 18-50

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 19:03:29 GMT

Thanks

Re: How do I import a CSV file into the SAS library

Reeza — Wed, 05 Aug 2020 19:27:10 GMT

You add a WHERE statement to filter out/in the groups you want.

WHERE age_group = '18 to 50';

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 19:35:53 GMT

proc freq data=WORK.SYPHILIS;
	tables age sex_o genderC genderB / plots=(freqplot cumfreqplot);
	where age_group= '18 to 50';
run;

Log: 

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         /*
 74          *
 75          * Task code generated by SAS Studio 3.8
 76          *
 77          * Generated on '8/5/20, 12:06 PM'
 78          * Generated by 'u49152646'
 79          * Generated on server 'ODAWS02-USW2.ODA.SAS.COM'
 80          * Generated on SAS platform 'Linux LIN X64 3.10.0-1062.9.1.el7.x86_64'
 81          * Generated on SAS version '9.04.01M6P11072018'
 82          * Generated on browser 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)
 82       ! Chrome/84.0.4147.105 Safari/537.36'
 83          * Generated on web client
 83       ! 'https://odamid-usw2.oda.sas.com/SASStudio/main?locale=en_US&zone=GMT-07%253A00&ticket=ST-58631-NKEgz3Gaqesii60Jleii-cas'
 84          *
 85          */
 86         
 87         proc freq data=WORK.SYPHILIS;
 88         tables age sex_o genderC genderB / plots=(freqplot cumfreqplot);
 89         where age_group= '18 to 50';
 ERROR: Variable age_group is not on file WORK.SYPHILIS.
 90         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE FREQ used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              1375.50k
       OS Memory           38572.00k
       Timestamp           08/05/2020 07:33:34 PM
       Step Count                        265  Switch Count  0
       Page Faults                       0
       Page Reclaims                     242
       Page Swaps                        0
       Voluntary Context Switches        0
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           0
       
 91         
 92         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 104

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 19:36:37 GMT

It says that the age_group is not on the work.syphilis file. Where did I go wrong?

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 19:42:53 GMT

This is what it says:

proc freq data=WORK.SYPHILIS;
	tables age sex_o genderC genderB / plots=(freqplot cumfreqplot);
	where age_group= '18 to 50';
run;

Log: 

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         /*
 74          *
 75          * Task code generated by SAS Studio 3.8
 76          *
 77          * Generated on '8/5/20, 12:06 PM'
 78          * Generated by 'u49152646'
 79          * Generated on server 'ODAWS02-USW2.ODA.SAS.COM'
 80          * Generated on SAS platform 'Linux LIN X64 3.10.0-1062.9.1.el7.x86_64'
 81          * Generated on SAS version '9.04.01M6P11072018'
 82          * Generated on browser 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)
 82       ! Chrome/84.0.4147.105 Safari/537.36'
 83          * Generated on web client
 83       ! 'https://odamid-usw2.oda.sas.com/SASStudio/main?locale=en_US&zone=GMT-07%253A00&ticket=ST-58631-NKEgz3Gaqesii60Jleii-cas'
 84          *
 85          */
 86         
 87         proc freq data=WORK.SYPHILIS;
 88         tables age sex_o genderC genderB / plots=(freqplot cumfreqplot);
 89         where age_group= '18 to 50';
 ERROR: Variable age_group is not on file WORK.SYPHILIS.
 90         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE FREQ used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.00 seconds
       memory              1375.50k
       OS Memory           38572.00k
       Timestamp           08/05/2020 07:33:34 PM
       Step Count                        265  Switch Count  0
       Page Faults                       0
       Page Reclaims                     242
       Page Swaps                        0
       Voluntary Context Switches        0
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           0
       
 91         
 92         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 104

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 19:48:34 GMT

I figured it out..I did where age between 19 and 50;

Re: How do I import a CSV file into the SAS library

Shmuel — Wed, 05 Aug 2020 19:52:44 GMT

Your variable is named age. What kind of values does it contain?

The WHERE statement may be either

where age is between 18 and 50

where age is "18 to 50"

depending on age variable - is it an age of a person or

is it a group age/

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 20:00:01 GMT

It is a group age...(Age of people between the age of 18 and 50)

I got a frequency table from age 18-50....but I didn't use the word "is"..Does it matter

proc freq data=WORK.SYPHILIS;
	tables age sex_o genderC genderB RACE / plots=(freqplot cumfreqplot);
	where age between 18 and 50;
run;

Re: How do I import a CSV file into the SAS library

Reeza — Wed, 05 Aug 2020 20:17:19 GMT

We don't have your data so can only guess at what you're asking...if you need specific help you need to provide sample data.

Re: How do I import a CSV file into the SAS library

Kimberly_2020 — Wed, 05 Aug 2020 20:33:52 GMT

Attached is my data. Again, my where statement was:

where age between 18 and 50

Re: How do I import a CSV file into the SAS library

Shmuel — Wed, 05 Aug 2020 20:35:53 GMT

1) If the AGE is a group given as "18-50" then use

where age = "18-50";

If AGE is a number like 25 then you can use

where age between 18 and 50;

2) The title of your post is "How do I import a CSV file into the SAS library".

You got the solution to your question.

The new post dealing how to subset your date according to age group

should be posted as a new query.