topic Re: How to specify character length when creating data set using proc input. in New SAS User

How to specify character length when creating data set using proc input.

mcmaxwell — Wed, 29 Sep 2021 20:36:01 GMT

Hi everyone.

I am using SAS OnDemand for Academics. I am trying to make a simple data set using the following code

data new;     
	input percent cPLTL $ @@;     
	cards;     
	2.19 cPLTL     
	17.03 non-cPLTL      
	;         
proc print data=new; run;

which yields these results:

How do I specify the character length of the "cPLTL" variable so that the last L in "non-cPLTL" won't be cut off? I tried adding the number 9 after the $ in the input function, but then the Studio kept running the code and never produced any results...

Thanks!

Re: How to specify character length when creating data set using proc input.

Kurt_Bremser — Wed, 29 Sep 2021 20:48:28 GMT

Use the informat with a modifier:

input percent cPLTL :$9.;

Re: How to specify character length when creating data set using proc input.

Tom — Wed, 29 Sep 2021 21:01:44 GMT

Best practice is to define the variable before using it so that SAS does not have to guess how you want it defined.

data new;     
  length percent 8 cPLTL $20 ;
  input percent cPLTL ;     
cards;     
2.19 cPLTL     
17.03 non-cPLTL      
;

PS: Do not indent lines of in-line data. To remind you not to intend the data do not indent the CARDS/DATATLINE statement either.

PPS: Do not insert physical tab characters into data lines. You also shouldn't be inserting tabs into lines of program code as they are invisible to humans and can end up in the middle of the lines and result in really strangely formatted code. Instead take advantage of the editor's ability to translate you hitting the TAB key into inserting the correct number of spaces you like to use.