About NN

NN · ‎09-26-2011

Hi, In proc print you can define the alignment for indivdual columns using the VAR and STYLE statements for example proc print data=sashelp.class noobs; var name sex; var age / style=[just=center]; run; Click here for one of the Papers That could prove useful

NN · ‎09-25-2011

Hi guys, I wish to use PROC IMPORT to import a .XLS file. Is it possible to import all my columns as character? Please guide

NN · ‎09-23-2011

Hi, Does this not work for you? proc print data = sashelp.class style(column)=[just=center]; run;

NN · ‎09-22-2011

would compress keeping your numeric values not work? compress(column,'0123456789','k')

NN · ‎09-22-2011

Hi, Angela what you have given is helpful but i dont think it would work in my scenario. Graham, Your idea of executing the process again will work but i wish to refrain from doing that. A sample code that i was aiming at is as below. in my Stored process i have closed the auto generated stored process macros. *HTML PART START; ods html body=_webout; proc print data=sashelp.class; run; ods html close; *HTML PART END; *CSV PART START; data _null_; /* Set HTTP headers */ rc = stpsrv_header('Content-type','application/vnd.ms-excel'); /* Prompt to SAVE or OPEN the attachment file named test.xls using Excel */ rc = stpsrv_header('Content-disposition','attachment; filename=test.csv'); run; data _null_; file _WEBOUT; do UNTIL (EOF); set sashelp.class end=eof; put @01 name $12. @17 sex $11. ; END; run; *CSV PART END;

NN · ‎09-14-2011

Hi, Will Proc export not work for you ?

NN · ‎09-13-2011

Hi, What i think would work is . In the sql query you could call an additional variable which is blank and then you can use that variable in the "Get label from" option . I remember trying this in 3.1 but cannot test or confirm it now.

NN · ‎09-12-2011

HI, In your stored process you can define a value for the variable _odsstyle. For example you could try %let _odsstyle=seaside; Hope this helps.

NN · ‎09-12-2011

Hi, Not so sure about 9.1 but we did try this in 9.2 for STP's only using a guest account. We used a direct url to the STP defining the _program _action _username & _password in the URL iteslf and it works fine. You can look into it and see if it works for you.

NN · ‎09-10-2011

Hi, Not sure but will this work. data a; infile datalines delimiter='|'; input a : $10. b : $10. c : $10.; datalines; 10549|6453|5582 10549|6453|5217 10549|6453|2871 10549|2001|5582 10549|2001|5217 10549|2001|2871 10548|9648|6453 10548|9648|3251 10548|9648|2205 10548|9453|6453 10548|9453|3251 10548|9453|2205 ; run; proc sort data=a; by descending a descending b descending c; run; data b; set a; by descending a descending b descending c; retain _b _c; format _b _c $100.; if first.a then do; _b=b; _c=c; flag=1; end; else do; if findw(_b,b,',','T')=0 then do; if findw(_c,c,',','T') = 0 then do; flag=1; _c=cats(_c,',', c); _b=cats(_b,',', b); end; end; end; if flag=1 then output; drop _b _c; run;

NN · ‎09-05-2011

Thanks a lot Art.This was extremely simple. Dont know why i keep complicating things. Hi Hobbes, Thanks for your response What you have given should work too.

NN · ‎09-05-2011

Hi Art, My aim is to create a fixedwidth file in the following manner first print the sex and names of all males second put a line "break here part 2" third print the sex and names of all females. What you have given is absolutely correct. But my problem arises if there are no Males in my data then the data for the females also doesnot get printed. So please guide on how to take this forward. Example data test; set sashelp.class; where sex = 'F'; run; data _null_; file print; do UNTIL (EOF); set test(where=(sex ='M')) end=eof; put @01 sex $12. @3 name $11. ; END; put 'break here part 2'; DO UNTIL ((EFF)); set test(where=(sex='F')) end=eff; x=_n_; put @01 sex $12. @3 name $11. ; END; run;

NN · ‎09-05-2011

Hi guys, I am trying to create a fixed width output file with the below code data _null_; file PRINT; do UNTIL (_N_ = EOF); set sashelp.class(where=(sex='M')) end=eof; put @01 sex $12. @3 name $11. ; END; put 'break here part 2'; DO UNTIL (_N_ = (EOF+1+EFF)); set sashelp.class(where=(sex='F')) end=eof; put @01 sex $12. @3 name $11. ; END; run; For the above code i get the correct ouput. But if i was to change this with the code below . Then no output generates because the SEX = 'FM' is not there in the table. but i was hoping that atleast the sex='F' values should get printed in the output. data _null_; file PRINT; do UNTIL (_N_ = EOF); set sashelp.class(where=(sex='FM')) end=eof; put @01 sex $12. @3 name $11. ; END; put 'break here part 2'; DO UNTIL (_N_ = (EOF+1+EFF)); set sashelp.class(where=(sex='F')) end=eof; put @01 sex $12. @3 name $11. ; END; run; Please do guide.

NN · ‎08-31-2011

Hi, I am not sure if this is what you are looking for. But if you read about the _debug macro in stored process it would help generate your required log.

NN · ‎08-26-2011

Hi, Read about spanned headers in proc report. to get your desired output you can try this proc report data = Consumpt nowd split ='\' ; column PAN ('Year' Year) Sector,High ('Total Consumption' High=stot) ; define PAN / group noprint ; define Year / group '' ; define Sector / across "" format = Sectorid. order = internal ; define High / "" analysis STYLE(column)={TAGATTR='format:#,##0'} ; define stot / '' sum STYLE(column)={TAGATTR='format:#,##0'} ; where put(PAN,Paid.) = "IID" ; quit ; This should work.

Online Status	Offline
Date Last Visited	‎05-17-2025 10:30 AM

Re: caslib - Projects path in Deny List

caslib - Projects path in Deny List

GET POST methods for SAS VIYA Model studio

Restore a Model Studio project in SAS Viya

Re: Get the value of a system option

Get the value of a system option

Re: Convert string to datetime ignore timezone

Convert string to datetime ignore timezone

Re: SSE-S3 encryption on SAS Connect to snowflake

Re: SSE-S3 encryption on SAS Connect to snowflake

Re: Convert string to datetime ignore timezone

Re: How to get source file path for deployed job

Re: How to get source file path for deployed job

Re: Remove unbalanced parentheses in a string

Re: Remove unbalanced parentheses in a string

Re: Get the value of a system option

Re: SSE-S3 encryption on SAS Connect to snowflake

Re: restrict length for sas dataset column read from sql nvarchar(max)

Re: How to get source file path for deployed job

Bulkload to postgresql on AIX

ODS PDF listing: table column values center alignment in SAS

Proc import excel - Default character

ODS PDF listing: table column values center alignment in SAS

CAT, CATT, CATX, TRIM

Overwrite _webout file for multiple outputs

Custom delimiter for text output

Remove value on KPI Dial

Change bgcolor of streaming HTML output

Remove authentication prompt

Fetching records with unique value

Please help with this small code.

Please help with this small code.

Please help with this small code.

How to see the generated code produced by a Stored Process without usi...

proc report and across