Using SAS studio,  my system is windows 10, 64 bit   raw txt file:   Ranch,1250,2,1,sheppard Avenue,"64,000" Split,1190,1,1,Rand Street,"65,850" Condo,1400,2,1.5,Market Street,"80,050" TwoStory,1810,4 3,Garris Street,"107,250" Ranch,1500,3,3,Kemble Avenue,"86,650" Split,1615,4,3,West Drive,"94,450" Split,1305,3,1.5,Graham Avenue,"73,650"     My code to import raw txt file:   data orion.locationrawfile; infile "/folders/myfolders/pg2/location.txt" dlm=',' dsd ; length price $15; length Address $20; input Style $  Zip Bedroom $ Baths $ Address Price $ ;   proc print data = orion.locationrawfile noobs; var Style Zip Bedroom Baths Address Price; run;   Output error:   First three observations has no $ dollar sign with price variable. 4th observation has bedroom, bath as dot , price comes in the address field and Ranch is listed as price. 6th and 7th observation have no dollar signs, 5th observation is missing.   Attaching output as pdf file. ... View more

Hi   I am writing this code below to export the file to excel, it shows excel file in the folder , when I try to open it, it says file is corrupt.   please advise if there is any problem in the code.     ods excel file='/folders/myfolders/pg2/rawdatapivotnov.xlsx' ;   proc summary data=orion.aaamonthlydata nway missing; class Amount_Financed System_decision lend_level;   output out= rawdatapivotnov; run; ods excel close;     I am running SAS Studio via Oracle VM Virtual box manager which I believe is Linux based, my laptop is windows based, is it a conflict of different environment that caused this excel file as corrupt, please advise.     ... View more

Hi   I am new to SAS, i imported the excel file by using the Import wizard. File has 8011 obsevations. I am using SAS studio and SAS EG as well.   Did the data segmentation uisng to capture data in different ranges. Run Proc freq , which still shows 8011 observations. Then run the proc summary to make this file as output so that I can export this file as excel file to run some pivot tables/chart. Proc summary shows i have 5297 observations instead of 8011.  Not sure why? if someone can shed some light on it.   My code is:   data orion.aaamonthlydata; length lend_level $10; set orion.rawdatamonthly; if amount_financed LE 75000 then Lend_Level ='Under75k'; else if (Amount_financed > 75000) and (Amount_financed<= 150000) then Lend_Level ='75-150k'; else if Amount_financed > 150000 and (Amount_financed<= 300000) then Lend_Level ='150k-300k'; else Lend_Level ='300k-500k'; run;     proc freq data=orion.aaamonthlydata order=freq; tables lend_level*system_decision / norow nocol nopercent nocum; title1 ' Volume Distribution '; run;   Result: 8011 total observations in the table.     proc summary data=orion.aaamonthlydata nway missing; class Amount_Financed System_decision lend_level; output out=orion.volumedist; run;   Only shows 5291 observations. Need to know why proc freq shows 8011 observationa and proc summary shows 5297 observations. please advise.   ... View more

Hi   I am new to SAS and learning SAS.   I am trying to work on thsi example to import this txt file which i created in notepad and its saved as txt file.   when i try to import file it says physical file doesnt exist , please advise. i have just typed this data in notepad to create this raw data :   RANCH,1250,2,1,Sheppard Avenue,"$64,000" SPLIT,1190,1,1,Rand Street,"$65,850" CONDO,1400,2,1.5,Market Street,"80,050" TWOSTORY,1810,4,3,Garris Street,"$107,250" RANCH,1500,3,3,Kemble Avenue,"$86,650" SPLIT,1615,4,3,West Drive,"94,450" SPLIT,1305,3,1.5,Graham Avenue,"$73,650"   saved this file as location.txt in note pad   now tried to import it :   data location1; infile 'C:\Users\tauqe\Documents\myfolders\location.txt' ; input style $ @; if style = 'CONDO' or style = 'RANCH'; input sqfeet bedrooms baths street $ price : dollar10.; run;   error message: ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\tauqe\Documents\myfolders\location.txt. NOTE: The SAS System stopped processing this step because of errors     please advise.   ... View more