About Aman4SAS

Aman4SAS · ‎02-04-2013

count n total is nt a prob for me , i hav done that already. DATA TEST1; SET TEST END = FINAL; IF STATUS = 'Y' THEN Y+1; IF STATUS= 'N' THEN N+1; TOT+1; RUN; PROC PRINT; RUN; main prob is using that in title n footnote.

Aman4SAS · ‎02-04-2013

yes, %let n call symput(); but not able to use logic how to use it here..

Aman4SAS · ‎02-04-2013

Hi, i have data set like: data test; input name $ PAID_status $; datalines; AMAN Y PAWAN Y KUMAR N TIWARI Y MINU N DEEPAK N RAHUL Y VISHAL N POOJA Y PAYAL Y goyal N/A BALAK N ; RUN; now i m looking to generate report like : report of 11 student Name paid_status AMAN Y PAWAN Y KUMAR N TIWARI Y MINU N DEEPAK N RAHUL Y VISHAL N POOJA Y PAYAL Y BALAK N 6 student paid and 5 student not paid out of 11 student. PLZ HELP

Aman4SAS · ‎02-01-2013

jan belongs to 31 days...apart it my question is how can i use monname3. format? there is a dataset name sashelp.prdsales. in that column name month having format monname3. plz check

Aman4SAS · ‎02-01-2013

Hi Manoj, its working on date part not with year.. if like 1 means 1st date of year n i will work till 365.like if i give 31st then it returns feb, but jan is a 31 days month. 60 give mar. it cant b use with date. so how can i use monname3.

Aman4SAS · ‎02-01-2013

data test; input month; format month monname3.; datalines; 1 2 3 4 5 ; run; Proc print data=test; run; when i run this code, i get result like this... Obs month 1 Jan 2 Jan 3 Jan 4 Jan 5 Jan its sud be like jan feb mar & so on... plz help.... thanks

Aman4SAS · ‎01-31-2013

sir,,, can i change change or remove both line (which i mention in BOLD) from output??? ------------------------------------------------------------ Year=1999 ------------------------------------------------------------- The MEANS Procedure Analysis Variable : Sales Region Qtr State Sum Mean -------------------------------------------------------------------- East 1 MA 18038.00 18038.00 NC 13611.00 13611.00 2 MA 11084.00 11084.00 NC 19660.00 19660.00 3 MA 11084.00 11084.00 West 1 CA 27272.00 13636.00 OR 18988.00 18988.00 2 CA 14523.00 14523.00 OR 37976.00 18988.00 --------------------------------------------------------------------

Aman4SAS · ‎01-31-2013

thanks sir,, i thnks its prob in my software at the time of installation.. i was confused y i m nt getting result when code is write. Thanks

Aman4SAS · ‎01-31-2013

i m nt using datalines in macro.. i m creating macro for proc means... plz read above

Aman4SAS · ‎01-31-2013

data sales; input Region $ State $ Sales :dollar8. Year Qtr; datalines; West CA 13636 1999 1 West OR 18988 1999 1 West CA 14523 1999 2 West OR 18988 1999 2 East MA 18038 1999 1 East NC 13611 1999 1 East MA 11084 1999 3 East NC 19660 1999 2 West CA 12536 1998 1 West OR 17888 1997 1 West CA 15623 1998 3 West OR 17963 1997 2 East NC 17638 1998 1 East MA 12811 1998 1 East NC 12184 1998 4 East MA 12760 1998 4 West CA 13636 1999 1 West OR 18988 2000 3 West CA 14523 2000 4 West OR 18988 1999 2 East MA 18038 1998 1 East NC 13611 1997 1 East MA 11084 1999 2 East NC 19660 2000 2 West CA 12536 1997 4 West OR 17888 2000 4 West CA 15623 1997 3 West OR 17963 2000 4 East NC 17638 2000 3 East MA 12811 1997 3 East NC 12184 1997 4 East MA 12760 2000 3 ; run; %macro sumry(dsn,var1,var2); proc sort data=&dsn; by year; run; proc means data=&dsn noobs sum mean; by year; class region qtr state; var &dsn; where year>&var1 and year<&var2; run; %mend; %sumry(sales,1998,2000); when i run this programe it runs fine. but when i use macro then its shows no obs selected. not able to find problem. plz help thanks

Aman4SAS · ‎01-31-2013

sincerely apology.....

Aman4SAS · ‎01-30-2013

thanks urvasi...

Aman4SAS · ‎01-30-2013

sorry i wrote level ,, i meant label... i want to change the label name of freq column name.

Aman4SAS · ‎01-29-2013

OUTPUT result of given code. Desired OUTPUT ... ------- deptno=10 ----- ------- deptno=10 ----- job Frequency job SUM_SAL CLERK 1300 CLERK 1300 MANAGER 2450 MANAGER 2450 PRESIDEN 500 PRESIDEN 500 ----- deptno=20 -------- ------ deptno=20 --------- job Frequency job SUM_SAL ANALYST 6000 ANALYST 6000 CLERK 1900 CLERK 1900 MANAGER 2975 MANAGER 2975 --------------so on....like for deptno=30 ------- -------so on....like for deptno=30 and to store it as a dataset like. deptno job sum_sal 10 CLERK 1300 20 MANAGER 2450 30 PRESIDEN 500 so can we change the label of column name frequency as like sum_sal

Aman4SAS · ‎01-29-2013

yes ?? if its possible..i want to do practice on real scenario. thanks

Online Status	Offline
Date Last Visited	‎05-25-2021 03:59 PM

Re: Data step with Lag function

Re: Data step with Lag function

Data step with Lag function

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

Re: If condition with macro variables

If condition with macro variables

Re: Data step with Lag function

Re: Data step with Lag function

Re: Need Data Step Solution

Re: How to read Raw data with embedded blank without increasing the sp...

Re: %let = if statement, or case?... confused...

Re: How to read Raw data with embedded blank without increasing the sp...

Re: title with macro

Re: title with macro

title with macro

Re: MONNAME3.

Re: MONNAME3.

MONNAME3.

Re: need help in macro.

Re: need help in macro.

Re: need help in macro.

need help in macro.

Re: proc freq

Re: proc freq

Re: proc freq

Re: proc freq

Re: proc sort