topic Re: Help on SAS Format in New SAS User

Help on SAS Format

archita — Sat, 26 Feb 2022 11:30:02 GMT

Hi all,

I am facing this issue. Please help me with the error. I have a dataset named continent with 2 variables-continentid and continent name. I want to create a control input dataset named continent and store it in myfmt catalog and use the format on continentid var.name of the format is continent

Re: Help on SAS Format

Kurt_Bremser — Sat, 26 Feb 2022 11:35:25 GMT

Please post logs as text using this button:

For SAS code, use the "little running man" right next to it.

You assign constant character values to variables start and label; I guess that you wanted to assign the values contained in the variables continent_id and continent_name, so remove the quotes around the variables names.

Re: Help on SAS Format

tarheel13 — Sat, 26 Feb 2022 17:45:45 GMT

is continent id char or numeric?

Re: Help on SAS Format

Reeza — Sat, 26 Feb 2022 20:04:31 GMT

The CNTLIN data set, continent, was created incorrectly.

For the start and label, it assigns only one value which will always map the VALUE continent_ID to the continent_name. I think you likely meant to refer to those as variables not constants.

Remove the quotes around the variables.

FYI - if you post a picture of your code we'll have to explain to you how to modify it.

If you post the actual code, we can show the suggested changes. Post your code and log directly in the future, not an image.

@archita wrote:

Hi all,

I am facing this issue. Please help me with the error. I have a dataset named continent with 2 variables-continentid and continent name. I want to create a control input dataset named continent and store it in myfmt catalog and use the format on continentid var.name of the format is continent

Re: Help on SAS Format

archita — Sat, 26 Feb 2022 19:27:44 GMT

Hi continentid is numeric

Re: Help on SAS Format

tarheel13 — Sat, 26 Feb 2022 19:33:17 GMT

hmm so why did you use $ then if it's a numeric variable?

Re: Help on SAS Format

Reeza — Sat, 26 Feb 2022 20:05:16 GMT

contentID is not used in your format as shown.

See my previous post.

@archita wrote:
Hi continentid is numeric

Re: Help on SAS Format

tarheel13 — Sat, 26 Feb 2022 20:10:08 GMT

data continent;
	length continentName $50;
	infile datalines truncover dlm='|';
	input continent_id continentName $;
	datalines;
	1|Asia
	2|Africa
	3|N. America
	4|S. America
	5|Antarctica
	6|Europe
	7|Australia
	;
run;

proc print data= continent;
run;

data outfmt(keep=start label fmtname);
	set continent(rename=(continent_id=start continentname=label));
	fmtname='continent';
run;

proc format library=work cntlin=outfmt;
run;

This should do it. next time post sample data as datalines.

Re: Help on SAS Format

archita — Sun, 27 Feb 2022 10:08:00 GMT

Hi , Thank you for the help.I am still getting the same error.
This is the error:-
27 proc format library=blib.myfmt cntlin=continent;
ERROR: For format CONTINENT, this range is repeated, or values overlap: .-..
28 quit;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 5 observations read from the data set WORK.CONTINENT.
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: Help on SAS Format

Kurt_Bremser — Sun, 27 Feb 2022 10:50:41 GMT

Post the complete log of the step that creates the continent dataset. Use this button to post the log (do NOT skip this😞

Re: Help on SAS Format

archita — Sun, 27 Feb 2022 11:23:28 GMT

data continent;
set blib.continent;
keep fmtname start label;
fmtname='CONTINENT';
start='Continent_ID';
label='Continent_Name';
run;
proc format library=blib.myfmt cntlin=continent;
select CONTINENT;
run;

This the code I am running currently still getting same error

Re: Help on SAS Format

Kurt_Bremser — Sun, 27 Feb 2022 11:42:09 GMT

Against repeated advice from multiple people, you still set start and label to constant values:

start='Continent_ID';
label='Continent_Name';

Change this to:

start = Continent_ID;
label = Continent_Name;

Re: Help on SAS Format

tarheel13 — Sun, 27 Feb 2022 11:45:34 GMT

you seem like you don't listen. people have tried to help you. we gave you multiple solutions and you still ignore our advice 😞

Re: Help on SAS Format

tarheel13 — Sun, 27 Feb 2022 11:46:11 GMT

once again, you are not listening. we told you what you have to change in your code. the reason you are getting errors is because you have not implemented the change...

Re: Help on SAS Format

archita — Sun, 27 Feb 2022 12:03:33 GMT

Hi,I am sorry for the inconvenience, I missed the code so was not getting the results dint do deliberately. now its working.. thank you so much.

Re: Help on SAS Format

archita — Sun, 27 Feb 2022 12:04:46 GMT

Hi, I dint do it deliberately , I missed some part . Sorry for the inconvenience. The code is now working for me. Thanks a lot.

Re: Help on SAS Format

archita — Sun, 27 Feb 2022 12:05:45 GMT

I am sorry , dint do it deliberately ,missed some parts of code. THe code is now working . Thanks a lot.