Reshaping the Data

[kngu022]

I have this codes below. As I understand the length of item is from 1-13, IDnum is from 15-19 , Instock 21-22  backord 24-25.

the order that variable will be stored in the data is item indnum instock  backord total. But when I try on SAS program the result is iDnum  item unstuck backord total. Can anyone please help me to understand this code? 

DATA perm.update;
	INFILE invent;
	INPUT IDnum $15-19 Item $ 1-13 Instock 21-22 BackOrd 24-25;
Total = instock+backord;
RUN; 

[ed_sas_member · Accepted solution]

Hi @kngu022,

During the compilation phase (before execution), the Program Data Vector is initialized with the variables in the order they are encountered in your code.

So in your example, the first variable name appears in the INPUT statement (IDnum), followed by Item, Instock and Backord.

In the next statement, a new variable Total is mentioned so it is finally added to this PDV.

15-19, etc. are just 'indicators' for SAS to find where the value of the corresponding variable is.

Hope this is clear.

Best,

E.g.:

DATA update1;
	INFILE datalines;
	INPUT IDnum $15-19 Item $ 1-13 Instock 21-22 BackOrd 24-25;
	Total = instock+backord;
	datalines;
AAAAAAAAAAAAA BBBBB 11 22
;
RUN;