About RamKumar

RamKumar · ‎11-04-2014

you can use compress function to remove '-'.

RamKumar · ‎11-04-2014

Where can we see the object spawner? e.g. server As per SAS(R) 9.2 Intelligence Platform: Application Server Administration Guide, object spawner is used for for accessing the SAS Metadata Server. How it plays a role for accessing the workspace server?

RamKumar · ‎11-04-2014

Now got this error. filename oscmd pipe "ulimit -d"; ERROR: Insufficient authorization to access PIPE. ERROR: Error in the FILENAME statement. 16 17 data _null_; 18 19 infile oscmd; 20 21 input; 22 23 put _infile_; 24 25 run; ERROR: No logical assign for filename OSCMD.

RamKumar · ‎11-04-2014

Thanks again for your swift response. I did ran your code in SAS EG and got the error as follows. 15 filename oscmd pip "ulimit -d"; ERROR: Invalid device type. ERROR: Error in the FILENAME statement. 16 17 data _null_; 18 19 infile oscmd; 20 21 input; 22 23 put _infile_; 24 25 run; ERROR: No logical assign for filename OSCMD. Please see my code (and log) below to create charts. proc univariate data=sashelp.class; 16 var age height; 17 histogram age; 18 run; ERROR: Unable to allocate sufficient memory. At least 469K bytes were requested, but only 45K were available. You must either increase the amount of memory available, or approach the problem differently. ERROR: Driver SASGDGIF will not load. ERROR: Device was not specified. ERROR: Unable to load graphics. I'm getting the same error when I tried to produce chart (in EG) manually from the SAS dataset.

RamKumar · ‎11-04-2014

I ran your code and found MEMSIZE=4294967296. Please suggest how to increase the memsize via command line.

RamKumar · ‎11-03-2014

I ran it in SAS EG as soon as I start my session. see the log below. options memsize=512k; _______ 30 WARNING 30-12: SAS option MEMSIZE is valid only at startup of the SAS System. The SAS option is ignored.

RamKumar · ‎11-03-2014

When I tried to create charts (bar/pie) in SAS EG I got error as ERROR: Unable to allocate sufficient memory. At least 469K bytes were requested, but only 45K were available. You must either increase the amount of memory available, or approach the problem differently. ERROR: Driver SASGDGIF will not load. It went vain when I tried to increase the memsize=512k (options memsize=512k). I did ran the below code and found that MEMSIZE=4294967296 is allocated for my ID. Any ideas\tips to create charts in SAS EG?

RamKumar · ‎11-03-2014

Thanks for your patience and support. I'm bit confused with your term 'print that to ods tagsets'. May I request you to expand your language in SAS code? @RW9 From the document, I did tried the code 'ADDING NEW SPREADSHEET AND DATA' and I got the error ERROR: The Excel engine cannot be found since I installed SAS 9.3 with 32-bit in 64-bit machine. Any suggestions to overcome this error? Also it seems this document do not cover the code to produce excel sheet in a named range.

RamKumar · ‎11-03-2014

I already tried with the option sheet interval=none and sheet name='summary' for all my 3 proc report, but it is producing excel sheet in three different tabs called summary1,summary2 and summary3 whereas I need all the three reports merged into one tab horizontally.

RamKumar · ‎11-03-2014

Thanks for your guidance. Could you please advise how to generate the excel sheet with all the reports in a single tab? e.g. If I use 3 proc report then report should be displayed in a single tab. All the reports should be combined horizontally.

RamKumar · ‎10-31-2014

I'm using below codes to generate excel sheets via proc report. (SAS EG 5.1 MS Excel 2010) ODS HTML FILE='/data/indirect_report.xls' ; proc report data=rpt.&clint._All_inDir_CbRpt nowd missing out=work.indirect_report_all ; title1 'Indirect responses by product offers' ; columns ..... define .... run; ODS HTML FILE='/data/direct_report.xls' ; proc report data=rpt.&clint._All_Dir_CbRpt nowd missing out=work.indirect_report_all ; title1 'Indirect responses by product offers' ; columns ..... define .... run; ODS HTML FILE='/data/summary_report.xls' ; proc report data=rpt.&clint._All_summary_CbRpt nowd missing out=work.indirect_report_all ; title1 'Indirect responses by product offers' ; columns ..... define .... run; But I wish to generate the report in a single spreadsheet with multiple tabs instead of multiple excel sheets.e.g 3 ods statement with proc report should produce reports in single worksheet with 3 tabs instead of 3 excel sheets. Any help would be appreciated.

RamKumar · ‎10-29-2014

You can use if clause with last. to derive your variable. Replace this line lastpm=last.pm; with if last.time then variable=value;

RamKumar · ‎10-28-2014

I'm importing .csv file to SAS and it holds thousands of records as below. name Address Line 1 Address Line 2 VALERIE C SANDMIRE 1302 ELLENWOOD DR MADISON WI 53714-1006 JONAH Z HAUGLEY 884 HUNTERS TRL SUN PRAIRIE WI 53590-2585 DOROTHY A GENSKE 700 DOUGLAS TRL MADISON WI 53716-2125 I need to convert the SAS dataset as below after import. It means I need to derive 'state' and 'zip' variable from the variable 'address line 2'. name Address Line 1 Address Line 2 State zip VALERIE C SANDMIRE 1302 ELLENWOOD DR MADISON WI 53714 JONAH Z HAUGLEY 884 HUNTERS TRL SUN PRAIRIE WI 53590 DOROTHY A GENSKE 700 DOUGLAS TRL MADISON WI 53716 I tried to implement this via substr (tried from right to left to extract only numbers substr(Address Line 2,-1,-10)) and scan function but could not succeed. Please advise. Any help would be appreciated.

RamKumar · ‎10-16-2014

what does this line x = "x"; does in your code?

RamKumar · ‎10-13-2014

Have a look at proc transpose.

Online Status	Offline
Date Last Visited	‎09-07-2018 06:08 AM

Case Study with SAS Campaign Management

Sum and Group by

Time Series Analysis in Banking sector

Data reporting for decline in sales

Re: Reading a list of files and conditionally export the files

Read the file names and create a dataset

Re: Parameterized Job

Re: Parameterized Job

Re: Parameterized Job

Re: Proc SQL Explicit pass through and Memsize

Re: Data reporting for decline in sales

Re: Do loops not sure if I am using the right step

Re: how to import excel with headings

Re: how to import excel with headings

Re: first. and last.

Re: Proc SQL Substring

Re: problem with proc import

Re: how to stack variables in different columns?

Re: How to give unique id to group of similar values in a column?

Re: Create Multiple Files Conditionally

Re: Help on SAS Functions

Re: Client/server work flow(b/w EG and App server)

Re: How to increase memory to create charts?

Re: How to increase memory to create charts?

Re: How to increase memory to create charts?

Re: How to increase memory to create charts?

How to increase memory to create charts?

Re: ODS to generate multi sheet excel sheet via proc report

Re: ODS to generate multi sheet excel sheet via proc report

Re: ODS to generate multi sheet excel sheet via proc report

ODS to generate multi sheet excel sheet via proc report

Re: Saving the last/first observation as a variable

Need help on substr and scan function

Re: writing on excel

Re: how to stack variables in different columns?