topic Re: To get an output by removing spaces in SAS Programming

To get an output by removing spaces

Sultana — Mon, 14 Jun 2021 18:47:49 GMT

I am providing a sample excel where the category section is not coming in the output as there are spaces.

I tried the different functions but I think missing something. can someone please let me know how to get the output?

Thanks

Re: To get an output by removing spaces

Reeza — Mon, 14 Jun 2021 19:02:39 GMT

Please provide more information. Remember we can see only what you post. It's usually a good idea to start with what you have (your input), what you want (your output) and what you've tried so far.

I can see your output but not what you want or start with so right now, I have no idea what issue you're trying to solve.

Re: To get an output by removing spaces

Sultana — Mon, 14 Jun 2021 19:18:24 GMT

I have provided my input file only thing is I use the CSV file and want
this to be in SAS EG output. But when I put in

Input 1d : $12.
Status : $2
Category : $25
;
run;

So the category column is coming as empty no output.

I need the FDI - UNION and FT - Full Time to be reflected in the category
column.

Please suggest

Re: To get an output by removing spaces

tarheel13 — Mon, 14 Jun 2021 19:25:58 GMT

Can you just import the .csv file with proc import?

Re: To get an output by removing spaces

Tom — Mon, 14 Jun 2021 19:30:56 GMT

But you didn't post a CSV file. You posted some XLSX file. Does that file you posted have anything to do with the CSV file you started with. Remember do NOT let Excel open a CSV file for you, it will make changes based on what it thinks the strings in the file mean. Look at the CSV file with a text editor (or just dump a few lines to your SAS log with a simple data _null_ step).

Re: To get an output by removing spaces

Sultana — Mon, 14 Jun 2021 19:46:24 GMT

Attaching a CSV file

Re: To get an output by removing spaces

tarheel13 — Mon, 14 Jun 2021 19:54:21 GMT

Still don't see a csv file.

Re: To get an output by removing spaces

Reeza — Mon, 14 Jun 2021 19:54:46 GMT

Attachments via email are not supported, you need to add your attachment via the website.

Re: To get an output by removing spaces

jimbarbour — Mon, 14 Jun 2021 23:10:17 GMT

Input 1d : $12.
Status : $2
Category : $25
;
run;

We'd definitely have to see your input file in order to help.

Just looking at your code, I don't see the INFILE statement. The INFILE affects the behavior of the INPUT, so that would be important for us to see. There are different ways to code this, but presumably it looks something like this:

INFILE My_File DSD DLM=',';

This may not be the problem because you're getting at least some input, but it helps if you show us all the related code.

Jim

Re: To get an output by removing spaces

Sajid01 — Wed, 16 Jun 2021 17:41:36 GMT

Hello @Sultana
As I understand from the previous post, you are importing csv files. The last variable is a character variable and it has space in between. For this reason your are not able to see the last variable.
I have converted your excel to csv and it can be imported without any issue.

proc import datafile="/path_to_your_file/Sample_sas.csv" out=sample_sas replace;
run;

The output will be like this

In case you want to read csv data inline you can use the following code

data test;
length ID Status Category $ 25;
INFILE datalines DSD DLM=','  missover;
input ID $ Status $  Category  $;
datalines;
123-45-678,Active,FDI - UNION
678-90-111,Terminated,FT - Full Time
;
run;

The output will be same as in the first case.
In this later case you need to specify the length of the categorical variables if they are longer than eight characters.