topic Re: i am having error please help me in Programming 1 and 2

i am having error please help me

kinjal — Mon, 10 Apr 2023 19:34:24 GMT

data inventory;
retain id item price vendor;

input id item$ 11. price vendor$ 20.;
msrp=price*1.5;
label id ='Item Id' msrp='Max Retail price';
cards;
1 apple 2.19 walmart
2 grapes 1.99 shop$stop
;
run;

Re: i am having error please help me

PaigeMiller — Mon, 10 Apr 2023 19:38:59 GMT

Normally when you are a having problems, you go ahead and describe the problems to us, and show us the ENTIRE log for this code. Otherwise how would we know what the error is that you are having?

Re: i am having error please help me

kinjal — Mon, 10 Apr 2023 19:41:47 GMT

getting dots as output in price and vendor variables

Re: i am having error please help me

kinjal — Mon, 10 Apr 2023 19:42:42 GMT

getting dot as output in price and vendor variable.

Re: i am having error please help me

kinjal — Mon, 10 Apr 2023 19:43:37 GMT

I am very new in sas programing need help

Re: i am having error please help me

Reeza — Mon, 10 Apr 2023 19:45:39 GMT

input id item : $11. price : best12. vendor : $20.;

Re: i am having error please help me

kinjal — Mon, 10 Apr 2023 19:50:45 GMT

Thank you

Re: i am having error please help me

kinjal — Mon, 10 Apr 2023 19:56:58 GMT

if you don't mind then please explain me : and best why we use here ??

Re: i am having error please help me

Reeza — Mon, 10 Apr 2023 20:19:23 GMT

When you specify $11 without a modifier SAS reads 11 characters. With the modifier it reads until it encounters a space is the biggest reason.

Another way to achieve this is to specify informats not on the INPUT statement.

Re: i am having error please help me

Reeza — Mon, 10 Apr 2023 20:20:15 GMT

https://communities.sas.com/t5/SAS-Programming/Colon-Modifier/td-p/240240

#2 here

https://support.sas.com/resources/papers/proceedings/proceedings/sugi26/p073-26.pdf

Re: i am having error please help me

kinjal — Wed, 12 Apr 2023 19:19:03 GMT

data food;
input @1Restaurant$ 11.@12NumEmploy 1. @13Location$ 20.;
datalines;

burger king 5 toronto;

run;

Re: i am having error please help me

Reeza — Wed, 12 Apr 2023 19:34:36 GMT

Is that a question?

Re: i am having error please help me

PaigeMiller — Wed, 12 Apr 2023 19:38:24 GMT

Yes, if you are having trouble, please state a clear question and describe what is wrong.

Re: i am having error please help me

Tom — Wed, 12 Apr 2023 19:41:16 GMT

@kinjal wrote:
if you don't mind then please explain me : and best why we use here ??

If you use an INFORMAT in the INPUT statement then SAS will use FORMATTED MODE input for that variable.

By adding the colon modifier you are telling the INPUT statement to use LIST MODE input for that variable instead.

You don't really need to include any special informats for any of your variables. The only advantage of using an INFORMAT for ITEM or VENDOR in the INPUT statement is if you have not previously told SAS what type of variables those are. If the first place that SAS sees the variable (at least the first place where the type of the variable is important, unlike in the RETAIN statement) is in an INPUT statement then SAS will use the width of the INFORMAT to make a GUESS about how you wanted the variable defined.

But the code will work better and be clearer if you just go ahead and DEFINE the variables before you use them in the INPUT statement. There is also no need to tell SAS that the variable values need to be retained across iterations of the data step.

data inventory;
  length id 8 item $11 price 8 vendor $20 msrp 8;
  input id item price vendor;
  msrp=price*1.5;
  label id ='Item Id' msrp='Max Retail price';
cards;
1 apple 2.19 walmart
2 grapes 1.99 shop$stop
;

Re: i am having error please help me

kinjal — Wed, 12 Apr 2023 19:42:29 GMT

Yes dear can you able to help me ??##- Please type your reply above this
line. No attachments. -##

Re: i am having error please help me

Reeza — Wed, 12 Apr 2023 20:01:07 GMT

You cannot just post some random code, expect someone to run it, find the error and debug it for you.

Please frame your questions as follows if you want help efficiently. This will allow us to help you get your problems solved.

In general, see this post or this post on how to ask good programming questions. You'll save yourself a ton of time and get your answers much faster.

This is my problem (I am trying to read in data that has two parts to a name separated by a space into one variable but it's not working correctly)

What you'ved tried: This is my code so far

What happens with that code:

This is what it generates and this is the log.

Re: i am having error please help me

kinjal — Wed, 12 Apr 2023 20:05:20 GMT

Thank you. I will try better next time.

Re: i am having error please help me

Reeza — Wed, 12 Apr 2023 20:55:51 GMT

data food;
infile datalines truncover;
input @1 Restaurant $11.  @13 NumEmploy 1. @15 Location $20.;
datalines;
burger king 5 toronto
;
run;