topic Re: Facing problem while sorting. in SAS Procedures

Facing problem while sorting.

kuridisanjeev — Fri, 30 Mar 2012 08:31:03 GMT

Hi all..

Iam having bellow code.

proc sort data=test;

by 'emp id'n 'emp target'n;

run;

data test1;

set test;

by 'emp id'n 'emp target'n;

if first.'emp id'n ne 1 then 'emp taget'n=0;

run;

if i run the code i am not getting the correct output.

i mean to say first. last. variables are not creating...

Some one saying it is because of variables...

please clarify me...

Facing problem while sorting.

manojinpec — Fri, 30 Mar 2012 08:33:54 GMT

First and last variables are hidden automatic variables. they will not be visible.If you want to view them assgin it to some difference variable.

proc sort data=test;

by 'emp id'n 'emp target'n;

run;

data test1;

set test;

by 'emp id'n 'emp target'n;

a=first.emp_id;

b=last.emp_id;

c=first.emp_target;

d-last.emp_target;

if first.'emp id'n ne 1 then 'emp taget'n=0;

run;

Facing problem while sorting.

Ksharp — Fri, 30 Mar 2012 08:36:27 GMT

first. last. variables have already created by SAS.

But because they are temporary variables, they will not appear at PDV ,but at somewhere at memory.

And they will not output dataset defaultly.

Ksharp

Re: Facing problem while sorting.

kuridisanjeev — Fri, 30 Mar 2012 09:37:34 GMT

Sorry to all.

A small typo error happened in my above post.

I am not getting correct output.

there i am using

if first.'emp id'n ne 1 then 'emp taget'n=0 condition.

this condition was not working because the variable names that i mentioned as 'emp id'n and 'emp taregt'n.

if I change variable names to emp_id and emp_target, the condition was working....

So what's wrong with variable names?????

Re: Facing problem while sorting.

manojinpec — Fri, 30 Mar 2012 11:11:26 GMT

'n is used for what purpose?

Re: Facing problem while sorting.

kuridisanjeev — Fri, 30 Mar 2012 11:17:32 GMT

If you want to define variable name with "space", generally we use n.

for example if you want to create a variable with name "customer name",SAS won't accept this name directly because there is a space between customer and name..

For this you need to specify like this 'customer name'n.

Let me know if any clarification needed.

Thank you.

Sanjeev.

Re: Facing problem while sorting.

manojinpec — Fri, 30 Mar 2012 11:23:28 GMT

Is it applicable for SAS 8.2 . I am using sas 8.2 and i am not able to assign this name.

Facing problem while sorting.

kuridisanjeev — Fri, 30 Mar 2012 11:31:47 GMT

I don't think it works in 8.2.

this is the new option which I found in SAS recently .

it is working in 9.2

Re: Facing problem while sorting.

Tom — Fri, 30 Mar 2012 12:37:34 GMT

You need to set validvarname=any. But you are probably better off NOT using it. You can use the variable label instead to store the description of the variable. Most procs will list the label along with the variable name. You can use the LABEL option for PROC PRINT to have the column headers be the label instead of the name.

1     data x;
2      'This name'n=100;
ERROR: The name This name is not a valid SAS name.
3    run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.X may be incomplete.  When this step was stopped there were 0 observations and 0 variables.

4    options validvarname=any;
WARNING: Only the Base product and the SAS/STAT product have been tested for use with VALIDVARNAME=ANY. Other use of this option is considered
         experimental and may cause undetected errors.
5     data x;
6      'This name'n=100;
7    run;

NOTE: The data set WORK.X has 1 observations and 1 variables.