About sas_td2016

sas_td2016 · ‎02-25-2018

Hello Friends Can you please help me on this query? I want to get out put for the following file using list or modified list input. 2458 Murray, W 72 185 128 12 38 D 2462 Almers, C 68 171 133 10 5 I 2501 Bonaventure, T 78 177 139 11 13 I 2523 Johnson, R 69 162 114 9 42 S 2539 LaMance, K 75 168 141 11 46 D Thanks.

sas_td2016 · ‎06-10-2017

yes, I tried that too. It didn't work.

sas_td2016 · ‎06-10-2017

Thanks Kiran for your reply. Here is the actual code proc sql; insert into sql.mortage (loan_number, due_date, investor_numer, bankruptcy_flag, ltv) values (1000001, '01jan2016'd, 200001,'N',0.8) ; quit; is there any formatting required for date variable? output in sql server: How do I get the same date as 01jan2016 in sql server? In SQL Server the date shows as '1960-01-01 05:40:54:000 Thanks again.

sas_td2016 · ‎06-10-2017

Hello Friends I still don't understand what Reeza mentioning here. Can you please guide me on this? My output should be same on the sql server as my sql query on the SAS. Your help is highly appreciated.

sas_td2016 · ‎06-03-2017

yes, I tried. But SAS doesn't take this format.

sas_td2016 · ‎06-03-2017

Here is the actual code proc sql; insert into sql.mortage (loan_number, due_date, investor_numer, bankruptcy_flag, ltv) values (1000001, '01jan2016'd, 200001,'N',0.8) ; quit; is there any formatting required for date variable? output in sql server: How do I get the same date as 01jan2016 in sql server? Thanks

sas_td2016 · ‎06-03-2017

Thanks for a reply. But I still I see the different date than what I entered. Instead of 01Jan2016, it shows 1960-01-01.

sas_td2016 · ‎06-03-2017

Hello Friends I have an issue with date format. Can you please help me with this query? proc sql; insert into sql.mortage (loan_number, due_date, investor_numer, bankruptcy_flag, ltv) values (1000001,'01jan2016'd,200001,'N',0.8) ; quit; Outpout on Sql Server:

sas_td2016 · ‎05-28-2017

Thanks a lot. Highly appreciated. This works. I will check out the link you provided for more info.

sas_td2016 · ‎05-28-2017

Hello Friends I have the following programe. Can you please help me whether is there any issue with this code? DATA test5; INFORMAT LASTNAME $20. DOB MMDDYY8. GENDER $1.; INPUT ID LASTNAME $12. DOB mmddyy8. HEIGHT 2. WEIGHT 3. GENDER $1. AGE 2.; FORMAT DOB MMDDYY8.; DATALINES; 1 SMITH 1/23/66 68 144 M 26 2 JONES 3/14/60 78 202 M 32 3 DOE 11/26/47 62 99 F 45 4 WASHINGTON 8/1/70 66 101 F 22 Run; PROC PRINT; TITLE 'Example 3.1'; RUN; Thanks in advance.

sas_td2016 · ‎09-29-2016

Hello my friend I have made little modification on this file as below. But I am not getting output. Am I doing something wrong here? data flowersales; infile 'C:\Users\location\Documents\My SAS Files(32)\democode\tropicalsales.txt' dlm=','; length Variety $9; input customerID $ SalesDate mmddyy10. Variety $ quantity ; IF Variety = "&flowertype"; run; proc print data = flowersales; format SalesDate WORDDATE18.; TITLE "Sales of &flowertype"; run; data: 240W,02-07-2008,Ginger,120 240W,02-07-2008,Protea,180 356W,02-08-2008,Heliconia,60 356W,02-08-2008,Anthurium,300 188R,02-11-2008,Ginger,24 188R,02-11-2008,Anthurium,24 240W,02-12-2008,Heliconia,48 240W,02-12-2008,Protea,48 356W,02-12-2008,Ginger,240

sas_td2016 · ‎09-29-2016

Thanks for your quick reply. I really appreciate that. As you mentioned I modified the code as below; lenght Variety $9; input customerID $4. @6 SalesDate mmddyy10. @17 Variety $ @28 quantity 3.; Now it works. Thanks a lot 🙂

sas_td2016 · ‎09-29-2016

Hello Friends I am trying to run the following code, but I am not error message as Variable SALESDATE not found in data set WORK.FLOWERSALES. %LET flowertype = Ginger; data flowersales; input customerID $4. @6 SalesDate mmddyy10. @17 Variety $9. quantity 3.; IF Variety = "&flowertype"; datalines; 240W 02-07-2008 Ginger 120 240W 02-07-2008 Protea 180 356W 02-08-2008 Heliconia 60 356W 02-08-2008 Anthurium 300 188R 02-11-2008 Ginger 24 188R 02-11-2008 Anthurium 24 240W 02-12-2008 Heliconia 48 240W 02-12-2008 Protea 48 356W 02-12-2008 Ginger 240 ; run; proc print data = flowersales; format SalesDate WORDDATE18.; TITLE "Sales of &flowertype"; run; is there any wrong in the code? Your help is highly appreciated. Thanks

sas_td2016 · ‎09-24-2016

thanks for your input. So here we need not to use column input, right?

sas_td2016 · ‎09-24-2016

Thanks. It is working.

Online Status	Offline
Date Last Visited	‎10-30-2023 11:20 AM

Re: Informat error

Re: Informat error

Informat error

Re: SASHELP - getting an error

SASHELP - getting an error

Re: I can't access SAS univeristy edition virtual application

Re: I can't access SAS univeristy edition virtual application

Re: I can't access SAS univeristy edition virtual application

I can't access SAS univeristy edition virtual application

Re: Issue while running proc print

List Input or Modified List Input

Re: SQL Server Connectivity

Re: SQL Server Connectivity

Re: SQL Server Connectivity

Re: SQL Server Connectivity

Re: SQL Server Connectivity

Re: SQL Server Connectivity

SQL Server Connectivity

Re: Date / Time Formatting Issue

Date / Time Formatting Issue

Re: SAS Macro issue

Re: SAS Macro issue

SAS Macro issue

Re: Date / Time Formatting Issue

Re: Date / Time Formatting Issue